Shared by:
Categories
-
Stats
views:
9
posted:
8/29/2010
language:
English
pages:
2
Document Sample

```							BTT101                                                                        Mr. Deighan

BTT1O1 – Introduction to Information and Communication

Unit 2 – Productivity Software

Exercise 6 – Yearbook Sales
Open the following spreadsheet representing yearbook sales. It is titled “data file” and
can be found on my website.

1. Calculate the value of yearbook sales for all three years. Place your answer in
row 9. Hint: The total books sold multiplied by the cost of each book will give you
the total yearbook sales for each year.

2. Calculate the total revenue for each year in row 11.

3. Calculate the total expenses for each year in row 20.

4. Gross profit is total revenue less total expenses. In row 22, calculate the gross
profit for each year.

5. The yearbook class has to pay 25% in gross profit in tax to the government. In
row 23, calculate how much tax is paid each year.

6. Net profit is the gross profit less any taxes paid. In row 24, calculate the net
profit for each year.

7. Calculate the smallest expense for each year, and show your answers in row 26.

8. Calculate the largest expense for each year and show your answers in row 27.

9. Calculate the average expense for each year and show your answers in row 28.

10. Calculate the total number of expenses for each year and show your answer in
row 29.

11. Insert a row above camera expense and label it “Meals expense”. Input the
amount of \$500 as the meals expense for each year.

12. Merge and centre the title between A1 and D1.

13. Sort the rows of expenses by sorting the 2004 expense amounts in ascending
order.

14. Format all money cells into currency format with two decimal places.

15. Bold all titles and increase the font size.
BTT101                                                                      Mr. Deighan

16. Add single underlines above all totals and a double underline below the net profit.