Spreadsheet Practice Activity

							BTT101                                                                        Mr. Deighan


    BTT1O1 – Introduction to Information and Communication
                    Technology in Business

                          Unit 2 – Productivity Software

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

  17. Place your name and the date in a header.

  18. Have someone peer mark your spreadsheet before moving on to exercise #7

  19. Demonstrate to your peer marker how to switch between “show formulas mode”
      and “regular mode”.