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

Ctrl+Shift+End extends the current selection to the last cell that contains data or formatting in the worksheet.

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

VLOOKUP searches vertically down a column for a value and returns a corresponding value from a specified column to the right.

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

#REF! appears when a formula refers to a cell that has been deleted or a reference that is otherwise invalid.

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

Goal Seek works backward from a desired result to find the single input value required to achieve it.

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

Relative references shift based on the formula's new position, while absolute references (using $) remain fixed regardless of where the formula is copied.

Robert Half Assessment Test Practice Test

Robert Half Assessment Test Practice Test

Robert Half Assessment Test Microsoft Excel Proficiency 4