Robert Half Assessment Test Microsoft Excel Proficiency 4

Question 1

In Excel, what does pressing Ctrl+Shift+End do?

Accepted Answer

Extends the selection to the last used cell in the worksheet

Answer

Moves to the last cell in the current column

Answer

Saves and closes the file

Answer

Selects all cells to the right of the current cell

Question 2

An analyst needs to look up a product code in column A and return the price from column D. Which is the most appropriate function?

Accepted Answer

VLOOKUP

Answer

HLOOKUP

Answer

MATCH

Answer

CHOOSE

Question 3

What does a #REF! error indicate in an Excel formula?

Accepted Answer

The formula references a cell that no longer exists or is invalid

Answer

A required argument is missing

Answer

The value is too large for the cell to display

Answer

There is a circular reference in the formula

Question 4

Which Excel feature would you use to find the input value needed to achieve a specific formula result?

Accepted Answer

Goal Seek

Answer

Solver

Answer

Scenario Manager

Answer

What-If Analysis Table

Question 5

What is the difference between a relative and absolute cell reference when copying a formula?

Accepted Answer

Relative references adjust to the new location; absolute references stay fixed

Answer

Absolute references update automatically; relative references stay fixed

Answer

Both types behave identically when copying

Answer

Relative references only work within the same sheet

Question 6

Which function would you use to combine the text from cells A1 and B1 with a space between them?

Accepted Answer

=CONCATENATE(A1," ",B1)

Answer

=A1+" "+B1

Answer

=JOIN(A1,B1)

Answer

=MERGE(A1," ",B1)

Question 7

When sorting data in Excel, what should you do to ensure a header row is not sorted with the data?

Accepted Answer

Check 'My data has headers' in the Sort dialog

Answer

Bold the header row before sorting

Answer

Place the header row on a separate worksheet

Answer

Lock the header row before sorting