Excel - Basic Fomulas

Which Excel formula would you use to add the numbers in cells A1, A2, and A3 together?

• =ADD(A1, A2, A3)

• =PLUS(A1:A3)

• =SUM(A1:A3)

• 
  =TOTAL(A1:A3)

If you want to subtract the value in cell B2 from the value in cell B1, which formula should you use?

• 
  =B1+B2

• 
  =B1*B2

• 
  =B1/B2

• 
  

  =B1-B2

Which formula would you use to divide the value in cell C1 by the value in cell C2?

• =C1+C2

• 
  =C1/C2

• 
  =C1-C2

• 
  

  =C1*C2

Which of these formulas multiplies the numbers in cells D1 and D2?

• 
  =D1+D2

• 
  

  =D1-D2

• 
  =D1/D2

• 
  =D1*D2

If you want to add up all the numbers from cell E1 to E5, which formula should you use?

• 
  =SUM(E1:E5)

• 
  =ADD(E1:E5)

• 
  =E1+E5

• 
  =TOTAL(E1:E5)