ICDL-Excel Exam Practice Test Instant Access

Question 1

Type a function into cell F8 that will calculate the smallest value in the highlighted range. Press the Enter key when you have finished.

AOption A
Type = min (F5:F7) -> press Enter

Answer : A

Question 2

Save this workbook (which is currently a Microsoft Excel 2000 file) in a format suitable for users with a previous version of Excel.

AOption A
File -> save as -> select Microsoft excel 5.0/95 work book from save as type -> click save

Answer : A

Question 3

Insert a new worksheet into this workbook.

AOption A
Right click on the sales worksheet -> select insert -> ok

Answer : A

Question 4

Create a new, blank workbook.

AOption A
Click new tool from the standard tool bar

Answer : A

Question 5

Clear the contents of cell B3 without deleting the cell.

AOption A
Select the cell B3 -> press the delete key from the keyboard

Answer : A

Question 6

Copy the selected range and paste it into cell A1 in the worksheet entitled Marketing in this workbook.

AOption A
Click copy from the standard tool bar -> select the Marketing worksheet -> click paste from the standard tool bar

Answer : A

Question 7

If the Enter key was pressed to accept the formula in cell E9, which of the following would be the result:

AA #REF! error message.

BA #VALUE! error message.

CA #NAME! error message.

DA Circular Reference error message

Answer : D

ICDL L4 Excel ICDL-Excel Exam Practice Test