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

Animated effects applied to cell transitions

Answer

Highlighted cells that flash when values change

Answer

Small decorative icons inserted into headers

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

Right-click the sheet tab and select Lock Sheet

Answer

Press Ctrl+L to lock all cells

Answer

Go to File and set the workbook as read-only

Question 3

What is the purpose of PivotTables in Excel?

Accepted Answer

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

Answer

To rotate tables by 90 degrees on the page

Answer

To create database connections to external pivot servers

Answer

To generate automated email reports

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

Fills cells with a random color flash effect

Answer

Quickly fills formulas down a column using Ctrl+D

Answer

Fills empty cells with the value above them

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

Double-click the cell and type a comment

Answer

Go to Insert tab and click Text Box

Answer

Press Ctrl+M while the cell is selected

Question 6

What keyboard shortcut saves the current workbook in Excel?

Accepted Answer

Ctrl+S

Answer

Ctrl+W

Answer

Ctrl+P

Answer

F12