Excel Basics
This is the name of the file format that Excel saves workbooks by default.
What is .xlsx?
This symbol is used to start all formulas in Excel.
What is the equals sign (=)?
This feature allows you to make text bold, italic or underlined.
What is Font Formatting?
This is the keyboard shortcut for saving a file in Excel.
What is Ctrl+S?
This is the keyboard shortcut for undoing your last action.
What is Ctrl+Z?
This tab in Excel lets you insert features like pictures, charts, and tables.
What is the Insert tab?
This function adds up a range of cells.
What is SUM?
You use this Excel feature to automatically change the appearance of cells based on their values.
What is Conditional Formatting?
This shortcut takes you to the first cell of a worksheet.
What is Ctrl+Home?
This is the keyboard shortcut to quickly highlight an entire row.
What is Shift+Space?
This bar at the top of Excel displays the content of the currently selected cell.
What is the Formula Bar?
This function calculates the average of a range of numbers.
What is AVERAGE?
This option can change the number of decimal places displayed in a number.
What is the Increase/Decrease Decimal tool?
This is the keyboard shortcut to move one cell to the right.
What is the Tab Key?
This shortcut allows you to repeat your last action.
What is Ctrl+Y?
This is the name of the feature that allows you to autofill adjacent cells based on a pattern.
What is the Fill Handle?
This function returns the largest number in a given range.
What is MAX?
This feature merges multiple cells into one larger cell.
What is Merge and Center?
This tab on the ribbon allows you to insert charts, tables, and images.
What is the Insert Tab?
This key combination selects all the data in the current worksheet.
What is Ctrl+A?
These are the horizontal and vertical divisions used to organize data in Excel.
What are rows and columns?
This formula multiplies cell A1 by cell B1.
What is =A1*B1?
This type of formatting ensures that numbers are displayed as currency, percentages, or dates.
What is Number Formatting?
This small box lets you name or view the location of a selected cell.
What is the Name Box?
This key toggles between showing formulas and their results.
What is Ctrl+` (backtick)?