Robert Half Assessment Test Microsoft Excel 3 — Questions and Answers
Question 1: What is the correct syntax for a nested IF formula that returns "High" if A1>100, "Medium" if A1>50, and "Low" otherwise?
- =IF(A1>100,"High",IF(A1>50,"Medium","Low")) (Correct answer)
- =IF(A1>100,"High"),IF(A1>50,"Medium","Low")
- =IFNESTED(A1>100,"High",A1>50,"Medium","Low")
- =IFS(A1>100,"High",A1>50,"Medium","Low")
Correct answer: =IF(A1>100,"High",IF(A1>50,"Medium","Low"))
Nested IFs place another IF as the false argument; =IF(A1>100,"High",IF(A1>50,"Medium","Low")) is correct.
Question 2: In a PivotTable, what does the 'Values' area display?
- The field labels used as column headers
- Aggregated data such as sums, counts, or averages (Correct answer)
- Filter criteria applied to the table
- Row grouping categories
Correct answer: Aggregated data such as sums, counts, or averages
The Values area shows calculated aggregations (SUM, COUNT, AVERAGE, etc.) for the data fields.
Question 3: Which shortcut key inserts a new worksheet in Excel?
- Ctrl+N
- Shift+F11 (Correct answer)
- Ctrl+W
- Alt+F1
Correct answer: Shift+F11
Shift+F11 inserts a new blank worksheet before the active sheet.
Question 4: What does the IFERROR function do?
- Returns TRUE if a formula contains an error
- Replaces an error value with a specified result (Correct answer)
- Prevents a formula from being evaluated
- Highlights cells containing errors in red
Correct answer: Replaces an error value with a specified result
IFERROR(value, value_if_error) returns a custom result if the first argument produces any error, otherwise returns that value.
Question 5: Which Excel chart type is best for showing the proportion of parts to a whole?
- Line chart
- Bar chart
- Pie chart (Correct answer)
- Scatter chart
Correct answer: Pie chart
A pie chart is designed to show each category's share of the total as a slice of the circle.
Question 6: What is the result of =MOD(17, 5)?
- 3
- 2 (Correct answer)
- 3.4
- 5
Correct answer: 2
MOD returns the remainder after division: 17 ÷ 5 = 3 remainder 2, so MOD(17,5) = 2.
Question 7: Which option under Paste Special allows you to paste only the calculated values without the underlying formulas?
- All
- Formulas
- Values (Correct answer)
- Formats
Correct answer: Values
Paste Special > Values pastes the computed results as static data, removing formula dependencies.
Robert Half Assessment Test Microsoft Excel 3
What is the correct syntax for a nested IF formula that returns "High" if A1>100, "Medium" if A1>50, and "Low" otherwise?