Microsoft Excel General Knowledge 2 — Questions and Answers
Question 1: Which keyboard shortcut saves the current workbook in Excel?
- Ctrl+S (Correct answer)
- Ctrl+W
- Ctrl+P
- Ctrl+N
Correct answer: Ctrl+S
Ctrl+S saves the active workbook, prompting for a filename if it hasn't been saved before.
Question 2: What does the AutoFill handle look like in Excel?
- A small square at the bottom-right corner of a selected cell (Correct answer)
- A green arrow pointing down
- A blue circle in the center of the cell
- A double-headed arrow on the cell border
Correct answer: A small square at the bottom-right corner of a selected cell
The AutoFill handle is the small green square that appears at the bottom-right corner of a selected cell or range.
Question 3: What is the default file extension for Excel workbooks in Excel 2016 and later?
- .xlsx (Correct answer)
- .xls
- .xlsm
- .csv
Correct answer: .xlsx
The .xlsx format is the default XML-based format introduced in Excel 2007 and used in all modern versions.
Question 4: How many rows are available in an Excel 2019 worksheet?
- 1,048,576 (Correct answer)
- 65,536
- 1,000,000
- 2,097,152
Correct answer: 1,048,576
Since Excel 2007, each worksheet supports exactly 1,048,576 rows (2^20).
Question 5: Which tab on the Excel ribbon contains the 'Freeze Panes' option?
- View (Correct answer)
- Page Layout
- Data
- Review
Correct answer: View
Freeze Panes is located in the Window group on the View tab.
Question 6: What happens when you press Ctrl+Z in Excel?
- Undoes the last action (Correct answer)
- Redoes the last action
- Zooms into the worksheet
- Closes the workbook
Correct answer: Undoes the last action
Ctrl+Z undoes the most recent action, and can be pressed repeatedly to undo multiple actions.
Question 7: Which of the following is NOT a valid Excel chart type?
- Pyramid Bar (Correct answer)
- Line
- Scatter
- Pie
Correct answer: Pyramid Bar
Excel does not have a 'Pyramid Bar' chart type; the standard types include Line, Scatter, Pie, Bar, Column, and others.
Microsoft Excel General Knowledge 2
Which keyboard shortcut saves the current workbook in Excel?