Excel - References & Formulas

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.

What is the Sum formula?

• Sum( )

• Sum( )=

• =Sum( )

• =( )Sum

Tags

CCSS.6.SP.B.5C

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

• +

• -

• %

• =

To quickly add a set of numbers you can use the ____ feature?

• Plus Sum Button

• Add Sum Button

• Quick Add Button

• Auto Sum Button

A function in Excel is represented by what to letters?

• f( )

• xF

• xf

• fx

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

Cells are identified by the following:

• Column Letter followed by their Row Number
• Row Number followed by their Column Letter
• Row Number Only
• Column Letter Only

To create a formula, you first:

• Select the cell you want to place the formula into
• Type the equals sign (=) to tell Excel that you're about to enter a formula
• Enter the formula using any input values and the appropriate mathematical operators that make up your formula
• Choose the new command from the file menu

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)