ICDL ICDL-EXCEL Exam
ICDL Excel Exam (Page 2 )

Updated On: 30-Jan-2026

Open the Samples.xls workbook that is in the My Documents folder.

  1. File -> open -> select the samples.xls -> open

Answer(s): A



Which formula entered into B10 would find the heaviest rainfall in the seven days?

  1. =MAXIMUM(B3:B9)
  2. (MAX B3:B9)
  3. =MAXIMUM(B3:B10)
  4. =MAX(B3:B9)

Answer(s): D



If the formula in B7 is copied to cell D7, which formula will display in the formula bar when D7 is selected?

  1. =SUM(B3:B5)-B6
  2. =SUM(C3:C5)-C6
  3. =SUM(D3:D5)-B6
  4. =SUM(D3:D5)-D6

Answer(s): D



Change the alignment of the selected title Projected Earnings, so that it is centred horizontally over columns B, C and D.

  1. Format -> cells -> Alignment -> from the drop down list of the Horizontal -> select center Across Selection

Answer(s): A



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

  1. 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

Answer(s): A



Viewing page 2 of 19
Viewing questions 6 - 10 out of 88 questions



Post your Comments and Discuss ICDL ICDL-EXCEL exam prep with other Community members:

Join the ICDL-EXCEL Discussion