Robert Half Assessment Test Microsoft Excel Proficiency 3 — Questions and Answers
Question 1: What does the IFERROR function do in Excel?
- Prevents formula entry if values are missing
- Returns a specified value when a formula produces an error (Correct answer)
- Highlights error cells in red
- Converts errors to zero automatically
Correct answer: Returns a specified value when a formula produces an error
IFERROR evaluates an expression and returns a custom result if it produces any error, otherwise returns the expression's value.
Question 2: A spreadsheet column contains 'New York' in some cells and 'new york' in others. Which function would standardize them all to 'New York'?
- UPPER
- LOWER
- PROPER (Correct answer)
- TRIM
Correct answer: PROPER
PROPER capitalizes the first letter of each word, converting 'new york' to 'New York'.
Question 3: Which PivotTable feature allows you to display subtotals for sub-groups within a category?
- Value Field Settings
- Row Labels grouping
- Show Values As
- Subtotals option (Correct answer)
Correct answer: Subtotals option
The Subtotals option in PivotTable design controls whether and where subtotal rows appear for each grouping.
Question 4: What happens when you use the Remove Duplicates feature on a dataset in Excel?
- Duplicate rows are highlighted but not deleted
- One copy of each duplicate row is kept and others are permanently deleted (Correct answer)
- All duplicate rows including the first are deleted
- Duplicates are moved to a new sheet
Correct answer: One copy of each duplicate row is kept and others are permanently deleted
Remove Duplicates retains the first occurrence of each unique row and permanently deletes all subsequent duplicates.
Question 5: Which formula correctly calculates the number of workdays between January 1 and January 31, 2024, excluding weekends?
- =DAYS("1/31/2024","1/1/2024")
- =NETWORKDAYS("1/1/2024","1/31/2024") (Correct answer)
- =WORKDAY("1/1/2024",31)
- =DATEDIF("1/1/2024","1/31/2024","D")
Correct answer: =NETWORKDAYS("1/1/2024","1/31/2024")
NETWORKDAYS counts the number of whole working days between two dates, automatically excluding Saturdays and Sundays.
Question 6: What is the purpose of Freeze Panes in Excel?
- Prevents cells from being edited
- Locks rows or columns so they remain visible when scrolling (Correct answer)
- Saves the current view as a named configuration
- Protects the worksheet with a password
Correct answer: Locks rows or columns so they remain visible when scrolling
Freeze Panes locks specified rows or columns in place so headers stay visible as you scroll through large datasets.
Question 7: Which Excel function converts a text string that looks like a number into an actual numeric value?
- TEXT
- VALUE (Correct answer)
- FIXED
- NUMBERVALUE
Correct answer: VALUE
VALUE converts a text string representing a number into an actual number that can be used in calculations.
Robert Half Assessment Test Microsoft Excel Proficiency 3
What does the IFERROR function do in Excel?