Preview

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)

  text value of the number

  value of a cell

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

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

  all the cells on the spreadsheet together

  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

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

  FALSE

  TRUE

 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*B2*B3)

  Answer: =SUM(B1: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

  FALSE

  TRUE

 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(B1+B8)

  Answer: SUM (of B2 to B8)

  Answer:=SUM(B2:B8)

  Answer:=SUM(B2+B8)

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

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

  change the formula anytime you wish

  change the value of the formula without changing anything else

  do everything without actually typing

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

  A1

  D12

  E10

  C8

 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 ____________________________________________
_________________________________________________________________.

  simply increase the column width to show the cell content

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

  simply delete the last letter of the formula

  simply increase the row height to show the cell content