Microsoft Excel Trivia 3 — Questions and Answers
Question 1: Which Excel feature allows you to automatically fill a series of dates, numbers, or text patterns?
- AutoCorrect
- AutoFill (Correct answer)
- AutoFormat
- AutoComplete
Correct answer: AutoFill
AutoFill uses the fill handle (small square at the bottom-right of a selection) to extend a series automatically.
Question 2: 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?
- VLOOKUP(value, range, row_num, match)
- VLOOKUP(value, table_array, col_index_num, range_lookup) (Correct answer)
- VLOOKUP(col_index, value, table_array, match)
- VLOOKUP(value, col_index_num, table_array, match)
Correct answer: VLOOKUP(value, table_array, col_index_num, range_lookup)
VLOOKUP syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).
Question 3: In Excel, what symbol is used to make a cell reference absolute?
- #
- @
- $ (Correct answer)
- &
Correct answer: $
The dollar sign ($) locks a row or column reference so it does not change when a formula is copied.
Question 4: What Excel function calculates the internal rate of return for a series of cash flows?
- NPV
- IRR (Correct answer)
- RATE
- YIELD
Correct 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.
Question 5: Which of the following paste options preserves only the calculated values, not the formulas?
- Paste All
- Paste Formulas
- Paste Values (Correct answer)
- Paste Formats
Correct answer: Paste Values
Paste Values (or Paste Special > Values) pastes only the displayed result of a formula, not the formula itself.
Question 6: What is the name of the Excel feature that highlights cells based on their content or value?
- Data Validation
- Conditional Formatting (Correct answer)
- Cell Styles
- Theme Colors
Correct answer: Conditional Formatting
Conditional Formatting automatically applies colors, icons, or data bars to cells that meet specified criteria.
Question 7: How many sheets does a new Excel workbook contain by default in Excel 2016 and later?
- 3
- 1 (Correct answer)
- 2
- 5
Correct answer: 1
Starting with Excel 2013, a new workbook defaults to a single worksheet named 'Sheet1', changed from the previous default of three sheets.
Microsoft Excel Trivia 3
Which Excel feature allows you to automatically fill a series of dates, numbers, or text patterns?