Trivia Flashcards
7 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Trivia flashcards as text
Which Excel feature allows you to automatically fill a series of dates, numbers, or text patterns?
Answer: AutoFill
AutoFill uses the fill handle (small square at the bottom-right of a selection) to extend a series automatically.
What is the correct syntax to look up a value in the first column of a table and return a value from another column using VLOOKUP?
Answer: VLOOKUP(value, table_array, col_index_num, range_lookup)
VLOOKUP syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).
In Excel, what symbol is used to make a cell reference absolute?
Answer: $
The dollar sign ($) locks a row or column reference so it does not change when a formula is copied.
What Excel function calculates the internal rate of return for a series of cash flows?
Answer: IRR
IRR (Internal Rate of Return) calculates the discount rate that makes the net present value of a series of cash flows equal to zero.
Which of the following paste options preserves only the calculated values, not the formulas?
Answer: Paste Values
Paste Values (or Paste Special > Values) pastes only the displayed result of a formula, not the formula itself.
What is the name of the Excel feature that highlights cells based on their content or value?
Answer: Conditional Formatting
Conditional Formatting automatically applies colors, icons, or data bars to cells that meet specified criteria.
How many sheets does a new Excel workbook contain by default in Excel 2016 and later?
Answer: 1
Starting with Excel 2013, a new workbook defaults to a single worksheet named 'Sheet1', changed from the previous default of three sheets.