Menu Items
The Excel menu that contains the "Insert" option.
What is the Insert tab
I return the sum of a range.
What is SUM?
I always must be used in a formula.
What is =?
This is how I make text bold.
What is use the Bold Button or CTRL+B?
I am used to quickly apply a preset combination of font, fill, and number forma to a cell.
What are cell styles?
Conditional formatting is found on this menu.
What is the Home tab?
I calculate the average of a series of numbers.
What is AVERAGE?
I am used to reference a cell in a formula.
What is A1 (Column, Row)?
I am an option that changes the cell background color.
What is Fill Color?
I modify a workbook's overall colors and fonts that many styles use.
What is Page Layout Tab -> Themes?
PivotTables are found on this menu.
What is the Insert tab?
I get the number of numeric values only.
What is COUNT?
I am a formula that adds A1 to B1.
What is =A1+B1?
Currency format is applied by using this option.
What is Format Cells -> Currency?
I am the best option to highlight input cells for data entry.
What is input style?
How I setup my page is located on this tab.
What is the Page Layout tab?
I return the current date.
What is TODAY?
I am a formula that provides division between two numbers.
What is =A1/B1?
I adjust column widths automatically.
What is Autofit?
I am a style that is used to format tables.
What are Table Styles?
To show formulas I need to navigate to this tab.
What is the Formulas tab?
I can return a value by looking at a table vertically.
What is VLOOKUP?
I am a formula that combines text. I use a delimiter in my formula.
What is =TEXTJOIN?
I am used to freeze the top row.
What is Freeze Panes -> Top Row?
I am used to format a series of cells into a consistent look.
What is Format as Table?