Microsoft Excel Formulas & Functions 2

A cell that is highlighted or outlined by a bold black rectangle.  This is also called the current or highlighted cell.

• cell
• column
• active cell
• name box

Cells that run from the top to bottom (VERTICALLY) in a worksheet and are identified by letters

• active cell
• cell
• column
• name box

A line of cells that start at the left edge of a worksheet, continue to the right (HORIZONTAL), and are identified by numbers

• cell
• column
• row
• workbook

A page in a workbook that consists of a grid of rows and columns in which you can enter text, values, and formulas, and perform calculations.

• workbook
• worksheet
• auto fill
• row

A reference that identifies a cell's location in the worksheet based on its row number and column letter.

• external reference
• absolute cell reference
• cell reference
• constant

A6:G29 is an example of what? 

• range
• cells
• group
• selection

Which formulas will add up the numbers for a given range? 

• COUNT
• SUM
• AVERAGE
• MIN

The ______ symbol is used to show addition in Excel.

• -
• +
• *
• /

The _______ displays the location, or name, of a selected cell.

• Name Box
• Status Bar
• home button
• print screen

To __________ the contents of a cell means to change its appearance.

• format
• Search
• Data
• Sort