INTRO TO FORMULA IN EXCEL

All formula start with which symbol?

• ?

• =

• - -

• ""

What symbol do we use to subtract?

• +

• _

• /

• *

What symbol do we use to multiply?

• x

• *

• /

• &

What symbol do we use to divide?

• x

• ÷

• /

• &

What symbol do we use to divide?

• x

• ÷

• /

• &

Which formula do we use to divide one cell from another?

• =(A1÷B1)

• =sum(A1/A2)

• =(A1÷B1)

• =(A1DIVB1)

Which formula do we use to multiply (times) one cell with another?

• =(A1xB1)

• =sum(A1A2)

• =(A1*B1)

• =(A1/B1)

Which formula do we use to take one cell away from another?

• =(A1-B1)

• =A1/B1

• A1-B1

• B3:B5

Which formula do we use to add more than two cells together?

• =(A1+B1)

• =sum(A1:A2)

• =SUM(A1:A3)

• =SUM(A1:A2)

Which formula do we use to add two cells together?

• =(A1+B1)

• =A1B1

• =A1+B2+

• =SUM(A1+A2)