Shortcuts
This shortcut is used to add a column
This function adds a range of numbers together
What is =SUM()
These vertical sections in an Excel worksheet are identified by letters such as A, B, and C.
What are columns?
This feature quickly removes extra spaces before, after and between words in a cell
What is TRIM function
This Excel tool quickly summarizes large amounts of data by organizing it into categories, totals, and counts.
What is a PivotTable?
CTRL+A does what?
Selecting an entire dataset
This function counts only the cells containing numbers
What is =COUNT()
This is the intersection of a row and a column where you enter data.
What is a cell?
This Excel feature eliminates repeated rows or values from a selected range of data. (Hint in the Data tab)
What is Remove Duplicates?
This Excel feature creates a visual representation of your data, making trends and comparisons easier to see.
What is a Chart?
What does CTRL+SHIFT+L do?
Adds a filter to a dataset
Math, Logical, Conditional, Text
In an absolute cell reference like A1, what symbols are used to lock the column and row
$
This Excel feature lets you instantly highlight cells that meet certain conditions, such as duplicate values of numbers greater that 100
What is Conditional Formatting?
Name 3 types of charts
Line, Bar, Histogram, Scatter, Pie, etc
What shortcut do you use to copy and paste?
CTRL + C
CTRL + V
This function returns one value if a condition is true and another if it's false
What is an IF statement?
These tabs at the bottom of an Excel workbook allow you to organize and switch between different worksheets.
What are sheet tabs (or worksheet tabs)?
This command allows you to change all instances of one value, word, or character to another throughout a worksheet.
What is Find and Replace?
This Excel tool separates data from one column into multiple columns based on a delimiter or fixed width.
What is Text to Columns
What is the shortcut used to copy a formula down a column?
CTRL + D
Finish the formula:
=VLOOKUP(A,B,C,D)
=VLOOKUP(lookup value, table array, column number, range_lookup)
This tab on the Excel ribbon contains commands such as Copy, Paste, Format Painter, and Cell Styles.
What is the Home tab?
This Excel tool quickly copies formatting from one cell to another without copying the cell's contents
What is Format Painter?
This PivotTable feature allows you to interactively filter data by clicking buttons instead of using drop-down menus
What is a Slicer?