ICDL L4 Excel ICDL-Excel Exam Questions

Page: 1 / 14
Total 88 questions

Want more questions? Get Premium Access.
()

Question 1

Add a border around the selected range.

AOption A
Click the arrow in the borders tool from formatting tool bar -> select out side borders

Answer : A

Question 2

Open the Samples.xls workbook that is in the My Documents folder.

AOption A
File -> open -> select the samples.xls -> open

Answer : A

Question 3

Select the range of cells A2 to B6. Launch the Chart Wizard, and choose a Pie Chart. Click Finish to submit your answer.

AOption A
Select the range -> insert -> select chart -> select pie in the chart type -> click finish

Answer : A

Question 4

Click on the location that selects all of the cells in column C.

AOption A
Click on the gray area of the column c

Answer : A

Question 5

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

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