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.
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Editorial policy