Multiple Choice
A worksheet of faculty members at your university contains these columns in this sequence: Rank, Last Name, First Name, Department, and Salary.What is the first step to subtotal departmental salaries?
A) Sort by Last Name
B) Sort by Salary
C) Sort by Rank
D) Sort by Department
Correct Answer:
Verified
Correct Answer:
Verified
Q90: Displaying subtotals at the top or bottom
Q91: The % Period Expense Column on this
Q92: A PivotChart has no filters available.
Q93: A slicer has a window with a
Q94: Which function is not a Subtotal function?<br>A)MAX<br>B)SUM<br>C)AGGREGATE<br>D)AVERAGE
Q96: PivotTables _ or summarize large amounts of
Q97: You have a PivotTable with 2 fields
Q98: A(n)_ is an interactive table which uses
Q99: _ Analysis is the built-in tool which
Q100: Match each of the following PivotTable summary