Microsoft Excel 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 flashcards as text
You need to look up a product code in column A and return its price from column D. Which function is most appropriate?
Answer: VLOOKUP
VLOOKUP searches the first column of a range vertically and returns a value from a specified column to the right.
What does conditional formatting allow you to do in Excel?
Answer: Change cell appearance automatically based on cell values or rules
Conditional formatting changes font color, fill, icons, or data bars based on rules you define.
What is the keyboard shortcut to select an entire column in Excel?
Answer: Ctrl+Spacebar
Ctrl+Spacebar selects the entire column of the active cell.
Which function returns the largest value in a range of cells?
Answer: MAX
MAX returns the highest numeric value in a specified range.
If you want to count cells that meet multiple criteria across different ranges, which function should you use?
Answer: COUNTIFS
COUNTIFS evaluates multiple criteria across multiple ranges and counts rows where all criteria are met.
What does the TEXT function do in Excel?
Answer: Formats a number as text using a specified format code
TEXT(value, format_text) converts a number to a string using a custom format like "MM/DD/YYYY" or "$#,##0.00".
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?
Answer: It navigates directly to that cell
Typing a cell address (e.g., D15) in the Name Box and pressing Enter moves the active cell to that location.