Question

2. Create the following Excel spreadsheets on vineyard data:

Level I Create a spreadsheet with the following information: Block, Tons per Block, Price per Ton, Gallons

Blocks: Barbera, Cab Franc, Chardonnay, Counoise, Cinsault

Tons: • Barbera - 12.6 • Cab Franc - 11.18 • Counoise - 15.48 • Chardonnay - 15.48 • Cinsault - 6.07

Price/ton: • Barbera - 1050.00 • Cab Franc - 1050.00 • Counoise - 902.50 • Chardonnay - 902.5 • Cinsault - 1050.00

Gallons: • Barbera - 2000 • Cab Franc - 1180 • Counoise - 1062 • Chardonnay - 1180 • Cinsault - 900

Level II Add to the spreadsheet to show:

• Total price of tons per block • Total price of tons • Number of gallons per ton • Total Gallons • Total Tons • Average price per ton • Average gallons per ton

Submit the spreadsheet as is from this point.

Level III • Turn spreadsheet into a table Submit the spreadsheet as a table.

Answer 1

	Tons	Price/ton:	Gallons:
Barbera	12.6	1050	2000
Cab Franc,	11.18	1050	1180
Chardonnay	15.48	902.5	1180
Counoise	15.48	902.5	1062
Cinsault	6.07	1050	900
	Tons	Price/ton:	Gallons:	Total price of tons per block	Number of gallons per ton
Barbera	12.6	1050	2000	13230	158.73
Cab Franc,	11.18	1050	1180	11739	105.55
Chardonnay	15.48	902.5	1180	13970.7	76.23
Counoise	15.48	902.5	1062	13970.7	68.60
Cinsault	6.07	1050	900	6373.5	148.27
Total	60.81			59283.9	557.38
Average gallons per ton			974.903799