In this lesson, you built a spreadsheet to help you adjust the number of servings in a recipe.
To complete this project, you:
Created a new spreadsheet and named it...
Selected a recipe, added the title to your spreadsheet, and formatted it...
Added headings for the recipe information and formatted them...
Entered the details of your recipe into your spreadsheet...
Chose a new number of servings and added a formula to find the conversion factor...
And added formulas with relative and absolute cell references
to convert the original ingredient quantities to new quantities.
If you would like to make this recipe in the future,
make sure to include the recipe’s directions.
You can type or paste them directly into your spreadsheet.
Or, you can link the title of the recipe in your spreadsheet to the recipe’s website.
To do this, copy the link to the recipe’s website.
And add the link to your spreadsheet.
When adapting recipes in this way, remember to adjust other parts of the recipe, as well.
For example, you may need a larger or smaller bowl or baking dish.
Or you may need to adjust the cooking time.
As you become familiar with adjusting recipes, you can also try substituting different ingredients.
You can change the flavorings, substitute different vegetables,
or use different types of pasta.
The spreadsheet skills you learned in this lesson could also be applied to more than just recipes.
For example, you could use similar formulas in a spreadsheet to adjust a budget
or the number of different supplies you will need for an event.
Whatever you use it for, a spreadsheet can help
keep information organized and make mathematical calculations simpler.