Skip to content

6. Add Rows and Duplicate Formulas

Playback Speed:
Transcript

In this video, you will add at least two more rows for products, and replicate the formulas you created in the last video.

Search a different website for additional products and plans.

Find another cell phone that looks interesting, and enter the name in the spreadsheet.

Research specifics of the phone and plan like you did before, and enter the data in the sheet.

Every website is different, so it may take you a few minutes to find the same information.

You can also perform an internet search for the phone itself to find out certain details.

Add columns for specifications that you haven’t already listed in your spreadsheet.

When you get to a column with a formula, like “Total Monthly Charges,” copy it to other rows.

Click on a cell to view the formula in the formula bar.

Then, click on the cell handle, the small box in the corner of the cell.

Drag the box down five or six rows.

A box appears around all the selected cells.

Release the mouse button.

The spreadsheet duplicates the formula in the selected cells.

Repeat this process for “Total Plan Cost” and “Total Cost.”

You could also change the color of columns with calculated values, so that you remember that you do not need to re-enter data in those cells.

Highlight a cell to see if it has a formula or a value.

If it has a formula, select the entire column, and change the fill color.

You can also protect the formulas in these columns so that they can’t be edited accidentally.

Select columns with formulas.

Then, select “Protected Sheets and Ranges” from the menu.

When you try to edit the protected cells, a warning message appears..

Next, research more products and add more information to the spreadsheet.

As you enter information, your total cost cells will update automatically.

Use a wide range of search terms.

For example, search “cheapest cell phone plan” or “best camera phone” to find more information.

Get creative!

Fill out multiple rows for different products until your spreadsheet contains diverse options and enough information to help you make an informed decision.

For this activity, fill out at least three rows.

Then, move on to the next video to use the spreadsheet to help you make a decision.

Now, it’s your turn: Research more phones on different websites.

Add columns for specifications you haven’t already listed in your spreadsheet.

Copy formulas to other rows by dragging the cell handle.

Change the color of the columns that have formulas, so you can recognize them easily.

Preserve the columns as a “protected range.”

When you’ve researched at least 3 phones, move on to the next video.

Next
Instructions
  1. Research more phones on different websites.
  2. Add columns for specifications you haven't already listed in your spreadsheet.
  3. Copy formulas to other rows by dragging the cell handle.
  4. Change the color of the columns that have formulas, so you can recognize them easily.
  5. Preserve the columns as a "protected range."
  6. Research at least 3 products.