ICDL icdl-excel practice test
ICDL L4 Excel Exam
Question 1
Display the Drawing toolbar in the Microsoft Excel application window.
- A. View -> Toolbars -> Drawing
Answer:
A
Question 2
Close this workbook without closing the application.
- A. File -> close
Answer:
A
Question 3
Enter a formule in cell D4 using cell references that would calculate the Take home pay for Cathy
Miller. Press the Enter key when you have finished.
- A. Type = B4-C4
Answer:
A
Question 4
Insert a new column between columns A and B in this worksheet.
- A. Select the column B -> insert -> columns
Answer:
A
Question 5
Freeze both the column A and row 1 titles in this worksheet.
- A. Select the cell B2 -> window -> select freeze pane
Answer:
A
Question 6
Save this workbook as a text file.
- A. File -> save as -> in the save as type -> from the drop down list -> choose text (Tab delimited) -> save
Answer:
A
Question 7
Change the page orientation so that this worksheet will print on a page that is wider than it is tall.
- A. File -> page setup -> select landscape -> ok
Answer:
A
Question 8
Center align the text in the selected cells horizontally.
- A. Click the center tool from the formatting toolbar
Answer:
A
Question 9
Change the formatting so the selected text automatically wraps onto a second line within the cell.
- A. Format -> cells -> select Alignment tab -> check the wrap text -> ok
Answer:
A
Question 10
Change the formatting for the selected column so the dates display in this format: 04-mar-02
- A. Format -> cells -> select date -> select 04-Mar-02 -> ok
Answer:
A