Robert Half Assessment Test Microsoft Excel 2 — Questions and Answers
Question 1: Which function returns the number of cells in a range that meet a single criterion?
- COUNT
- COUNTA
- COUNTIF (Correct answer)
- SUMIF
Correct answer: COUNTIF
COUNTIF counts cells matching one criterion, e.g. =COUNTIF(A1:A10,">5").
Question 2: What does pressing Ctrl+Shift+Enter do when entering a formula?
- Saves the workbook
- Enters the formula as an array formula (Correct answer)
- Applies bold formatting
- Opens the formula wizard
Correct answer: Enters the formula as an array formula
Ctrl+Shift+Enter confirms an array formula, displayed with curly braces {}.
Question 3: In Excel, what is the purpose of the $ symbol in a cell reference like $B$4?
- Formats the cell as currency
- Makes the reference absolute so it doesn't change when copied (Correct answer)
- Locks the worksheet
- Indicates a named range
Correct 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.
Question 4: Which Excel feature automatically fills a series based on a pattern you establish?
- AutoCorrect
- Flash Fill
- AutoFill (Correct answer)
- Quick Fill
Correct answer: AutoFill
AutoFill extends a recognized pattern (dates, numbers, custom lists) when you drag the fill handle.
Question 5: What does the TRIM function do in Excel?
- Rounds a number to a specified number of digits
- Removes all spaces from text except single spaces between words (Correct answer)
- Extracts a substring from the middle of text
- Converts text to uppercase
Correct 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.
Question 6: When you freeze panes in Excel, what is the primary benefit?
- It prevents editing of selected cells
- It locks row/column headers so they stay visible while scrolling (Correct answer)
- It protects the worksheet with a password
- It merges selected cells
Correct 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.
Question 7: Which function would you use to combine the text in cells A1 and B1 with a space between them?
- =JOIN(A1," ",B1)
- =MERGE(A1,B1)
- =CONCAT(A1," ",B1) (Correct answer)
- =COMBINE(A1,B1)
Correct answer: =CONCAT(A1," ",B1)
CONCAT (or CONCATENATE) joins text strings; you include a literal space " " as an argument.
Robert Half Assessment Test Microsoft Excel 2
Which function returns the number of cells in a range that meet a single criterion?