Microsoft Excel Trivia 2 — 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).
Microsoft Excel Trivia 2
What year was Microsoft Excel first released for the Macintosh?