题目
EXC19E2 - Microsoft Excel 2019 Level 2 Module 8 Quiz
判断题
True or false? PivotTable data should contain no formulas.
选项
A.True
B.False
查看解析
标准答案
Please login to view
思路分析
Question restated: The statement asks whether PivotTable data should contain no formulas, with options True or False.
Option 1: True. This claim would mean PivotTable data must be free of any formulas. In practice, this is not accurate because PivotTables can rely on underlying data that contains formulas, and they can also incorporate formulas within the PivotTable itself via calcul......Login to view full explanation登录即可查看完整答案
我们收录了全球超50000道考试原题与详细解析,现在登录,立即获得答案。
类似问题
True or false? A PivotChart is a graphical representation of a PivotTable.
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?
更多留学生实用工具
希望你的学习变得更简单
加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！