Robert Half Assessment Test Microsoft Excel 4

Question 1

You need to look up a product code in column A and return its price from column D. Which function is most appropriate?

Accepted Answer

VLOOKUP

Answer

VLOOKUP searches the first column of a range vertically and returns a value from a specified column to the right.

Question 2

What does conditional formatting allow you to do in Excel?

Accepted Answer

Change cell appearance automatically based on cell values or rules

Answer

Conditional formatting changes font color, fill, icons, or data bars based on rules you define.

Question 3

What is the keyboard shortcut to select an entire column in Excel?

Accepted Answer

Ctrl+Spacebar

Answer

Ctrl+Spacebar selects the entire column of the active cell.

Question 4

Which function returns the largest value in a range of cells?

Accepted Answer

MAX

Answer

MAX returns the highest numeric value in a specified range.

Question 5

If you want to count cells that meet multiple criteria across different ranges, which function should you use?

Accepted Answer

COUNTIFS

Answer

COUNTIFS evaluates multiple criteria across multiple ranges and counts rows where all criteria are met.

Robert Half Assessment Test Practice Test