Robert Half Assessment Test Microsoft Excel Proficiency 2

Question 1

Which Excel function returns the position of a value within a range?

Accepted Answer

MATCH

Answer

MATCH returns the relative position of a lookup value within a range, not the value itself.

Question 2

What does the $ symbol do when placed before a column letter in a cell reference like $B5?

Accepted Answer

Locks the column only

Answer

A $ before the column letter creates an absolute column reference, so the column stays fixed when the formula is copied.

Question 3

A manager wants to highlight all sales figures above $10,000 automatically. Which Excel feature should she use?

Accepted Answer

Conditional Formatting

Answer

Conditional Formatting automatically applies visual formatting to cells that meet specified criteria.

Question 4

Which function counts only the cells in a range that contain numbers?

Accepted Answer

COUNT

Answer

COUNT tallies only numeric values, ignoring text, blanks, and logical values.

Question 5

What is the keyboard shortcut to apply the current date to a cell in Excel?

Accepted Answer

Ctrl+;

Answer

Ctrl+; inserts the current date as a static value that does not update automatically.

Robert Half Assessment Test Practice Test