Spreadsheet Practice Activity
Shared by: drr10525
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”.