FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

WORKBOOK THEMES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
When you use Excel’s subtotal command your list data is formatted as a(n):
A
Outline
B
Table
C
Worksheet
D
Record
E
Group
Explanation: 

Detailed explanation-1: -How does the Subtotal command format the list data? A. It doesn’t format the list data. In an Excel table, which of the following contains descriptive titles or labels?

Detailed explanation-2: -The Subtotal command is not available when the range is formatted as an Excel table, because a table has its own total and sorting commands. A PivotTable is a summary report based on a list-type range of data in a worksheet. When using an Advanced Filter, the criteria range must be at least three rows.

Detailed explanation-3: -If the workbook is set to automatically calculate formulas, the Subtotal command recalculates subtotal and grand total values automatically as you edit the detail data. The Subtotal command also outlines the list so that you can display and hide the detail rows for each subtotal.

Detailed explanation-4: -For the Subtotal command to work properly, you must sort the rows into order by the first column.

There is 1 question to complete.
Previous
Next