MCQ Questions and Answers Flashcards

What is the purpose of the Quick Access Toolbar in Excel?

Answer: To provide one-click access to frequently used commands regardless of which ribbon tab is active

The Quick Access Toolbar sits above or below the ribbon and provides instant access to your most-used commands without needing to switch ribbon tabs.

Which keyboard shortcut selects all cells in the current worksheet?

Answer: Ctrl+A

Ctrl+A selects all cells in the worksheet. If the cursor is within a data range, pressing Ctrl+A first selects that range, then pressing it again selects the entire worksheet.

What happens when you double-click the fill handle (small square at the bottom-right corner of a selected cell)?

Answer: Excel auto-fills the formula or pattern down to match the adjacent column's data range

Double-clicking the fill handle automatically copies the cell's formula or pattern down to the last row that has data in the adjacent column.

What does the Status Bar at the bottom of the Excel window display when you select multiple cells with numbers?

Answer: Average, Count, and Sum of the selected values

By default, the Status Bar shows the Average, Count, and Sum of selected numeric cells, providing instant calculations without writing formulas.

Which of the following is used to combine data from multiple worksheets into a single summary?

Answer: Consolidate

Consolidate (Data tab) combines data from multiple ranges or worksheets using functions like SUM, COUNT, or AVERAGE, creating a unified summary.

What is the purpose of the Watch Window in Excel?

Answer: To monitor the values of specific cells while working in other parts of the workbook

The Watch Window (Formulas tab) lets you monitor cell values in a floating window, which is helpful when you need to see cells that are far away or on different sheets.