Robert Half Assessment Test Microsoft Excel Proficiency 2 — Questions and Answers
Question 1: Which Excel function returns the position of a value within a range?
- FIND
- MATCH (Correct answer)
- SEARCH
- INDEX
Correct answer: MATCH
MATCH returns the relative position of a lookup value within a range, not the value itself.
Question 2: What does the $ symbol do when placed before a column letter in a cell reference like $B5?
- Locks the entire row
- Locks the column only (Correct answer)
- Locks the entire cell
- Locks the row only
Correct answer: Locks the column only
A $ before the column letter creates an absolute column reference, so the column stays fixed when the formula is copied.
Question 3: A manager wants to highlight all sales figures above $10,000 automatically. Which Excel feature should she use?
- Data Validation
- Conditional Formatting (Correct answer)
- Sparklines
- Goal Seek
Correct answer: Conditional Formatting
Conditional Formatting automatically applies visual formatting to cells that meet specified criteria.
Question 4: Which function counts only the cells in a range that contain numbers?
- COUNTA
- COUNTIF
- COUNT (Correct answer)
- COUNTBLANK
Correct answer: COUNT
COUNT tallies only numeric values, ignoring text, blanks, and logical values.
Question 5: What is the keyboard shortcut to apply the current date to a cell in Excel?
- Ctrl+Shift+T
- Ctrl+; (Correct answer)
- Ctrl+D
- Alt+T
Correct answer: Ctrl+;
Ctrl+; inserts the current date as a static value that does not update automatically.
Question 6: In an Excel table, what automatically happens when you add a new row directly below the last data row?
- A new worksheet is created
- The table expands to include the new row (Correct answer)
- A warning dialog appears
- The new row is ignored by formulas
Correct answer: The table expands to include the new row
Excel tables automatically extend their range, formatting, and structured references to include new adjacent rows.
Question 7: Which Excel chart type is best suited for showing parts of a whole as percentages?
- Line chart
- Scatter chart
- Pie chart (Correct answer)
- Area chart
Correct answer: Pie chart
A pie chart divides a circle into slices proportional to each category's share of the total.
Robert Half Assessment Test Microsoft Excel Proficiency 2
Which Excel function returns the position of a value within a range?