Challenge #3 Google Sheets

Let's explore some of the great things that you can make sheets do for you!

Use the attached spreadsheet to make a list of the top 10 things you would buy for yourself if you had tons of $$$!

Requirements:

• Open this spreadsheet and rename it with your Nickname - Top 10 List
• Watch this video to learn how to complete this challenge
• FREEZE the information in Row 1 and fill Row 1 with yellow
• List your top 10 'things' in column A
• List the price of each 'thing' (estimates are fine) in column B (make sure to format as currency - use the '$' on the toolbar!!
• Find the total (SUM) of all your stuff in Column C (you MUST use the SUM FUNCTION - don't just add it up manually; make the sheet do the work!!)
• Insert a chart or graph into your spreadsheet below your list
• In column D, insert a picture of each item into your spreadsheet
• Insert a new column A and rank your list from 1 to 10 (1 being the thing you would buy first, 10 is the thing you would buy last)
• Sort your spreadsheet by column A from least to greatest
• Complete the Google Form to show what you know about Google Sheets and include a link to your finished spreadsheet.