Preview

04 - SUM Formula

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

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

  percentage only (of any given cells and their totals)

  value of a cell

  text value of the number

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

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

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

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

  all the cells on the spreadsheet together

 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.
editing_cells_tools_formatting_3.png

  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 (=).

  TRUE

  FALSE

 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?
editing_cells_tools_formatting_4.png

  Answer: =SUM(B1:B3)

  Answer: SUM B1+B2+B3=

  Answer: =SUM(B1*B2*B3)

  Answer:=SUM(4+5+6)

 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.
editing_cells_tools_formatting_5_autosum.png

  TRUE

  FALSE

 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.
editing_cells_tools_formatting_6.png

  Answer:=SUM(B2+B8)

  Answer:=SUM(B2:B8)

  Answer:=SUM(B1+B8)

  Answer: SUM (of B2 to B8)

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

  change the value of the formula without changing anything else

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

  do everything without actually typing

  change the formula anytime you wish

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

  A1

  C8

  E10

  D12

 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 
content. 

To solve the problem ____________________________________________
_________________________________________________________________.

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

  simply increase the row height to show the cell content

  simply increase the column width to show the cell content

  simply delete the last letter of the formula