FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

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: -For the Subtotal command to work properly, you must sort the rows into order by the first column.

Detailed explanation-4: -The term for specified Excel data that is indicated with a fill color, a horizontal bar, or an icon within the cell is: Data visualization. The basic Excel command that uses relational or comparison operators to determine if the value or label in a cell should be formatted is: Highlight Cells Rule.

There is 1 question to complete.
Previous
Next