Excel Flashcards
7 cards from real MOS practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Excel 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.
When working with an Excel Table (Insert > Table), what happens to formulas and formatting when you add a new row at the bottom?
Answer: The table expands and applies existing formatting and formulas to the new row
Excel Tables automatically expand to include new adjacent rows and extend formulas and formatting to them.
Which of these functions calculates the number of workdays between two dates, excluding weekends?
Answer: NETWORKDAYS
NETWORKDAYS calculates the number of whole working days between two dates, excluding weekends and optionally holidays.
In Excel, what is the correct syntax for an IF function?
Answer: IF(logical_test, value_if_true, value_if_false)
The IF function syntax is IF(logical_test, value_if_true, value_if_false) — the condition comes first.
Which Excel view shows exactly how a worksheet will look when printed, including page breaks and margins?
Answer: Page Layout view
Page Layout view displays the worksheet with rulers, margins, headers, footers, and page edges as they will appear when printed.
What is the purpose of the Excel ROUND function?
Answer: Rounds a number to a specified number of digits
ROUND(number, num_digits) rounds a number to the specified number of decimal places or significant digits.
Which Excel feature lets you record a sequence of actions and replay them automatically with a single click?
Answer: Macro
A Macro records a sequence of Excel commands and actions that can be replayed to automate repetitive tasks.