Just4exam.com ICDL-Excel Exam Description
ICDL ICDL-Excel exam training is available in various formats to best suit your needs and learning style from Just4exam.com. Whether you are a hands-on tactile learner, visually or even a textbook training veteran, we has the ICDL-Excel resources that will guarantee you to pass your exam ICDL-Excel at the first time!
Just4exam.com ICDL-Excel Exam Detail
Exam Number/Code : ICDL-Excel
Exam Name :
Questions and Answers : 88
Update Time: 2009-11-13
Just4exam.com Exam ICDL-Excel test questions provides you everything you will need to take your ICDL-Excel Exam. The ICDL-Excel Exam details are researched and produced by Professional ICDL Certification. Experts who are constantly using industry experience to produce precise, logical and verified explanations for the answers.Our ICDL-Excel practice tests will make you feel like you will pass an actual exam at a Prometric or VUE center.
ICDL-Excel braindumps free download
If you are interested in our ICDL-Excel exam questions,first you can view a part of our latest dumps here:
Exam : ICDL ICDL-Excel
Title : The ICDL L4 Excel Exam
1. 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
2. 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
3. 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
4. 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
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?
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
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
Also you can free download it here:ICDL-Excel pdf
100% Guarantee to Pass Your ICDL-Excel Exam
Just4exam.com provides the most competitive quality of all exams for the customers,we guarantee your success at the first attempt with only our Certification Question and Answers,if somehow you do not pass the exam at the first time, we will not only arrange FULL REFUND for you, but also provide you another exam of your claim, ABSOLUTELY FREE!
Are you ready?With Just4exam.com ICDL-Excel exam study materail, your ultimate success in ICDL ICDL-Excel Certification Exam is no more a dream. Just4exam.com guarantees your passing ICDL ICDL-Excel Certification Exam.Good luck!
