Robert Half Assessment Test Microsoft Excel Proficiency 4 — Questions and Answers
Question 1: In Excel, what does pressing Ctrl+Shift+End do?
- Moves to the last cell in the current column
- Extends the selection to the last used cell in the worksheet (Correct answer)
- Saves and closes the file
- Selects all cells to the right of the current cell
Correct answer: Extends the selection to the last used cell in the worksheet
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?
- HLOOKUP
- VLOOKUP (Correct answer)
- MATCH
- CHOOSE
Correct answer: VLOOKUP
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?
- A required argument is missing
- The formula references a cell that no longer exists or is invalid (Correct answer)
- The value is too large for the cell to display
- There is a circular reference in the formula
Correct answer: The formula references a cell that no longer exists or is invalid
#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?
- Solver
- Goal Seek (Correct answer)
- Scenario Manager
- What-If Analysis Table
Correct answer: Goal Seek
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?
- Absolute references update automatically; relative references stay fixed
- Relative references adjust to the new location; absolute references stay fixed (Correct answer)
- Both types behave identically when copying
- Relative references only work within the same sheet
Correct answer: Relative references adjust to the new location; absolute references stay fixed
Relative references shift based on the formula's new position, while absolute references (using $) remain fixed regardless of where the formula is copied.
Question 6: Which function would you use to combine the text from cells A1 and B1 with a space between them?
- =A1+" "+B1
- =CONCATENATE(A1," ",B1) (Correct answer)
- =JOIN(A1,B1)
- =MERGE(A1," ",B1)
Correct answer: =CONCATENATE(A1," ",B1)
CONCATENATE (or the & operator) joins text strings together, and you can include a space character as a literal text argument.
Question 7: When sorting data in Excel, what should you do to ensure a header row is not sorted with the data?
- Bold the header row before sorting
- Check 'My data has headers' in the Sort dialog (Correct answer)
- Place the header row on a separate worksheet
- Lock the header row before sorting
Correct answer: Check 'My data has headers' in the Sort dialog
Selecting 'My data has headers' in the Sort dialog tells Excel to exclude the first row from sorting and use it as column labels.
Robert Half Assessment Test Microsoft Excel Proficiency 4
In Excel, what does pressing Ctrl+Shift+End do?