ICDL The ICDL L4 excel - ICDL-EXCEL Exam Questions [2026]

QUESTION NO: 1
Change the contents of cell B2 to the world Cost. Press Enter when you have finished.

A. Option A
Select cell B2 -> type Cost -> press Enter

Correct Answer: A

QUESTION NO: 2
Which formula entered into B10 would find the average amount of sunshie for March to September?

A. AVERAGE(B3:B9) B. (AVG)B3:B9 C. AVG(B3:B9) D. AVERAGE=B4

Correct Answer: A

QUESTION NO: 3
Change the settings for this worksheet so that the gridlines will print.

A. Option A
File -> select page setup -> select sheet tab -> check the gridlines in the print section

Correct Answer: A

QUESTION NO: 4
Copy the selected range and paste it into cell A1 in the worksheet entitled Marketing in this workbook.

A. Option A
Click copy from the standard tool bar -> select the Marketing worksheet -> click paste from the standard tool bar

Correct Answer: A

QUESTION NO: 5
Which formula entered into B5 will calculate the total cost of a Colonial style chair (including delivery) and if copied to C5 will perform a similar calculation for the Metro style chair?

A. =SUM(B2:B4)+$B$8 B. SUM($B$2:$B$4)+B8 C. =SUM(C2:C4)+$C$8 D. =SUM(B2:B5)+$B$8

Correct Answer: A

QUESTION NO: 6
Insert the file name field into the centre section of the header for this worksheet.

A. Option A
View -> select Header and Footer -> click custom Header -> click in the center section -> click on -> ok -> ok

Correct Answer: A

QUESTION NO: 7
Copy the entire Trees worksheet from this workbook into the Contracts workbook, so that it displays after Sheet1.

A. Option A
Right click on the Trees worksheet tab -> select move or copy -> check the create a copy -> from the to book drop down list select the Contracts workbook -> select (move to end) -> ok

Correct Answer: A

QUESTION NO: 8
Cut the selected range and paste it into cell A1 on the worksheet entitled Qtr 3 in this workbook.

A. Option A
Click on the cut tool from the standard tool bar -> select the Qtr3 sheet -> select cell A1 -> click on the paste tool from the standard tool bar

Correct Answer: A

QUESTION NO: 9
Preview the worksheet to see how it will look when printed.

A. Option A
File -> select print preview

Correct Answer: A