General Knowledge 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 General Knowledge flashcards as text
Which keyboard shortcut saves the current workbook in Excel?
Answer: Ctrl+S
Ctrl+S saves the active workbook, prompting for a filename if it hasn't been saved before.
What does the AutoFill handle look like in Excel?
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.
What is the default file extension for Excel workbooks in Excel 2016 and later?
Answer: .xlsx
The .xlsx format is the default XML-based format introduced in Excel 2007 and used in all modern versions.
How many rows are available in an Excel 2019 worksheet?
Answer: 1,048,576
Since Excel 2007, each worksheet supports exactly 1,048,576 rows (2^20).
Which tab on the Excel ribbon contains the 'Freeze Panes' option?
Answer: View
Freeze Panes is located in the Window group on the View tab.
What happens when you press Ctrl+Z in Excel?
Answer: Undoes the last action
Ctrl+Z undoes the most recent action, and can be pressed repeatedly to undo multiple actions.
Which of the following is NOT a valid Excel chart type?
Answer: Pyramid Bar
Excel does not have a 'Pyramid Bar' chart type; the standard types include Line, Scatter, Pie, Bar, Column, and others.