# 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 _______________________________.

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.

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?

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.

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.

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 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?

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