It's all general
Ribbon
The tab that holds many tools, mostly specific to text and number format.
Home
This allows you to save the font size/color and cell fill color/border to the library to use again in the future.
New cell style
This adds up all numbers in a specified range.
This option allows a picture to be inserted based on the data you have selected.
Chart
These are found in the ribbon, categorizing similar tools in the same place.
Tabs & groups
The three shortcut views found on the bottom right of a sheet include normal, page layout, and this.
Page break preview
This tool edits the style of your data based on the rule you set.
Conditional formatting
This tool is based on logical reasoning, allowing you to return values with this logical syntax.
IF
This tab provides additional formatting options for the highlighted chart.
Here is where students must save their work.
H drive>Excel
This function can be used in a variety of ways to calculate basic mathematical functions.
When formatting data, these are the two options to 'fill' cells with color.
Solid & gradient
In order to use absolutes in a specific function syntax, you must include these & where?
$ sign in front of the row and the column
Ex. $V$5
This is where you can add/edit/remove chart elements.
HINT: there are two answers.
Add Chart element (in chart layouts group)
Format chart panel (click + on the chart)
This provides the option to look for an item you cannot locate.
Search bar
This tool allows you to determine the part of the sheet needing printed.
To format data based on a rule you set, the three style/format options to choose from include icon sets, color scales, and this.
Data bars
A nested function includes multiple sets of these & begins with this formula first.
Parentheses & the function in the nested parentheses
Ex. =ROUND((SUM(F5:K10))*60/2))
This is included in a table to provide a visual of high & low points within the data.
Sparklines
This option allows users to easily find shortcuts to tools without accessing the ribbon.
Quick access toolbar
This is where & how you can remove automatic page breaks from an active worksheet.
This is Connor & Jackson's favorite tool and one that tripped them up, thanks to Connor deleting a formula.
Goal seek
This feature provides options to find specific data in a table and return something that is either true or false.
VLookup
A tool typically used on a scatter chart that indicates the data being highlighted.
Data callouts