The bar at the top of a Microsoft program
Ribbon
The intersection of a row and a column in Excel (example: A1)
cell (if clicked, active cell)
Which tab is used for adding Subtotals/Groups?
Data
In order to utilize the Subtotal feature, what must your data be?
A range, NOT a table
Before adding Subtotals automatically, what must you do to the data?
Sort on the "at each change" field
To be able to use structured references, your data needs to be:
Tables with column headings
What type of conditional formatting is this an example of?
Data bars
How was this bottom row added to the Excel table?
Table Tools> Total Row (auto adds subtotal feature)
To use Freeze panes, you must click which Ribbon tab?
View
To freeze the panes in this example so you can always see both the day of the week AND the times, click in which cell before freezing?
C4
How would you add a custom number filter in an Excel table (like showing sales over $200,000)?
Use the filter list arrow on the column heading and go to Number Filters
What function would be used to count HOW MANY classes HAVE SPACE LEFT by looking at number data?
=COUNT(range) **counts how many have numbers
Does this function contain a structured reference?
Yes (uses the table and column names)
