04 - SUM Formula

 1. A formula is an expression which calculates the ___________. Functions are predefined formulas and are already available in Excel

  percentage only (of any given cells and their totals)

  addition of any numbers (a formula cannot be used to do anything else)

  text value of the number

  value of a cell

 2. For example, cell A3 below contains a formula which adds _______________________________.

  the value of cell A2 to the value of cell A2 again and A1

  the value of cell A2 to the value of cell A1.

  all the cells on the spreadsheet together

  the value of cell A2 to every other value around the cell A1

 3. The cell A3 below contains the SUM function which calculates the sum of the range A1:A2. Select the option that correctly presents the SUM formula.

  Answer: =SUM(A1:A2)

  Answer: SUM=A1+A2:

  Answer: SUM(=A1=A2)+

  Answer: =SUM(A1++A2);

 4. To let Excel know that you want to enter a formula, type an equal sign (=).



 5. A formula is entered into cell B4 in order to add up the cells with the values 4,5 and 6. What would it be?

  Answer: =SUM(B1:B3)


  Answer: SUM B1+B2+B3=

  Answer: =SUM(B1*B2*B3)

 6. The autosum allows a user to simply click a button and have the sum formula written for them. It means that for simple addition you don't have to type out the formula out yourself.



 7. A shop owner wants to enter a formula into cell B9 to add up all the products sold. Select the correct formula from the options below.



  Answer: SUM (of B2 to B8)


 8. Using cell references will ensure that your formulas are always accurate because you can _____________________________.

  change the formula anytime you wish

  do everything without actually typing

  change the value of the formula without changing anything else

  change the value of referenced cells without having to rewrite the formula.

 9. In which cell is there likely to be a SUM formula?





 10. Read the following excerpt and decide how you would solve the problem.
If the result of a formula is too large to be displayed in a cell,
 it may appear as pound signs (#######) instead of a value. 
This means the column is not wide enough to display the cell 

To solve the problem ____________________________________________

  delete any spaces inside the formula and then press 'E' for expand

  simply increase the column width to show the cell content

  simply delete the last letter of the formula

  simply increase the row height to show the cell content