Microsoft Excel Questions and Answers 3

Question 1

What are sparklines in Excel?

Accepted Answer

Tiny charts embedded within a single cell that show data trends

Answer

Sparklines are miniature charts that fit inside a single cell, providing a compact visual representation of data trends alongside your numbers.

Question 2

How do you protect a worksheet from unauthorized changes in Excel?

Accepted Answer

Go to Review tab and click Protect Sheet, then set a password

Answer

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.

Question 3

What is the purpose of PivotTables in Excel?

Accepted Answer

To summarize, analyze, explore, and present large datasets interactively

Answer

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.

Question 4

What does the Flash Fill feature do in Excel?

Accepted Answer

Automatically recognizes data patterns and fills the remaining cells to match

Answer

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.

Question 5

How do you insert a comment (note) in a cell in Excel?

Accepted Answer

Right-click the cell and select New Comment or press Shift+F2

Answer

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.

Excel Practice Test

Excel Practice Test

Microsoft Excel Questions and Answers 3