Questions and Answers Flashcards
6 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 6 Questions and Answers flashcards as text
What are sparklines in Excel?
Answer: Tiny charts embedded within a single cell that show data trends
Sparklines are miniature charts that fit inside a single cell, providing a compact visual representation of data trends alongside your numbers.
How do you protect a worksheet from unauthorized changes in Excel?
Answer: Go to Review tab and click Protect Sheet, then set a password
Review > Protect Sheet allows you to set a password and choose which actions users can still perform (like selecting cells or sorting) while preventing other changes.
What is the purpose of PivotTables in Excel?
Answer: To summarize, analyze, explore, and present large datasets interactively
PivotTables transform large flat datasets into interactive summary tables where you can drag and drop fields to analyze data from different angles without writing formulas.
What does the Flash Fill feature do in Excel?
Answer: Automatically recognizes data patterns and fills the remaining cells to match
Flash Fill (Ctrl+E) detects patterns in your data based on examples you provide and automatically fills the remaining cells, such as extracting first names from full names.
How do you insert a comment (note) in a cell in Excel?
Answer: Right-click the cell and select New Comment or press Shift+F2
Right-clicking and selecting New Comment (or Insert Comment in older versions) or pressing Shift+F2 adds a comment that appears as a pop-up when hovering over the cell.
What keyboard shortcut saves the current workbook in Excel?
Answer: Ctrl+S
Ctrl+S saves the workbook to its current location. If the file has never been saved, it opens the Save As dialog to choose a location and filename.