Name: ICDL L4 Excel
Brand: ValidExamDumps
SKU: ICDL-Excel
Price: 20 USD
Availability: InStock
Rating: 5.0 (370 reviews)

Free ICDL ICDL-Excel Exam Actual Questions

Question No. 1

Type a formula into cell G8 which uses an appropriate function to calculate the total of the highlighted range.

AOption A
Type =sum (f5:f7) -> press enter from the keyboard

Show Answer

Correct Answer: A

Question No. 2

Which one of these combinations is used to indicate that cell C1 has an absolute reference?

A?C?1

B#C#1

C$c$1

D/C/1

Show Answer

Correct Answer: C

Question No. 3

Change this column chart to a Bar Chart.

AOption A
Click on the arrow in the chart type tool in the chart tool bar -> select bar chart

Show Answer

Correct Answer: A

Question No. 4

Save this workbook as a text file.

AOption A
File -> save as -> in the save as type -> from the drop down list -> choose text (Tab delimited) -> save

Show Answer

Correct Answer: A

Question No. 5

Change the formatting so the selected text automatically wraps onto a second line within the cell.

AOption A
Format -> cells -> select Alignment tab -> check the wrap text -> ok

Show Answer

Correct Answer: A