Microsoft Excel Calculation

Front

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

Back

=A1+B1

Front

What function is used to find the average of a range of cells in Excel?

Back

AVERAGE

Front

What is the operator used for multiplication in Excel?

Back

*

Front

What is the formula to subtract the value in cell B1 from the value in cell A1?

Back

=A1-B1

Front

What is the purpose of using the SUM function in Excel?

Back

To add up the values in a range of cells.

Front

the largest number =MAX(the first cell address:then the second cell address) For Example: =MAX(C1:C33)

Back

Maximum 

Front

Tells excel to include all the cells between the two endpoints. A1:D1

Back

Colon

Front

Error in your formula: #div/0!, AutoFill, #name?, Columns

Back

#name?

Front

Horizontal line of cells

Back

Row

Front

A box that holds data

Back

Cell