题目
单项选择题
Which one of the following statements is not true concerning PivotTables in Excel?
查看解析
标准答案
Please login to view
思路分析
To tackle the question, we first restate the prompt: Which statement about PivotTables in Excel is not true? The provided option is: PivotTables can only be used if one variable is categorical and the other is quantitative data.
Now we examine the claim. PivotTables are flexible tools in Excel that allow summa......Login to view full explanation登录即可查看完整答案
我们收录了全球超50000道考试原题与详细解析,现在登录,立即获得答案。
类似问题
True or false? A PivotChart is a graphical representation of a PivotTable.
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
更多留学生实用工具
希望你的学习变得更简单
加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！