Microsoft Excel Proficiency Flashcards
7 cards from real Robert Half Assessment Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Microsoft Excel Proficiency flashcards as text
In Excel, what does pressing Ctrl+Shift+End do?
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.
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?
Answer: VLOOKUP
VLOOKUP searches vertically down a column for a value and returns a corresponding value from a specified column to the right.
What does a #REF! error indicate in an Excel formula?
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.
Which Excel feature would you use to find the input value needed to achieve a specific formula result?
Answer: Goal Seek
Goal Seek works backward from a desired result to find the single input value required to achieve it.
What is the difference between a relative and absolute cell reference when copying a formula?
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.
Which function would you use to combine the text from cells A1 and B1 with a space between them?
Answer: =CONCATENATE(A1," ",B1)
CONCATENATE (or the & operator) joins text strings together, and you can include a space character as a literal text argument.
When sorting data in Excel, what should you do to ensure a header row is not sorted with the data?
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.