ICDL-Excel Exam Practice Test Instant Access

Question 1

Apply the Percentage style to the selected cells.

AOption A
Click on the percent style tool from the formatting tool bar

Answer : A

Question 2

If the Enter key was pressed to accept the formula in cell E8, what would appear in the cell?

A#REF!

B6,000

C#VALUE!

D#NAME!

Answer : C

Question 3

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 4

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 5

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 6

Use the Find tool to find the name Kim Brown in this worksheet.

AOption A
Edit -> find -> type Kim Brown -> click on the find next button

Answer : A

Question 7

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

AOption 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

Answer : A

ICDL L4 Excel Exam Practice Test

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7