Robert Half Assessment Test Microsoft Excel Proficiency 3

Question 1

What does the IFERROR function do in Excel?

Accepted Answer

Returns a specified value when a formula produces an error

Answer

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'?

Accepted Answer

PROPER

Answer

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?

Accepted Answer

Subtotals option

Answer

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?

Accepted Answer

One copy of each duplicate row is kept and others are permanently deleted

Answer

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?

Accepted Answer

=NETWORKDAYS("1/1/2024","1/31/2024")

Answer

NETWORKDAYS counts the number of whole working days between two dates, automatically excluding Saturdays and Sundays.

Robert Half Assessment Test Practice Test