Excel Workshop MCQs

What is a cell in Excel?

• A group of worksheets

• A box where a row and column intersect

• A saved Excel file

• A chart element

Answer explanation

A cell in Excel is defined as a box where a row and a column intersect. This is where data is entered and manipulated, making it a fundamental component of Excel spreadsheets.

What does the formula =SUM(A1:A5) do?

• Counts the cells from A1 to A5

• Finds the highest number

• Adds the values from A1 to A5

• Multiplies the values from A1 to A5

Answer explanation

The formula =SUM(A1:A5) calculates the total of all numeric values in the cells from A1 to A5. Therefore, the correct answer is that it adds the values from A1 to A5.

What is a workbook in Excel?

• A chart of all your data

• A set of filters

• An Excel file that may contain multiple sheets

• A single table only

Answer explanation

A workbook in Excel is an Excel file that can contain multiple sheets, allowing users to organize and manage data across different tabs. This distinguishes it from a single table or other options listed.

What does the AutoSum (∑) feature do?

• Finds the average of numbers

• Automatically inserts charts

• Adds up a selected range of cells

• Fills in values automatically

Answer explanation

The AutoSum (∑) feature is designed to quickly add up a selected range of cells, making it easy to calculate totals without manually entering formulas. This is why the correct answer is 'Adds up a selected range of cells'.

What is the purpose of the Fill Handle?

• Move to a new worksheet

• Copy a cell's content or formula

• Delete cell content

• Save the workbook

Answer explanation

The Fill Handle is a tool in spreadsheet applications that allows users to quickly copy a cell's content or formula to adjacent cells, making data entry and formula replication more efficient.

Which of the following is a function?

• =A1+B1

• =SUM(A1:A10)

• =5+3

• A1:A10

Answer explanation

The correct choice, =SUM(A1:A10), is a function that calculates the sum of the values in the range A1 to A10. The other options are either expressions or references, not functions.

What is a named range?

• A chart

• A new worksheet

• A name given to a cell or range for easy reference

• A formula result

Answer explanation

A named range is a specific name assigned to a cell or group of cells in a spreadsheet, making it easier to reference them in formulas and functions. This enhances clarity and simplifies data management.

How can you apply the same formatting to multiple cells quickly?

• Use the Merge Cells tool

• Use the Format Painter

• Use AutoSum

• Use the Fill Handle

Answer explanation

The Format Painter allows you to quickly copy formatting from one cell to multiple others. This is the most efficient way to apply the same formatting across multiple cells, unlike the other options which serve different purposes.

What does the Formula Bar do?

• Adds graphs

• Shows sheet names

• Displays and edits cell content or formulas

• Saves the workbook

Answer explanation

The Formula Bar is used to display and edit the content or formulas of the currently selected cell in a spreadsheet. This makes it essential for inputting and modifying data.

Which feature keeps headers visible when you scroll down a sheet?

• Wrap Text

• Merge Cells

• Filter

• Freeze Panes

Answer explanation

The 'Freeze Panes' feature allows you to keep specific rows or columns visible while scrolling through a sheet, making it easier to reference headers. This is essential for maintaining context in large datasets.