Robert Half Assessment Test Microsoft Excel 3

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?

Accepted Answer

=IF(A1>100,"High",IF(A1>50,"Medium","Low"))

Answer

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?

Accepted Answer

Aggregated data such as sums, counts, or averages

Answer

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?

Accepted Answer

Shift+F11

Answer

Shift+F11 inserts a new blank worksheet before the active sheet.

Question 4

What does the IFERROR function do?

Accepted Answer

Replaces an error value with a specified result

Answer

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?

Accepted Answer

Pie chart

Answer

A pie chart is designed to show each category's share of the total as a slice of the circle.

Robert Half Assessment Test Practice Test