Playback Speed:
Transcript

In this video, you will add information from your recipe to your spreadsheet.

Later, you will apply formulas to increase or decrease the quantities of each ingredient automatically in order to make this recipe for a different number of people.

To begin, look at your recipe to find the number of servings it is designed to make.

Add that number to your spreadsheet under the Servings column heading.

Now add the rest of your recipe information to your spreadsheet.

Start by typing one ingredient into the first cell in the Ingredients column.

Now type the quantity of that ingredient the recipe calls for into the first cell in the Quantities column.

Then type any related unit of measure for that ingredient into the Unit of Measure column in your spreadsheet; for example, one cup or two teaspoons.

Repeat this process for each of the ingredients in your recipe.

You can shorten the names of ingredients to make your spreadsheet easier to read.

You can also widen the columns or wrap the text to fit longer ingredients.

If your recipe includes fractions, list these as decimals.

To convert a fraction to a decimal, divide the top number by the bottom number.

For example, list one-half as point five.

For items without an associated unit of measure, such as eggs, leave the cell blank.

Instructions

  1. Add the number of servings your recipe makes to your spreadsheet.
  2. Add the ingredients, quantities, and units of measure.
  3. Adjust column widths or wrap text, as necessary.
  4. Convert fractions to decimals.