ICDL L4 Excel Exam Practice Test

Page: 1 / 14
Total 88 questions

Question 1

Apply the Percentage style to the selected cells.



Answer : A

Question 2

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



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.



Answer : A

Question 4

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



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?



Answer : D

Question 6

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



Answer : A

Question 7

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



Answer : A

Page:    1 / 14   
Total 88 questions