Excel Vocabulary Quiz

What is a cell in Excel?

• A single page in a workbook

• A box where a row and column meet

• A type of chart

• A formula

Which of the following is an example of a formula in Excel?

• =A1+B1

• SUM(A1:B1)

• A1+B1

• "Hello"

How can you apply a filter to a column in Excel?

• Right-click on the column and select "Filter"

• Go to the "Data" tab and select "Filter"

• Drag the column to the "Filter" area

• Type "Filter" into the formula bar

What does sorting data in Excel do?

• Changes the data into a chart

• Randomizes the order of data

• Arranges the data in a specific order

• Deletes all the data

Which function would you use to find the sum of a range of cells?

• SUM

• AVERAGE

• COUNT

• MAX

The cell in your worksheet that has been selected. It will have bolder gridlines around it.

• Cell

• AutoSum AutoSum

A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.

• AutoFill

• Active Cell Active Cell