- Exam Number/Code : ICDL-Excel
- Exam Name :
- Questions and Answers : 88 Q&As
Download Pass4sure ICDL-Excel Dumps from the link below
Download CertifyMe ICDL-Excel Dumps from the link below
Download Testking ICDL-Excel Dumps from the link below
PrepKing.com ICDL ICDL-ExcelSample Questions
Exam : ICDL ICDL-Excel
Title : The ICDL L4 Excel Exam
1. Which formula would display 10% in cell C3 if the customer order quantity is over 300, and 0% if not.
A. =IF(C3>300,10%,0%)
B. =IF (B3>300, 10%, 0%)
C. =IF (B3>300, 0%, 10%)
D. =IF (B3<300, 10%, 0%)
Answer: B
2. If row 4 is deleted, which formula will then be in cell B6?
A. =SUM(B3:B6)
B. =SUM(B3:B5)
C. =B3+B4+B5
D. =SUM(B3:B7)
Answer: B
3. If the Enter key was pressed to accept the formula in cell B9, which of the following would be the result:
A. A #REF! error message
B. 9.3
C. A #VALUE error message
D. A #NAME? Error message
Answer: D
4. 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?
A. SUM($B$2:$B$4)+B8
B. =SUM(B2:B4)+$B$8
C. =SUM(B2:B5)+$B$8
D. =SUM(C2:C4)+$C$8
Answer: B
5. Which formula entered into B10 would find the total amount of rainfall that in the seven days?
A. =SUMB3:B9
B. =SUM(B3:B9)
C. =(SUM)B3:B9
D. SUM=(B3:B9)
Answer: B
6. Which formula entered into C3 would calculate the Total Cost of Barrels for the Oil Deco company and if copied down would automatically calculate the Total Cost for all the other customers.
A. =B3*C1
B. =B3*$C$1
C. =$B$3*$C$1
D. =$B$3*C1
Answer: B
7. Which one of the following formulas would be appropriate to calculate the monthly surplus for September in this worksheet?
A. =B5+B11
B. =SUM(B5:D5)-SUM(B11:D11)
C. = B5-B11
D. =AVERAGE(B5:D5)-AVERAGE(B11:D11)
Answer: C
8. If the Enter key was pressed to accept the formula in cell E9, which of the following would be the result:
A. A #REF! error message.
B. A #VALUE! error message.
C. A #NAME! error message.
D. A Circular Reference error message
Answer: D