1. Predict what will happen if you type the formula "=A1*C1" into cell C2 of your spreadsheet.

2. Type in the formula, and press enter to check your prediction.

1. Predict what will happen next if you delete the formula in cell A1 and replace it with the number 100.

2. Replace the formula with the number, and press enter to check your prediction.

1. Predict what will happen if you copy cell C2 and paste it into cell D2 of your spreadsheet.

2. Copy and paste the formula to check your prediction.

Set up a spreadsheet with these column labels in the first row.

1. Type the information about the ingredients in your recipe into the first 3 columns of the spreadsheet.

2. Type a formula into cell D2 to automatically calculate the amount per serving for your first ingredient.

3. Copy cell D2 and paste it into the cells beneath it to calculate the amount per serving for the rest of your ingredients. Pause here so your teacher can review your work.

Add these column labels to your spreadsheet.

1. Research the cost of each ingredient in your meal, and record the information in columns E, F, and G. For example, if 6 cups of an ingredient could be bought for \$1.99, the price would be 1.99, the purchase amount would be 6, and the purchase unit would be cups.

2. Type a formula into cell H2 to automatically calculate the cost per purchase unit for your first ingredient.

3. Copy cell H2, and paste it into the cells beneath it to calculate the cost per purchase unit for the rest of your ingredients.

Add these column labels to your spreadsheet.

1. Complete column I with how many of your recipe units are in 1 of your purchase unit for each ingredient. For example, if your recipe unit were cups and your purchase unit were gallons, then your conversion would be 16 because there are 16 cups in 1 gallon.

2. Type a formula into cell J2 to calculate the cost per recipe unit for your first ingredient.

3. Type a formula into cell K2 to calculate the cost per serving for your first ingredient.

4. Compare formulas with your partner. Discuss your thinking. If you disagree, work to reach an agreement.

5. Copy cells J2 and K2, and paste them into the cells beneath them to calculate the cost per recipe unit and cost per serving for the rest of your ingredients.

Type a formula into the first empty cell below your last ingredient in column K to calculate the total cost per serving for all of the ingredients in your recipe. Record the answer here.