Question 1

What is the name of the solid square in the lower-right corner of a selected cell that is dragged to copy the contents of a cell?

Accepted Answer

Fill handle

Answer

Label

Answer

Formula bar

Answer

Status bar

Question 2

What does a cell reference like B3 indicate?

Accepted Answer

The column letter and row number that identifies a cell

Answer

The name of the spreadsheet

Answer

The formula used in a cell

Answer

The value contained in the cell

Question 3

What is the primary purpose of a spreadsheet?

Accepted Answer

To solve equations and analyze data

Answer

To store emails

Answer

To display images

Answer

To create presentations

Question 4

How is a formula in Excel defined?

Accepted Answer

A mathematical statement that begins with an equal sign

Answer

Any text in a cell

Answer

A command to format a cell

Answer

A reference to another worksheet

Question 5

What is found on the left side of the formula bar that indicates the active cell's reference?

Accepted Answer

Name box

Answer

Cell pointer

Answer

Ribbon

Answer

Quick Access Toolbar

Question 6

Which part of the Excel window displays commands for opening, saving, and printing?

Accepted Answer

File Tab

Answer

Quick Access Toolbar

Answer

Status bar

Answer

Ribbon

Question 7

What is a label in Excel?

Accepted Answer

Text stored in a cell that cannot be used in calculations

Answer

A type of formula

Answer

A numeric value

Answer

A cell reference

Question 8

What is the purpose of the Status bar in Excel?

Accepted Answer

To display information about a spreadsheet

Answer

To format data

Answer

To provide quick access to tools

Answer

To show cell formulas

Question 9

What is a workbook in Excel?

Accepted Answer

A collection of related worksheets under one Excel file name

Answer

A formula

Answer

A single worksheet

Answer

A cell reference

Question 10

Which part of the Excel interface is used for executing common commands and can be customized?

Accepted Answer

Quick Access Toolbar

Answer

Name box

Answer

File Tab

Answer

Ribbon

Question 11

What is the active cell in an Excel worksheet?

Accepted Answer

The cell in the worksheet in which you can type data, also called the selected cell.

Answer

The cell that is empty and not in use.

Answer

The cell that contains the highest value.

Answer

The cell that is locked for editing.

Question 12

Which of the following describes a cell reference?

Accepted Answer

The column letter and row number that identifies a cell, such as B3.

Answer

The type of data stored in a cell.

Answer

The name of the file.

Answer

The total number of cells in a worksheet.

Question 13

What is the purpose of the Formula bar in Excel?

Accepted Answer

Displays the active cell's contents and allows you to enter or edit data.

Answer

To save the current file.

Answer

To format the appearance of the spreadsheet.

Answer

To show the total number of sheets in a workbook.

Question 14

What does the Fill handle do in Excel?

Accepted Answer

It allows you to drag to copy the contents of a cell to adjacent cells.

Answer

It changes the size of the worksheet.

Answer

It allows you to format text.

Answer

It saves the active file.

Question 15

What is a range in Excel?

Accepted Answer

A group of two or more cells.

Answer

A single cell in a worksheet.

Answer

The title of a workbook.

Answer

The number of rows in a worksheet.

Question 16

What does the Ribbon in Excel contain?

Accepted Answer

Groups of related commands that are divided into tabs.

Answer

The names of all active cells.

Answer

Only the title of the workbook.

Answer

Numerical data from calculations.

Question 17

What is the function of the Status bar?

Accepted Answer

It displays information about a spreadsheet located at the very bottom of the Excel window.

Answer

It shows the formula for the selected cell.

Answer

It contains the file options.

Answer

It is used for editing cell contents.

Question 18

What defines a Workbook in Excel?

Accepted Answer

A collection of related worksheets under one Excel file name.

Answer

The file format of an Excel document.

Answer

The visual appearance of a spreadsheet.

Answer

A single worksheet with data.

Question 19

What type of data is referred to as a Value in Excel?

Accepted Answer

Numeric data that can be used in calculations.

Answer

A reference to another cell.

Answer

Text data that represents a name.

Answer

A formula that produces results.

Question 20

Which of these describes the File Tab in Excel?

Accepted Answer

Displays the commands for opening, saving, and printing a spreadsheet.

Answer

Shows the content of the active cell.

Answer

Displays the current worksheet name.

Answer

Provides access to spreadsheet formulas.

Question 21

What is the active cell in an Excel worksheet?

Accepted Answer

The cell in the worksheet in which you can type data.

Answer

The cell that cannot be edited.

Answer

The last cell in the worksheet.

Answer

Any cell in the worksheet.

Question 22

What does a cell reference indicate?

Accepted Answer

The column letter and row number that identifies a cell.

Answer

The size of the cell.

Answer

The formula used in the cell.

Answer

The color of the cell.

Question 23

What is the purpose of the fill handle?

Accepted Answer

To copy the contents of a cell to adjacent cells.

Answer

To merge two cells together.

Answer

To change the color of a cell.

Answer

To delete the contents of a cell.

Question 24

What must a formula in Excel always begin with?

Accepted Answer

An equal sign.

Answer

A parenthesis.

Answer

A number.

Answer

A letter.

Question 25

What does the name box display in Excel?

Accepted Answer

The cell reference of the active cell.

Answer

The current worksheet name.

Answer

The total of all cells.

Answer

The file size.

Question 26

What is a spreadsheet primarily used for?

Accepted Answer

Solving equations and analyzing data.

Answer

Writing text documents.

Answer

Creating images.

Answer

Producing presentations.

Question 27

Where can you find the Quick Access Toolbar?

Accepted Answer

Above the ribbon.

Answer

At the bottom of the window.

Answer

Inside the formula bar.

Answer

On the worksheet tabs.

Question 28

What is a range in Excel?

Accepted Answer

A group of two or more cells.

Answer

The title of the spreadsheet.

Answer

The total of all cells.

Answer

A single cell.

Question 29

Which part of Excel displays information about the current spreadsheet?

Accepted Answer

The status bar.

Answer

The title bar.

Answer

The formula bar.

Answer

The ribbon.

Question 30

What does a label in Excel refer to?

Accepted Answer

Text stored in a cell that cannot be used in calculations.

Answer

A formula result.

Answer

A numerical value.

Answer

An error message.

Related quizzes

Related quizzes