ICDL L4 Excel Exam

Certification Provider: ICDL

Exam Name: ICDL L4 Excel

Number of questions in our database: 88

Exam Version: Aug. 03, 2022

ICDL L4 Excel Exam Official Topics:

Free ICDL ICDL L4 Excel Exam Actual Questions

Question #1

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

Reveal Solution

Correct Answer: C

Question #2

Which formula entered into B10 would find the average amount of sunshie for March to September?

AAVERAGE=B4

B(AVG)B3:B9

CAVERAGE(B3:B9)

DAVG(B3:B9)

Reveal Solution

Correct Answer: C

Question #3

Change the formatting for the selected column so the dates display in this format: 04-mar-02

AOption A
Format -> cells -> select date -> select 04-Mar-02 -> ok

Reveal Solution

Correct Answer: A

Question #4

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

Reveal Solution

Correct Answer: A

Question #5

Center align the text in the selected cells horizontally.

AOption A
Click the center tool from the formatting toolbar

Reveal Solution

Correct Answer: A

Unlock all ICDL L4 Excel Exam Questions with Advanced Practice Test Features:

Get Full Access Now

Disscuss ICDL ICDL L4 Excel Topics, Questions or Ask Anything Related

Submit Cancel