Formulas & Functions
This function adds up all numbers in a range.
What is SUM?
You use this feature to alphabetize a list.
What is Sort?
This function returns one value if a condition is true and another if false.
What is IF?
This feature makes column widths fit the longest entry.
What is AutoFit Column Width?
This company created Excel.
What is Microsoft?
This function finds the average of a range.
What is AVERAGE?
You use this tool to quickly show only certain rows of data.
What is Filter?
You see this error when a formula divides by zero.
What is #DIV/0!?
You use this tool to make your headers stand out with color and style.
What is the Format Painter?
Excel files are saved with this file extension.
What is .xlsx?
This function counts only the cells that contain numbers.
What is COUNT?
This Excel feature lets you create summaries by category.
What is a Pivot Table?
This error appears when a cell reference doesn’t exist anymore.
What is #REF!?
This option allows a cell’s contents to appear on multiple lines.
What is Wrap Text?
The first version of Excel was released in this decade.
What is the 1980s?
This function returns the largest number in a range.
What is MAX?
This function looks up a value in the first column and returns a value from another column.
What is VLOOKUP?
This function checks if multiple conditions are true.
What is AND?
This format type displays numbers with a dollar sign and two decimals.
What is Currency format?
This Excel tool lets you record and automate repetitive tasks.
What is a Macro?
This function combines text from two or more cells into one.
What is CONCATENATE (or TEXTJOIN in newer Excel)?
This newer lookup function replaces VLOOKUP and works in any direction.
What is XLOOKUP?
This logical function checks if any condition is true.
What is OR?
This tool lets you apply a color scale or data bars based on values.
What is Conditional Formatting?
The maximum number of rows in a modern Excel worksheet is this.
What is 1,048,576?