Robert Half Assessment Test Microsoft Excel 5

Question 1

Which Excel function returns the position (row number) of a value within a range?

Accepted Answer

MATCH

Answer

MATCH returns the relative position of a value in a range; it's often combined with INDEX for flexible lookups.

Question 2

What does the ROUND function do when the second argument is negative, e.g. =ROUND(2567, -2)?

Accepted Answer

Rounds to the nearest hundred (returns 2600)

Answer

A negative digit argument in ROUND rounds to the left of the decimal; -2 rounds to the nearest 100, giving 2600.

Question 3

When you use Data Validation with a 'List' type, what does the user see in the cell?

Accepted Answer

A dropdown arrow that reveals allowed choices

Answer

List-type Data Validation adds a dropdown arrow to the cell, restricting input to the predefined options.

Question 4

Which function would you use to extract just the year from a date stored in cell A1?

Accepted Answer

=YEAR(A1)

Answer

YEAR(date) extracts and returns the four-digit year from a valid Excel date value.

Question 5

What is the purpose of the SUMPRODUCT function?

Accepted Answer

Multiplies corresponding elements of arrays and returns their sum

Answer

SUMPRODUCT multiplies corresponding array elements together and then adds all those products.

Robert Half Assessment Test Practice Test