Robert Half Assessment Test Microsoft Excel Proficiency 5

Question 1

Which Excel function returns the largest value in a range?

Accepted Answer

MAX

Answer

MAX scans a range and returns the highest numeric value found, ignoring text and empty cells.

Question 2

A formula in C1 reads =A1+B1. When you copy this formula to C2, what does it become?

Accepted Answer

=A2+B2

Answer

Relative references shift by the same number of rows/columns as the copy distance, so copying down one row adjusts row numbers by one.

Question 3

What is the purpose of the SUMPRODUCT function?

Accepted Answer

Multiplies corresponding elements in arrays and returns the sum of those products

Answer

SUMPRODUCT multiplies corresponding elements across multiple arrays and then sums all the resulting products.

Question 4

Which option under Paste Special allows you to paste only the calculated results of formulas, not the formulas themselves?

Accepted Answer

Paste Values

Answer

Paste Values pastes only the current numeric or text results of formulas, stripping out the underlying formula.

Question 5

In Excel, what does the TRIM function do?

Accepted Answer

Removes all leading, trailing, and extra internal spaces from text

Answer

TRIM removes leading and trailing spaces and reduces multiple internal spaces to a single space, cleaning up imported text.

Robert Half Assessment Test Practice Test