Robert Half Assessment Test Microsoft Excel 5 — Questions and Answers
Question 1: Which Excel function returns the position (row number) of a value within a range?
- FIND
- SEARCH
- MATCH (Correct answer)
- LOOKUP
Correct answer: MATCH
MATCH returns the relative position of a value in a range; it's often combined with INDEX for flexible lookups.
Question 2: What does the ROUND function do when the second argument is negative, e.g. =ROUND(2567, -2)?
- Returns an error
- Rounds to 2 decimal places
- Rounds to the nearest hundred (returns 2600) (Correct answer)
- Rounds to the nearest tenth
Correct answer: Rounds to the nearest hundred (returns 2600)
A negative digit argument in ROUND rounds to the left of the decimal; -2 rounds to the nearest 100, giving 2600.
Question 3: When you use Data Validation with a 'List' type, what does the user see in the cell?
- A pop-up dialog requiring text entry
- A dropdown arrow that reveals allowed choices (Correct answer)
- A locked cell that only administrators can edit
- A color-coded indicator of valid values
Correct answer: A dropdown arrow that reveals allowed choices
List-type Data Validation adds a dropdown arrow to the cell, restricting input to the predefined options.
Question 4: Which function would you use to extract just the year from a date stored in cell A1?
- =DATE(A1)
- =YEAR(A1) (Correct answer)
- =LEFT(A1,4)
- =DATEPART("year",A1)
Correct answer: =YEAR(A1)
YEAR(date) extracts and returns the four-digit year from a valid Excel date value.
Question 5: What is the purpose of the SUMPRODUCT function?
- Sums a range and multiplies the result by a constant
- Multiplies corresponding elements of arrays and returns their sum (Correct answer)
- Creates a product catalog with pricing subtotals
- Sums only the cells that contain products
Correct answer: Multiplies corresponding elements of arrays and returns their sum
SUMPRODUCT multiplies corresponding array elements together and then adds all those products.
Question 6: You notice that a column of numbers imported from a database is left-aligned and won't sum. What is the most likely problem?
- The column is too narrow to display values correctly
- The numbers are stored as text, not as numeric values (Correct answer)
- The SUM formula has a syntax error
- AutoSum is disabled for that column
Correct answer: The numbers are stored as text, not as numeric values
Numbers stored as text are left-aligned by default and are ignored by SUM; converting them to numbers fixes the issue.
Question 7: Which Excel view shows exactly how a worksheet will look when printed, including page breaks and margins?
- Normal view
- Page Layout view
- Page Break Preview
- Print Preview (Correct answer)
Correct answer: Print Preview
Print Preview (File > Print) shows a full-fidelity rendering of the printed output with all margins, headers, and footers.
Robert Half Assessment Test Microsoft Excel 5
Which Excel function returns the position (row number) of a value within a range?