Formulas
Which option in 'Paste Special' would you use if you wanted to copy cell values, but not their original formatting or formulas?
What is Paste as Values?
How do you cut text?
What is CTRL + X?
To keep row headers visible while scrolling down a large dataset, which feature would you use?
Freeze Panes
Which tab on the Ribbon contains most of the charting options and tools for inserting charts?
What is the Insert Tab
What is the primary function of a 'Slicer' when used with Excel Tables or PivotTables?
What is filtering data?
The VLOOKUP function is generally limited to searching for a value in which column of the lookup range?
What is the left most column?
The two-key combination that automatically inserts the SUM function.
What is Alt + =?
Which feature helps convert a single column of text into multiple columns, often based on delimiters like commas or tabs?
Text to Columns
Primary tab that contains groups with the more frequently used commands
What is the Home Tab
You can hide or display these summary rows for the entire report from the Design tab.
What are Grand Totals?
This modern dynamic array function takes a list or column and returns a unique list of its contents, spilling into the cells below.
What is the UNIQUE function?
What hot key allows you to undo your last action?
What is Ctrl + Z?
To eliminate redundant entries within a selected range of data, you would use which data tool?
Remove Duplicates
Which tab on the ribbon contains the freeze panes command?
What is the view tab?
When creating a Pivot Table, you have the choice of placing it on a New Worksheet or this location.
What is an Existing Worksheet?
This fundamental logical function checks if a condition is true and returns one value if it is, and another value if it's false.
What is the IF function?
What hotkey allows you to quickly format your data as a table?
What is CTRL+T?
When Excel automatically left-aligns data in a cell, it typically indicates that the data is interpreted as what?
Text
Which tab allows you to record macros?
What is the developer tab?
The default report layout that saves horizontal space by placing multiple row fields into a single, indented column.
What is Compact Form?
You nest this function inside an IF statement to check if all specified conditions are true at the same time.
What is the AND function?
While editing a formula, you press this function key to cycle a cell reference through its absolute and relative states (e.g., A1, $A$1, A$1, $A1). This shortcut can also redo the last action you performed.
What is F4?
If you want to create a button on your worksheet that runs a sequence of automated steps, what Excel feature would you likely use?
Macro
Which tab allows you to add data validation and what is the purpose of the data validation function?
What is the view tab and what is a feature that controls what can be entered into a cell
This feature allows you to create a new item within a field by performing calculations on other items.
What is a Calculated field?