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