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

Prevents formula entry if values are missing

Answer

Highlights error cells in red

Answer

Converts errors to zero automatically

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

UPPER

Answer

LOWER

Answer

TRIM

Question 3

Which PivotTable feature allows you to display subtotals for sub-groups within a category?

Accepted Answer

Subtotals option

Answer

Value Field Settings

Answer

Row Labels grouping

Answer

Show Values As

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

Duplicate rows are highlighted but not deleted

Answer

All duplicate rows including the first are deleted

Answer

Duplicates are moved to a new sheet

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

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

Answer

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

Answer

=DATEDIF("1/1/2024","1/31/2024","D")

Question 6

What is the purpose of Freeze Panes in Excel?

Accepted Answer

Locks rows or columns so they remain visible when scrolling

Answer

Prevents cells from being edited

Answer

Saves the current view as a named configuration

Answer

Protects the worksheet with a password

Question 7

Which Excel function converts a text string that looks like a number into an actual numeric value?

Accepted Answer

VALUE

Answer

TEXT

Answer

FIXED

Answer

NUMBERVALUE