Spreadsheets

1. learning.com

---

2. translation spreadsheet

directions

1. Click on the starter spreadsheet to the right to create a copy of the 50 most common english nouns.
2. Insert a row at the top.
3. Title the column A "English" and column B "Spanish" (or another language of your choice)
4. Bold the header row
5. Click in cell B2 and input the google translate function =GOOGLETRANSLATE(A2,"en","es")
6. Open ​google translate and look up 5 words and their pronunciation.
7. Copy the pronunciation URL and insert it as a link on the word in your spreadsheet.

50 most common english nouns

Language codes

---

3. At the movies spreadsheet

directions

1. Click on the starter spreadsheet to the right to make a copy of the "At the Movies" spreadsheet.
2. ​In cell B16, calculate the Total Tickets Sold for the week.
3. In cell C16, calculate the Total Popcorn Sold for the week.
4. In cell D16, calculate the Total Hotdogs Sold for the week.
5. In cell B17, calculate the money made from selling the tickets
6. In cell C17, calculate the money made from selling the popcorn
7. In cell D17, calculate the money made from selling the hotdogs
8. In cell B18, calculate the total money made over the week
9. Create a graph which shows the number of tickets sold each day.