Spreadsheet Shortcuts
What keyboard shortcut saves a workbook?
Ctrl + S
Which function is used to test a condition as true or false?
=IF
What Excel feature automatically changes cell appearance based on rules?
Conditional Formatting
What keyboard shortcut creates a table in Excel?
Ctrl + T
Which chart type is best for showing trends over time?
Line Chart
What keyboard shortcut copies selected cells?
Ctrl + C
Which function searches vertically in a table?
=VLOOKUP
Which conditional formatting option uses color intensity to compare values?
Color Scale
What type of reference uses table column names instead of cell addresses?
Structured Reference.
Which chart type is commonly used to compare categories?
Bar Chart
What keyboard shortcut pastes copied content?
Ctrl + V
In the IF function, what is the name of the argument returned if the condition is true?
value_if_true
What are the small bars displayed inside cells called?
Data Bars
Which tool removes repeated values from a dataset?
Remove Duplicates.
What is the name of the mini chart displayed inside a single cell?
Sparklines
What keyboard shortcut undoes the last action?
Ctrl + Z
Which function counts cells that meet a condition?
=COUNTIF
Which conditional formatting option displays symbols like arrows or flags?
Icon Sets.
Which feature organizes data alphabetically or numerically?
Sort.
Which chart type is commonly used to show percentages?
Pie Chart
What key edits the active cell?
F2
Which newer function can replace VLOOKUP?
=XLOOKUP
Which type of conditional formatting rule uses formulas?
Formula Rule
Which feature displays only selected records from a dataset?
Filter.
What chart element explains the meaning of colors or series?
Legend.