Spreadsheet lab

Create a small spreadsheet that solves the following problems

• Open your spreadsheet software
• Put your name in cell C1
• Use a formula to calculate the value of this problem: 3458/1729+4 Put a label next to the cell so you know what it means. DO NOT just write down the answer! Have the formula figure it out!
• Place the day of the month you were born in a cell underneath the formula. Label this cell as well.
• Estimate the number of cans of soup you have in your pantry right now. Place that value under the day of the month, and label it.
• Figure out the total ages of the pets in your family. If you want to use a different cell for each pet, that is fine, but label them clearly.
• Estimate the amount of time it took you to get to school this morning in minutes. Label this value
• Move to another part of the page and figure the sum of all the above values.
• Write a formula that will multiply together all the values
• Write a formula that will show the average of all values.
• It's a little known fact that your lucky number can be derived from these values! The formula is this:

Take the Birth date, multiply it by the cans of soup squared. Divide this entire quantity by the sum of the age of your pets and time to school. The resulting value is your lucky number.

Figure it out and put it on the spreadsheet. Use CELL REFERENCES ONLY! Some of the values might change, and you want to be able to re-figure your lucky number.

• Name the range which contains the first formula (3458...), the birth date, cans of soup, age of pets, and time to school. Call this range something clever like Values. You might need to look for some kind of range naming command.
• Calculate the average value of the range. Use the range name in the average formula.
• create some kind of chart demonstrating the values in your
range. Look for some type of chart-creation tool.
• Save and print your spreadsheet.