Robert Half Assessment Test Microsoft Excel 4 — Questions and Answers
Question 1: You need to look up a product code in column A and return its price from column D. Which function is most appropriate?
- HLOOKUP
- VLOOKUP (Correct answer)
- INDEX
- MATCH
Correct answer: VLOOKUP
VLOOKUP searches the first column of a range vertically and returns a value from a specified column to the right.
Question 2: What does conditional formatting allow you to do in Excel?
- Apply formulas only when certain data is entered
- Change cell appearance automatically based on cell values or rules (Correct answer)
- Protect cells that meet specific criteria from editing
- Create dropdown validation lists based on conditions
Correct answer: Change cell appearance automatically based on cell values or rules
Conditional formatting changes font color, fill, icons, or data bars based on rules you define.
Question 3: What is the keyboard shortcut to select an entire column in Excel?
- Ctrl+Spacebar (Correct answer)
- Shift+Spacebar
- Ctrl+Shift+End
- Alt+Spacebar
Correct answer: Ctrl+Spacebar
Ctrl+Spacebar selects the entire column of the active cell.
Question 4: Which function returns the largest value in a range of cells?
- LARGE
- UPPER
- MAX (Correct answer)
- PEAK
Correct answer: MAX
MAX returns the highest numeric value in a specified range.
Question 5: If you want to count cells that meet multiple criteria across different ranges, which function should you use?
- COUNTIF
- COUNTIFS (Correct answer)
- SUMPRODUCT
- DCOUNT
Correct answer: COUNTIFS
COUNTIFS evaluates multiple criteria across multiple ranges and counts rows where all criteria are met.
Question 6: What does the TEXT function do in Excel?
- Converts a number into a spelled-out word
- Formats a number as text using a specified format code (Correct answer)
- Extracts text from a mixed cell
- Counts the number of characters in a cell
Correct answer: Formats a number as text using a specified format code
TEXT(value, format_text) converts a number to a string using a custom format like "MM/DD/YYYY" or "$#,##0.00".
Question 7: In Excel's Name Box (the box to the left of the formula bar), what happens when you type a cell address and press Enter?
- It renames the active cell
- It navigates directly to that cell (Correct answer)
- It inserts the address as a formula
- It selects all cells with that value
Correct answer: It navigates directly to that cell
Typing a cell address (e.g., D15) in the Name Box and pressing Enter moves the active cell to that location.
Robert Half Assessment Test Microsoft Excel 4
You need to look up a product code in column A and return its price from column D.
Which function is most appropriate?