Cells, Rows & Columns
This keyboard shortcut selects all cells at once.
Control + A
The toolbar at the top of a spreadsheet that displays the contents of the active cell, whether it's simple data, a formula, or an error message.
What is the formula bar?
What symbol is used between two cell references to indicate a range of cells?
What is Colon :
This feature automatically changes formatting based on a rule (such as highlighting high values).
What is Conditional Formatting?
This circular chart shows how parts make up a whole.
What is a pie chart?
This command clears the formatting in selected cells but keeps the cells content.
What is Clear Formats (Eraser icon)?
This command lets you replace text or numbers across the sheet.
What is Find & Replace?
What all Formulas should start with.
What is =?
The tool that copies the formatting from one cell or range of cells and applies it to another
What is Format Painter?
Pre-set and custom formats, including fonts, colors, and number formats, that can be applied to cells
What are Cell Styles?
The part of a cell that you would click and drag if you wanted to use Autofill.
What is the bottom right corner?
The Excel feature that quickly fills a range of cells with data that follows a pattern, such as a series of numbers, dates, or months
What is Autofill?
This function automatically applies a SUM function to the numbers above.
What is AutoSum?
This tool automatically applies formatting to cells based on specific rules or conditions
What is Conditional Formatting?
The command that would convert the selected cells into a table.
What is Format as Table?
What is insufficient column width?
The type of number format you would want to use if you were working with Money $$$
What is Currency?
This function returns one value if a condition is true and another if false.
What is IF?
A feature that locks specific rows and/or columns in place so they remain visible while you scroll through the rest of the worksheet.
What are Freeze Panes?
This tool lets you preview different chart styles without navigating to the ribbon after highlighting the cell range.
What is Quick Analysis?
The process of giving a cell a name like “TotalSales” so formulas can reference it more easily.
What is creating a Named Range?
Adding a dollar sign ($) in a reference makes it this type of reference.
What is an absolute reference?
This function counts only the cells that are not empty.
What is COUNTA?
This feature automatically adjusts a column's width to its largest content, making sure all data is visible.
What is Autofit column width?
You can adjust the colors, layout, and style of a chart using this menu.
What is Chart Design?