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

HLOOKUP

Answer

INDEX

Answer

MATCH

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

Apply formulas only when certain data is entered

Answer

Protect cells that meet specific criteria from editing

Answer

Create dropdown validation lists based on conditions

Question 3

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

Accepted Answer

Ctrl+Spacebar

Answer

Shift+Spacebar

Answer

Ctrl+Shift+End

Answer

Alt+Spacebar

Question 4

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

Accepted Answer

MAX

Answer

LARGE

Answer

UPPER

Answer

PEAK

Question 5

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

Accepted Answer

COUNTIFS

Answer

COUNTIF

Answer

SUMPRODUCT

Answer

DCOUNT

Question 6

What does the TEXT function do in Excel?

Accepted Answer

Formats a number as text using a specified format code

Answer

Converts a number into a spelled-out word

Answer

Extracts text from a mixed cell

Answer

Counts the number of characters in a cell

Question 7

In Excel's Name Box (the box to the left of the formula bar), what happens when you type a cell address and press Enter?

Accepted Answer

It navigates directly to that cell

Answer

It renames the active cell

Answer

It inserts the address as a formula

Answer

It selects all cells with that value