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
Which Excel function returns the position of a value within a range?
Answer: MATCH
MATCH returns the relative position of a lookup value within a range, not the value itself.
What does the $ symbol do when placed before a column letter in a cell reference like $B5?
Answer: Locks the column only
A $ before the column letter creates an absolute column reference, so the column stays fixed when the formula is copied.
A manager wants to highlight all sales figures above $10,000 automatically. Which Excel feature should she use?
Answer: Conditional Formatting
Conditional Formatting automatically applies visual formatting to cells that meet specified criteria.
Which function counts only the cells in a range that contain numbers?
Answer: COUNT
COUNT tallies only numeric values, ignoring text, blanks, and logical values.
What is the keyboard shortcut to apply the current date to a cell in Excel?
Answer: Ctrl+;
Ctrl+; inserts the current date as a static value that does not update automatically.
In an Excel table, what automatically happens when you add a new row directly below the last data row?
Answer: The table expands to include the new row
Excel tables automatically extend their range, formatting, and structured references to include new adjacent rows.
Which Excel chart type is best suited for showing parts of a whole as percentages?
Answer: Pie chart
A pie chart divides a circle into slices proportional to each category's share of the total.