CWNP certification

　
　
Exam : ICDL ICDL-Excel
Title : The ICDL L4 Excel Exam


1. 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

2. 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

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 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

5. 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

superexamprep has assembled to take you through 120 Q&As to your ICDL-Excel Exam preparation. In the ICDL-Excel exam resources, you will cover every field and category in ICDL-Excel helping to ready you for your successful Juniper Certification.

Quality and Value for the ICDL-Excel Exam

superexamprep Practice Exams for ICDL ICDL-Excel are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your ICDL-Excel Exam

If you prepare for the exam using our superexamprep testing engine, we guarantee your success in the first attempt. If you do not pass the ICDL ICDL-Excel exam () on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.

ICDL ICDL-Excel Downloadable, Printable Exams (in PDF format)

Our Exam ICDL-Excel Preparation Material provides you everything you will need to take your ICDL-Excel Exam. The ICDL-Excel Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.

ICDL-Excel Downloadable, Interactive Testing engines

We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our Exam Preparation Material provides you everything you will need to take a certification examination. Like actual certification exams, our Practice Tests are in multiple-choice (MCQs)

Our ICDL ICDL ICDL-Excel Exam will provide you with exam questions with verified answers that reflect the actual exam. These questions and answers provide you with the experience of taking the actual test. High quality and Value for the ICDL-Excel Exam:100% Guarantee to Pass Your ICDL exam and get your ICDL Certification.