Microsoft Excel Trivia — Questions and Answers
Question 1: What year was Microsoft Excel first released for the Macintosh?
- 1982
- 1985 (Correct answer)
- 1987
- 1990
Correct answer: 1985
Microsoft Excel was first released in 1985 for the Apple Macintosh, two years before the Windows version.
Question 2: Which Excel function returns the number of cells in a range that are not empty?
- COUNT
- COUNTA (Correct answer)
- COUNTBLANK
- COUNTIF
Correct answer: COUNTA
COUNTA counts all non-empty cells in a range, including text, numbers, and errors.
Question 3: What is the maximum number of rows in a modern Excel worksheet (Excel 2007 and later)?
- 65,536
- 524,288
- 1,048,576 (Correct answer)
- 2,097,152
Correct answer: 1,048,576
Excel 2007 and later supports 1,048,576 rows per worksheet, a massive increase from the 65,536 limit in earlier versions.
Question 4: Which keyboard shortcut inserts the current date into an Excel cell?
- Ctrl+D
- Ctrl+; (Correct answer)
- Ctrl+T
- Ctrl+Shift+D
Correct answer: Ctrl+;
Ctrl+; (semicolon) inserts the current date as a static value into the active cell.
Question 5: What does the TRIM function do in Excel?
- Removes all spaces from text
- Removes leading and trailing spaces and reduces internal spaces to one (Correct answer)
- Cuts text to a specified length
- Removes numeric characters from text
Correct answer: Removes leading and trailing spaces and reduces internal spaces to one
TRIM removes leading and trailing spaces and reduces any internal sequences of spaces to a single space.
Question 6: Which Excel chart type is best suited for showing data trends over time with continuous data?
- Bar chart
- Pie chart
- Line chart (Correct answer)
- Radar chart
Correct answer: Line chart
Line charts are ideal for displaying continuous data trends over time, clearly showing direction and rate of change.
Question 7: What does the F4 key do when editing a cell formula in Excel?
- Deletes the current cell
- Toggles absolute/relative cell references (Correct answer)
- Opens the function wizard
- Saves the workbook
Correct answer: Toggles absolute/relative cell references
F4 cycles through the four reference types: relative (A1), absolute ($A$1), mixed ($A1), and mixed (A$1).
Question 8: 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 9: 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 10: In Excel, what symbol is used to make a cell reference absolute?
Correct answer: $
The dollar sign ($) locks a row or column reference so it does not change when a formula is copied.
Question 11: 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 12: 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 13: 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 14: How many sheets does a new Excel workbook contain by default in Excel 2016 and later?
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.
Question 15: Which function would you use to combine the text from two or more cells into one cell?
- MERGE
- JOIN
- CONCATENATE (Correct answer)
- APPEND
Correct answer: CONCATENATE
CONCATENATE (or the & operator, or CONCAT in newer versions) joins text strings from multiple cells into a single string.
Question 16: What does 'PivotTable' allow you to do in Excel?
- Rotate charts to new orientations
- Summarize and analyze large data sets interactively (Correct answer)
- Merge multiple worksheets
- Create drop-down menus
Correct answer: Summarize and analyze large data sets interactively
A PivotTable is an interactive tool that quickly summarizes, groups, and analyzes large datasets without changing the original data.
Question 17: Which Excel function returns the position of a value within a range?
- FIND
- SEARCH
- MATCH (Correct answer)
- INDEX
Correct answer: MATCH
MATCH returns the relative position (row or column number) of a specified value within a range.
Question 18: What is the file extension for a macro-enabled Excel workbook?
- .xlsx
- .xlsm (Correct answer)
- .xltm
- .xlam
Correct answer: .xlsm
The .xlsm extension denotes a macro-enabled Excel workbook, while .xlsx files cannot contain VBA macros.
Question 19: Which Excel tool is used to find the input value needed to achieve a specific formula result?
- Solver
- Goal Seek (Correct answer)
- Scenario Manager
- Data Table
Correct answer: Goal Seek
Goal Seek finds the required input value by working backward from a desired formula result.
Question 20: What does the IFERROR function do in Excel?
- Counts errors in a range
- Returns a custom value if a formula produces an error, otherwise returns the formula result (Correct answer)
- Highlights error cells in red
- Prevents errors from being entered
Correct answer: Returns a custom value if a formula produces an error, otherwise returns the formula result
IFERROR evaluates a formula and returns a specified value (like blank or text) if it results in an error, instead of displaying the error code.
Question 21: In Excel, what is a 'named range'?
- A range with color-coded cells
- A cell or range of cells given a descriptive name for use in formulas (Correct answer)
- A range that has been sorted alphabetically
- A range linked to an external data source
Correct answer: A cell or range of cells given a descriptive name for use in formulas
A named range assigns a meaningful label to a cell or range, allowing you to use that name instead of cell addresses in formulas.
