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
What is the correct syntax for a nested IF formula that returns "High" if A1>100, "Medium" if A1>50, and "Low" otherwise?
Answer: =IF(A1>100,"High",IF(A1>50,"Medium","Low"))
Nested IFs place another IF as the false argument; =IF(A1>100,"High",IF(A1>50,"Medium","Low")) is correct.
In a PivotTable, what does the 'Values' area display?
Answer: Aggregated data such as sums, counts, or averages
The Values area shows calculated aggregations (SUM, COUNT, AVERAGE, etc.) for the data fields.
Which shortcut key inserts a new worksheet in Excel?
Answer: Shift+F11
Shift+F11 inserts a new blank worksheet before the active sheet.
What does the IFERROR function do?
Answer: Replaces an error value with a specified result
IFERROR(value, value_if_error) returns a custom result if the first argument produces any error, otherwise returns that value.
Which Excel chart type is best for showing the proportion of parts to a whole?
Answer: Pie chart
A pie chart is designed to show each category's share of the total as a slice of the circle.
What is the result of =MOD(17, 5)?
Answer: 2
MOD returns the remainder after division: 17 ÷ 5 = 3 remainder 2, so MOD(17,5) = 2.
Which option under Paste Special allows you to paste only the calculated values without the underlying formulas?
Answer: Values
Paste Special > Values pastes the computed results as static data, removing formula dependencies.