Understanding Cell Ranges in Excel

What is a cell in Excel?

• A place to store a number or text

• A type of animal

• A type of food

What do we call the vertical lines in Excel?

• Rows

• Columns

• Cells

What do we call the horizontal lines in Excel?

• Rows

• Columns

• Cells

What is a cell reference in Excel?

• A number that shows the size of the cell

• The name of a cell, like A1 or B2

• A type of formula

What is a cell range in Excel?

• A group of cells, like A1:A5

• A single cell, like A1

• A type of chart

If you want to add numbers in cells A1, A2, and A3, which formula would you use?

What does the AutoSum button do in Excel?

• It multiplies numbers

• It adds up numbers

• It subtracts numbers

Which of the following is a correct cell reference?

• 1A

• A1

• A-1

If you want to select cells from B1 to B5, what is the correct cell range?

• B1:B5

• B1-B5

• B1 to B5

• 10

• 8

• 15