Excel Formulas: Features/Functions

Which operator corresponds with addition?

• -

• *

• /

• +

What operator is being used in the image?

• +

• -

• /

• *

Which formula would add the January and February profits?

• B2+B3=

• B2+B3

• B3+B4

• =B2+B3

What is the "Active Cell" in Excel?

• The Bottom cell in a worksheet. It is indicated by a dark border onscreen.

• The current cell in a worksheet. It is indicated by a dark border onscreen.

• The top cell in a worksheet. It is indicated by a dark border onscreen.

• The past cell in a worksheet. It is indicated by a dark border onscreen.

Define Cell?

• The dark bordered box in excel.

• A box in Excel that has formulas.

• The intersection of a column or row in a worksheet or table.

• Fx Bar where you input data.

When starting a formula what is the first thing you type in the cell?

• +

• -

• %

• =

The letters in Excel represent the _______?

• columns

• rows

• data

• functions

The numbers (1,2,3) in Excel represent the _____?

• columns

• rows

• functions

How would you write a cell reference formula for cell A1 subtracted by Cell C3?

• A1-C3

• A1-C3=

• =A1-C3

• =C3-A1

If you see a series of "######" in a cell, that means the following:

• You keyed in an incorrect number
• The row height is too high
• The text is incorrectly spelled
• The column width is not wide enough