ICDL-Excel Exam Questions

Name: ICDL ICDL-Excel Exam
Brand: Pass4Success
SKU: ICDL-Excel
Price: 69.00 USD
Availability: InStock
Rating: 4.8 (175 reviews)

Status: RETIRED

Exam Name: ICDL L4 Excel

Exam Code: ICDL-Excel

Related Certification(s): ICDL Full ICDL Certification

Certification Provider: ICDL

Number of ICDL-Excel practice questions in our database: 88 (updated: 07-08-2024)

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

Submit Cancel

Fabiola

9 months ago

Just passed the ICDL L4 Excel exam! Pivotal topic: PivotTables. Expect questions on creating and manipulating PivotTables with multiple data sources. Focus on understanding how to group data and create calculated fields. Thanks to Pass4Success for the spot-on practice questions that helped me prepare efficiently!

upvoted 0 times

...

Free ICDL ICDL-Excel Exam Actual Questions

Note: Premium Questions for ICDL-Excel were last updated On 07-08-2024 (see below)

Question #1

Change the name of the worksheet from Sheet2 to Costs.

AOption A
Right click on the sheet2 tab -> select rename -> type Costs

Reveal Solution

Correct Answer: A

Question #2

Adjust the page setup so that the entire contents of this worksheet will fit on 1 page wide by 3 pages tall.

AOption A
File -> select page setup -> delete number 4 and type 3 -> ok

Reveal Solution

Correct Answer: A

Question #3

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

Reveal Solution

Correct Answer: A

Question #4

Format the contents of the selected cell bold.

AOption A
Click on the bold tool from the formatting tool bar

Reveal Solution

Correct Answer: A

Question #5

Which formula entered into B5 will calculate the total cost of a Colonial style chair (including delivery) and if copied to C5 will perform a similar calculation for the Metro style chair?

ASUM($B$2:$B$4)+B8

B=SUM(B2:B4)+$B$8

C=SUM(B2:B5)+$B$8

D=SUM(C2:C4)+$C$8

Reveal Solution

Correct Answer: B

Unlock Premium ICDL-Excel Exam Questions with Advanced Practice Test Features:

Select Question Types you want
Set your Desired Pass Percentage
Allocate Time (Hours : Minutes)
Create Multiple Practice tests with Limited Questions
Customer Support

Get Full Access Now