题目
题目

EXC19E2 - Microsoft Excel 2019 Level 2 Final Exam - Online Exam for Course Content

判断题

True or false? A PivotChart is a graphical representation of a PivotTable.

选项
A.True
B.False
查看解析

查看解析

标准答案
Please login to view
思路分析
To start, let’s unpack the relationship between PivotTables and PivotCharts in a practical, classroom-friendly way. Option 1: True. A PivotChart is indeed a graphical representation that visualizes th......Login to view full explanation

登录即可查看完整答案

我们收录了全球超50000道考试原题与详细解析,现在登录,立即获得答案。

类似问题

True or false? PivotTable data should contain no formulas.

True or false? Any changes made to a PivotChart will not be reflected in its associated PivotTable unless they are manually applied. 

Part 1The steps you will follow for this project are as​ follows:Download the Excel spreadsheet.opens in a new tab Perform the requirements LOADING... on the data. Use your Excel solution to answer the six multiple choice questions below. ​(You will have to scroll down to see all of the​ questions.) As you answer the​ questions, resize windows as needed to see all relevant data. Part 1This project only has one attempt per​ question, unless your instructor has provided additional attempts. Review your spreadsheet before answering the questions. [table] | Save Accounting Table... | | + | Copy to Clipboard... | | + [/table] [table] Using the PivotTable that you created, what is the sum of the invoice balance for the 31-60 day category? [/table] A.$ 5,075.12 $ 5,075.12$5,075.12 B.$ 6,217.71 $ 6,217.71$6,217.71 C.$ 725.02 $ 725.02$725.02 D.$ 51,186.14 $ 51,186.14$51,186.14 [table] | Save Accounting Table... | | + | Copy to Clipboard... | | + [/table] [table] Using the PivotTable that you created, how many invoices fall into the 61-90 day category? [/table] A. 5 B. 12 C. 100 D.$ 518.14 $ 518.14$518.14 [table] | Save Accounting Table... | | + | Copy to Clipboard... | | + [/table] [table] Using the PivotTable that you created, what is the average balance of the invoices in the over 90 day category? [/table] A.$ 511.86 $ 511.86$511.86 B.$ 3,156.14 $ 3,156.14$3,156.14 C.$ 483.38 $ 483.38$483.38 D.$ 631.23 $ 631.23$631.23 [table] | Save Accounting Table... | | + | Copy to Clipboard... | | + [/table] [table] Using the PivotTable that you created, what amount of invoices are outstanding for Salesperson F in the 61-90 day category? [/table] A.$ 6,552.56 $ 6,552.56$6,552.56 B.$ 8,240.58 $ 8,240.58$8,240.58 C.$ 5,862.46 $ 5,862.46$5,862.46 D.$ 2,378.12 $ 2,378.12$2,378.12 [table] | Save Accounting Table... | | + | Copy to Clipboard... | | + [/table] [table] What is the formula used in column G to determine the aging group of the invoice? [/table] A.LOOKUP left parenthesis Upper F 4,$I$ 2 :$J$ 5,2 right parenthesis LOOKUP left parenthesis Upper F 4,$I$ 2 :$J$ 5,2 right parenthesisLOOKUP(F4,$I$2:$J$5,2) B.VLOOKUP left parenthesis Upper F 4,$K$ 2 :$L$ 5,2 right parenthesis VLOOKUP left parenthesis Upper F 4,$K$ 2 :$L$ 5,2 right parenthesisVLOOKUP(F4,$K$2:$L$5,2) C.HLOOKUP left parenthesis Upper F 4,$K$ 2 :$L$ 5,2 right parenthesis HLOOKUP left parenthesis Upper F 4,$K$ 2 :$L$ 5,2 right parenthesisHLOOKUP(F4,$K$2:$L$5,2) D.LOOKUP left parenthesis Upper F 4,$K$ 2 :$L$ 5,2 right parenthesis LOOKUP left parenthesis Upper F 4,$K$ 2 :$L$ 5,2 right parenthesisLOOKUP(F4,$K$2:$L$5,2) [table] | Save Accounting Table... | | + | Copy to Clipboard... | | + [/table] [table] Using the PivotTable that you created, what amount of invoices are outstanding in the over 90 day category for the South region? [/table] A.$ 11,191.83 $ 11,191.83$11,191.83 B.$ 905.95 $ 905.95$905.95 C.$ 6,201.93 $ 6,201.93$6,201.93 D.$ 3,639.51 $ 3,639.51$3,639.51

Which one of the following statements is not true concerning PivotTables in Excel?

更多留学生实用工具

加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！