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

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

Answer

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

Answer

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

Question 2

In a PivotTable, what does the 'Values' area display?

Accepted Answer

Aggregated data such as sums, counts, or averages

Answer

The field labels used as column headers

Answer

Filter criteria applied to the table

Answer

Row grouping categories

Question 3

Which shortcut key inserts a new worksheet in Excel?

Accepted Answer

Shift+F11

Answer

Ctrl+N

Answer

Ctrl+W

Answer

Alt+F1

Question 4

What does the IFERROR function do?

Accepted Answer

Replaces an error value with a specified result

Answer

Returns TRUE if a formula contains an error

Answer

Prevents a formula from being evaluated

Answer

Highlights cells containing errors in red

Question 5

Which Excel chart type is best for showing the proportion of parts to a whole?

Accepted Answer

Pie chart

Answer

Line chart

Answer

Bar chart

Answer

Scatter chart

Question 6

What is the result of =MOD(17, 5)?

Accepted Answer

2

Answer

3

Answer

3.4

Answer

5

Question 7

Which option under Paste Special allows you to paste only the calculated values without the underlying formulas?

Accepted Answer

Values

Answer

All

Answer

Formulas

Answer

Formats