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
Which Excel function returns the position (row number) of a value within a range?
Answer: MATCH
MATCH returns the relative position of a value in a range; it's often combined with INDEX for flexible lookups.
What does the ROUND function do when the second argument is negative, e.g. =ROUND(2567, -2)?
Answer: Rounds to the nearest hundred (returns 2600)
A negative digit argument in ROUND rounds to the left of the decimal; -2 rounds to the nearest 100, giving 2600.
When you use Data Validation with a 'List' type, what does the user see in the cell?
Answer: A dropdown arrow that reveals allowed choices
List-type Data Validation adds a dropdown arrow to the cell, restricting input to the predefined options.
Which function would you use to extract just the year from a date stored in cell A1?
Answer: =YEAR(A1)
YEAR(date) extracts and returns the four-digit year from a valid Excel date value.
What is the purpose of the SUMPRODUCT function?
Answer: Multiplies corresponding elements of arrays and returns their sum
SUMPRODUCT multiplies corresponding array elements together and then adds all those products.
You notice that a column of numbers imported from a database is left-aligned and won't sum. What is the most likely problem?
Answer: The numbers are stored as text, not as numeric values
Numbers stored as text are left-aligned by default and are ignored by SUM; converting them to numbers fixes the issue.
Which Excel view shows exactly how a worksheet will look when printed, including page breaks and margins?
Answer: Print Preview
Print Preview (File > Print) shows a full-fidelity rendering of the printed output with all margins, headers, and footers.