Excel Review

The name of the cell's location; such as A8

• Active cell
• Cell Address
• Row
• Heading

It is preset in Excel, and uses numbers or symbols to express a standard math process

• Function
• Heading
• Calculation
• Excel file

Cell Range

• combines multiple lines into on cell
• A combination of numbers and symbols used to express a calculation
• to copy a cell’s contents and formatting into other cells
• a block of cells that can be selected (B4:B16)

What is missing from this function?
=Average (B9, B12)

• This is a cell range, so it should have a colon : between the cell addresses
• Nothing is missing
• There should be a math symbol between the cell addresses
• Average should not be part of it

What is the symbol for multiplication in an Excel function?

• x
• /
• *
• #

If you use the MAX function, what are you trying to find?

• The average for the cell range
• The median number in the cell range
• The largest number in the cell range
• The total of averages in different columns

When inserting a formula, always start with

• equals symbol
• plus symbol
• minus symbol

What would be a correct formula for SUM in excel?

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

A column

• a chart

• a rowe

• a vertical part of the worksheet grid

• changing the type of font

In Excel rows are labeled by

• letters
• numbers
• rows and numbers