Question 1

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

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

Answer : A

Question 2

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

A=SUM(B3:B5)-B6

B=SUM(C3:C5)-C6

C=SUM(D3:D5)-B6

D=SUM(D3:D5)-D6

Answer : D

Question 3

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

A=MAXIMUM(B3:B9)

B(MAX B3:B9)

C=MAXIMUM(B3:B10)

D=MAX(B3:B9)

Answer : D

Question 4

Type a formula into cell F8 using the appropriate function to calculate the greatest value in the highlighted range. Press the Enter key when you have finished.

AOption A
Type = max (F5:F7) -> press enter from the keyboard

Answer : A

Question 5

Change the formatting so the selected text automatically wraps onto a second line within the cell.

AOption A
Format -> cells -> select Alignment tab -> check the wrap text -> ok

Answer : A

Free Practice Questions for ICDL-Excel Exam

Question 1

Question 2

Question 3

Question 4

Question 5