ICDL-Excel Exam Practice Test Instant Access

Question 1

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

Question 2

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

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 5

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 6

Add a page footer with the text Confidential that will print at the botton left of all the pages in this woksheet.

AOption A
View -> Header and footer -> click on the custom footer -> type Confidential

Answer : A

Question 7

Change the white background colour of the chart to yellow.

AOption A
Click the arrow in the chart tool bar -> select the chart area -> click on the format Chart area tool -> select the yellow color -> ok

Answer : A

ICDL L4 Excel Exam Practice Test