The intersection of a row and a column in Excel (example: A1)
cell (if clicked, active cell)
Does this function contain a structured reference?
Yes (uses the table and column names)
What Excel chart part is identified in yellow?
Data Labels
What type of Excel chart is this?
histogram
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
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
What SPECIFIC type of chart is this?
Donut
What SPECIFIC type of chart is this?
3D Clustered Column
What chart part is marked in yellow highlight? Be specific.
Y Axis
Before adding Subtotals automatically, what must you do to the data?
Sort on the "at each change" field
Which tab is used for adding Subtotals/Groups?
Data
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
In order to utilize the Subtotal feature, what must your data be?
A range, NOT a table
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 type of conditional formatting is this an example of?
Data bars
To be able to use structured references, your data needs to be:
Tables with column headings
How do you sort on two levels, such as all Last Name and then on First Name?
Custom Sort; sort on two levels
What Excel chart part is identified in yellow?
Legend
What is this box called and what is it used for?
Slicer; filters data
The bar at the top of a Microsoft program
Ribbon