Working with Formulas - Exercise

Duration: 15 to 25 minutes.

In this exercise, you will use formulas to enter additional data into the quarterly profit and loss statement we are creating for Dave's Lemonade Stand.

- Continue working in the workbook from the last exercise or open Dave's Lemonade Stand - Working with Formulas.xlsx from your Webucator/Excel2013/Exercises folder.
- Use AutoSum to sum the Total Income in row
**5**. - Enter a formula to make payroll 30% of Total Income each quarter.
- Enter a formula to make marketing 25% of the each quarter's Total Income.
- Enter a formula to make Supplies 20% of Total Income each quarter.
- Use AutoSum to sum the Total Expense in row
**10**. - Use a formula to calculate Net Income (Total Income - Total Expense).
- Enter "Margin" in cell
**A12**and then use a formula to calculate the Margin (Net Income / Total Income). - Format all cells to look like they do in the below image:
- Save the workbook.

- Open or go to the specified file.
- Use AutoSum to sum the Total Income in row
**5**.- Select cell
**B5**and click`AutoSum`and press`Enter`. - Grab the
`Fill Handle`in cell**B5**and drag the formula in cell**B5**to cell**E5**.

- Select cell
- Enter a formula to make payroll 30% of Total Income each quarter.
- In cell
**B7**, enter "=B5*.3" - Grab the
`Fill Handle`in cell**B5**and drag the formula in cell**B7**to cell**E7**.

- In cell
- Enter a formula to make marketing 25% of the first quarter's Total Income each quarter.
- In cell
**B8**, enter "=B5*.25". - Grab the
`Fill Handle`in cell**B8**and drag the formula in cell**B8**to cell**E8**.

- In cell
- Enter a formula to make Supplies 20% of Total Income each quarter.
- In cell
**B9**, enter "=B5*.2". - Grab the
`Fill Handle`in cell**B9**and drag the formula in cell**B9**to cell**E9**.

- In cell
- Use AutoSum to sum the Total Expense in row
**10**.- Select cell
**B10**and click`AutoSum`and press`Enter`. - Grab the
`Fill Handle`in cell**B10**and drag the formula in cell**B10**to cell**E10**.

- Select cell
- Use a formula to calculate Net Income (Total Income - Total Expense).
- Select cell
**B11**and enter "=B5-B10". - Grab the
`Fill Handle`in cell**B11**and drag the formula in cell**B11**to cell**E11**.

- Select cell
- Enter "Margin" in cell
**A12**and then use a formula to calculate the Margin (Net Income / Total Income), which should be displayed as a percent.- Enter "Margin" in cell
**A12**. - In cell
**B12**enter "=B11/B5". - Grab the
`Fill Handle`in cell**B12**and drag the formula in cell**B12**to cell**E12**. - Select cells
**B12:E12**and click the`Percent`command.

- Enter "Margin" in cell
- Make any necessary formatting changes.
- Save the workbook.