ICDL The ICDL L4 excel - ICDL-EXCEL FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Print 3 copies of this worksheet.

A. Option A
File -> select print -> in the number of copies use the arrow to make it 3 -> ok

Discussion 0

Correct Answer: A Vote an answer

Question 2

Which TWO of the following would calculate the amount left to spend for March?

A. =(D10:D11)-(D4:D7) B. =SUM(D4:D7)-SUM(D10:D11) C. =SUM(D10:D11)-SUM(D4:D7) D. =D12-D8

Discussion 0

Correct Answer: C,D Vote an answer

Question 3

Apply the Percentage style to the selected cells.

A. Option A
Click on the percent style tool from the formatting tool bar

Discussion 0

Correct Answer: A Vote an answer

Question 4

Change the alignment of the selected title Projected Earnings, so that it is centred horizontally over columns B, C and D.

A. Option A
Format -> cells -> Alignment -> from the drop down list of the Horizontal -> select center Across Selection

Discussion 0

Correct Answer: A Vote an answer

Question 5

Cut the selected range and paste it into cell A1 on the worksheet entitled Qtr 3 in this workbook.

A. Option A
Click on the cut tool from the standard tool bar -> select the Qtr3 sheet -> select cell A1 -> click on the paste tool from the standard tool bar

Discussion 0

Correct Answer: A Vote an answer

Question 6

Which formula would display 10% in cell C3 if the customer order quantity is over 300, and 0% if not.

A. =IF (B3>300, 0%, 10%) B. =IF (B3<300, 10%, 0%) C. =IF(C3>300,10%,0%) D. =IF (B3>300, 10%, 0%)

Discussion 0

Correct Answer: D Vote an answer

Question 7

Create a new, blank workbook.

A. Option A
Click new tool from the standard tool bar

Discussion 0

Correct Answer: A Vote an answer

Question 8

Save this workbook as a text file.

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

Discussion 0

Correct Answer: A Vote an answer

Question 9

Apply the Pound (?) currency symbol to the selected numbers.

A. Option A
Format -> select cells -> select currency from the category -> select ? English (United Kingdom) -> ok

Discussion 0

Correct Answer: A Vote an answer