Robert Half Assessment Test Microsoft Excel Proficiency 5

Question 1

Which Excel function returns the largest value in a range?

Accepted Answer

MAX

Answer

LARGE

Answer

UPPER

Answer

TOP

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

=A1+B1

Answer

=$A$1+$B$1

Answer

=A1+B2

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

Sums all products in a catalog list

Answer

Returns the largest product of any two values in a range

Answer

Creates a multiplication table for two ranges

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 All

Answer

Paste Formulas

Answer

Paste Formats

Question 5

In Excel, what does the TRIM function do?

Accepted Answer

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

Answer

Shortens text to a specified number of characters

Answer

Deletes empty rows from a range

Answer

Cuts the selected cell content to the clipboard

Question 6

A user wants to restrict data entry in a cell to whole numbers between 1 and 100. Which feature should they use?

Accepted Answer

Data Validation

Answer

Conditional Formatting

Answer

Cell Protection

Answer

Named Ranges

Question 7

Which keyboard shortcut opens the Format Cells dialog box in Excel?

Accepted Answer

Ctrl+1

Answer

Ctrl+F

Answer

Alt+Enter

Answer

Ctrl+Shift+F