Excel Basics Quiz for Students

What is the name of the cell that is colored blue?

• A

• B

• 2B

• B2

What is the basic formula to add two numbers in Excel?

• =ADD(A1, B1)

• =A1 + B1

• =SUM(A1, B1)

• =PLUS(A1, B1)

Which of the following is an example of a cell reference in Excel?

• 5A

• A5

• 5, A

• A-5

What is the function of the 'AutoSum' feature in Excel?

• It automatically saves your work.

• It automatically adds up a range of cells.

• It automatically formats your data.

• It automatically creates charts.

In Excel, what is a 'cell'?

• A small battery used in computers.

• A box where you can enter data.

• A type of chart.

• A formula for calculations.

Which of the following is a correct way to take away A1 from A10

• =A10-A1

• =A1-A10

• A1-A10

• A1,A10

Which symbol do we use for multiplication in Excel?

• *

• X

• +

• #

Which feature in Excel allows you to quickly fill cells with repetitive or sequential data?

• AutoFill

• AutoCorrect

• AutoFormat

• AutoComplete

What does a formula do?

• To keep certain rows or columns visible while scrolling.

• To lock the entire worksheet.

• To save the worksheet automatically.

• Automatically works out an equation

What does a formula always start with?

• +

• *

• =

• -