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

FIND

Answer

SEARCH

Answer

LOOKUP

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

Returns an error

Answer

Rounds to 2 decimal places

Answer

Rounds to the nearest tenth

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

A pop-up dialog requiring text entry

Answer

A locked cell that only administrators can edit

Answer

A color-coded indicator of valid values

Question 4

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

Accepted Answer

=YEAR(A1)

Answer

=DATE(A1)

Answer

=LEFT(A1,4)

Answer

=DATEPART("year",A1)

Question 5

What is the purpose of the SUMPRODUCT function?

Accepted Answer

Multiplies corresponding elements of arrays and returns their sum

Answer

Sums a range and multiplies the result by a constant

Answer

Creates a product catalog with pricing subtotals

Answer

Sums only the cells that contain products

Question 6

You notice that a column of numbers imported from a database is left-aligned and won't sum. What is the most likely problem?

Accepted Answer

The numbers are stored as text, not as numeric values

Answer

The column is too narrow to display values correctly

Answer

The SUM formula has a syntax error

Answer

AutoSum is disabled for that column

Question 7

Which Excel view shows exactly how a worksheet will look when printed, including page breaks and margins?

Accepted Answer

Print Preview

Answer

Normal view

Answer

Page Layout view

Answer

Page Break Preview