Examsoon 的优势
1.Examsoon 模拟测试题具有最高的专业技术含量,只供具有相关专业知识的专家和学者学习和研究之用。
2.该测试已取得试题持有者和第三方的授权,我们深信IT业的专业人员和经理人有能力保证被授权产品的质量。
3.如果你使用 Examsoon 模拟测试,我们将保证你的第一次参加考试即取得成功,否则,我们将全额退款!
4.提供每种产品免费测试。在您决定购买之前,请检测联接,可能存在的问题及试题质量和适用性.
ICDL-Excel题库问题与答案赏析
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. Which formula would display 7% in cell D8 if the customers order value is over 10,000 and would display 0% if not.
A. =IF (D7=10,000,7%,0%)
B. =IF (D8>10000,7%,0%)
C. =IF (D7>10000,7%,0%)
D. =IF(D7<10000, 7%, 0%)
Answer: C
3. 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
4. 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
5. Which formula entered into E2 would calculate the total cost (including delivery) of a Barbados garden suite and, if copied down, would automatically calculate the total cost for the other two garden suites.
A. =SUM(B2:D2)+$B$6
B. =SUM(B3:D3)+$B$6
C. =SUM($B$2:$D$2)+B6
D. =SUM(B2:B42)+$B$6
Answer: A
6. 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
7. 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
8. Dragging the fill handle up to cell B3 will fill B3 with:
A. Envelopes
B. Pens
C. Paper
D. Stamps
Answer: B
9. Which formula entered into C12 would calculate the number of recorded rainfall readings taken over the 3 weeks?
A. =NUMBER(B4:D10)
B. =COUNT(B4:B10)+(C4:C10)+(D4:D10)
C. =COUNT(B4:D10)
D. =NUM(B4:D10)
Answer: C
10. 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
11. If the formula in B7 is copied to cell D7, which formula will display in the formula bar when D7 is selected?
A. =SUM(B3:B5)-B6
B. =SUM(C3:C5)-C6
C. =SUM(D3:D5)-B6
D. =SUM(D3:D5)-D6
Answer: D
12. Which TWO of the following would calculate the amount left to spend for March?
A. =D12-D8
B. =SUM(D4:D7)-SUM(D10:D11)
C. =(D10:D11)-(D4:D7)
D. =SUM(D10:D11)-SUM(D4:D7)
Answer: AD
13. 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
14. 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
免费下载ICDL-Excel认证考题Demo
免费下载ICDL-Excel PDF题库
ICDL-Excel考试是ICDL厂商最热门的科目,其考试的全称为:。在此我们收集了不同题库供应商的真题集 包含 : examsoon ICDL-Excel培训资料 ,Testinside ICDL-Excel考题讲解, Pass4sure ICDL-Excel题库 , Testking ICDL-Excel考试指南, exam4sure 真题材料.只要仔细阅读以下的ICDL-Excel题库demo的问题和答案, 相信你就会知道这个题库的质量了。
ICDL-Excel题库由多位IT认证的专家亲自整理的考试全真试题材料,为了让大家花更少的时间来完成ICDL ICDL-Excel考试. examsoon考题大师ICDL-Excel试题都是考试原题的完美组合,覆盖率95%以上,答案由多位专业资深讲师原版破解得出,正确率100%,只要您使用本站的考试题库参加ICDL-Excel考试,我们保证您一次轻松通过考试;