This has really aided my job search and created ample opportunities.”

Online Learner

Creating Opportunities For A Better Life.®

Google Sheets

Single page view print copy

Types of Cell References

Challenge!

To work through the challenge, open GCFLearnFree L14: Monthly Expenses and Order Form and copy the file to your Google Drive. View the instructions below the challenge if you are not sure how to make a copy of the file.

  1. Using the sheet labeled Expenses, in cell B6 create a formula that uses relative cell references to add the values for groceries, utilities, rent, and car.
  2. Use the fill handle to fill in the formula across row 6, from cell B6 through M6.
  3. Double-click on cell M6 to view the formula and the relative cell references. Enter a different value in cell M2. Observe how cell M6 recalculates the value.
  4. Click the sheet labeled Order Form. In cell G5, create a formula that will add the value in cell F5 to the value in cell H14. Use an absolute cell reference to H14 in the formula.
  5. Use the fill handle to drag the formula down column G to fill in the cells from G5 through G12. Double-click on cell G12 to view the formula for accuracy. H14 should be referenced in the formula.
  6. In cell H14, enter 0.07 as the new sales tax. Observe how the cells in column G recalculate.

To copy the example file to your Google Drive:

In these tutorials, we will provide example files you can use to practice what you've learned in each lesson. Because these files are Google Docs we have chosen to share, you will need to copy the file to your Google Drive before you can edit the file.

  1. Click the link at the top of this page to open the example file.
  2. The example file will appear in a new browser tab or window. If you are not currently signed in to your Google account, locate and click Sign in on the top-right corner of the page.
    Screenshot of Google SpreadsheetsSigning in to your Google Account
  3. After you have signed in to your Google account, locate and select File in the toolbar menu and select Make a copy... from the drop-down menu.
    Screenshot of Google SpreadsheetsMaking a copy of the example file
  4. The Copy Document dialog box will appear. Enter a new title for the file, then click OK.
    Screenshot of Google SpreadsheetsNaming the file and clicking OK
  5. The copy of the file will appear in a new browser tab. Now you're ready to start using the example file.
    Screenshot of Google SpreadsheetsViewing the copied example file in a new tab
1 2 3 4