Which one of the following statements is not true concerning PivotTables in Excel?
a. PivotTables are also known as crosstabulation tables.
b. PivotTables summarize data for two variables.
c. PivotTables are interactive.
d. PivotTables summarize only categorical and quantitative data.
d
RATIONALE: A useful type of table for describing data of two variables is a crosstabulation, which provides a tabular summary of data for two variables. Quality ratings are an example of categorical data, and meal prices are an example of quantitative data. A crosstabulation in Microsoft Excel is known as a PivotTable. PivotTables in Excel are interactive, and may be used to display statistics other than a simple count of items.
You might also like to view...
Upon receipt of customers' checks in the mailroom, a responsible employee should prepare a control listing. A copy of the listing should be sent to the:
A. treasurer to compare the listing with the monthly bank statement. B. internal auditor to investigate the listing for unusual transactions. C. accounts receivable bookkeeper to update the subsidiary accounts receivable records. D. entity's bank to compare the listing with the deposit slip.
Cash dividends become a liability of a corporation when the stock goes ex-dividend
Indicate whether the statement is true or false
In column D, a 1 indicates that the project will be selected and a 0 otherwise. If you want to find the cost weighted average IRR of just those projects that are selected, which array formula in B7 would be correct?
a) =SUM(B2:B5 *$D2:$D5)/B6
b) {=SUM(B2:B5/B6*C2:C5*$D2:$D5)}
c) =SUM(B2:B5/B6*C2:C5*$D2:$D5)
d) {=SUM(B2:B5/B6*$D2:$D5) }
Publicity differs dramatically from advertising, but it typically costs much more than advertising
Indicate whether the statement is true or false