Excel: Basic Calculations and Formatting

Any formula must start with an (a)   sign

If you type "A1+B1" in cell C1, the value of cell C1 would be

• A1+B1

• 3

• =A1+B1

• C1

If you type =A1/B1 in cell C1, the value of cell C1 would be

• 2

• 1

• 0.5

• A1/B1

"=A1+B1" is called a

• formula

• function

"=SUM(A1:B1)" is a

• function

• formula

• both

if you type "=A1*B1" in cell C1

the value of cell C1 would be

• 2

• 3

• 1

• A1*B1

The formula to DIVIDE cell A1 by cell B1 would be

• =A1/B1

• =B1/A1

• =DIV(A1:B1)

• -

the FUNCTION to add cell A1 and B1 would be

• =A1+B1

• =SUM(A1:B1)

• =ADD(A1:B1)

• =A1*B1

the formula to calculate the DIFFERENCE between A1 and B1 would be

• =DIFF(A1:B1)

• =A1-B1

• =MIN(A1:B1)

ALL functions are formulas

• True

• False