Microsoft Excel Flashcards
7 cards from real Robert Half Assessment Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Microsoft Excel flashcards as text
Which function returns the number of cells in a range that meet a single criterion?
Answer: COUNTIF
COUNTIF counts cells matching one criterion, e.g. =COUNTIF(A1:A10,">5").
What does pressing Ctrl+Shift+Enter do when entering a formula?
Answer: Enters the formula as an array formula
Ctrl+Shift+Enter confirms an array formula, displayed with curly braces {}.
In Excel, what is the purpose of the $ symbol in a cell reference like $B$4?
Answer: Makes the reference absolute so it doesn't change when copied
Dollar signs anchor the row and/or column so the reference stays fixed when the formula is copied.
Which Excel feature automatically fills a series based on a pattern you establish?
Answer: AutoFill
AutoFill extends a recognized pattern (dates, numbers, custom lists) when you drag the fill handle.
What does the TRIM function do in Excel?
Answer: Removes all spaces from text except single spaces between words
TRIM removes leading, trailing, and extra internal spaces, leaving only single spaces between words.
When you freeze panes in Excel, what is the primary benefit?
Answer: It locks row/column headers so they stay visible while scrolling
Freeze Panes keeps header rows or columns visible as you scroll through large datasets.
Which function would you use to combine the text in cells A1 and B1 with a space between them?
Answer: =CONCAT(A1," ",B1)
CONCAT (or CONCATENATE) joins text strings; you include a literal space " " as an argument.