Google Sheets Activity 5

To-Do Date: Sep 7 at 11:59pm

Activity 5: Use named ranges to perform calculations

Now, you’ll continue working with your spreadsheet from the previous activity to calculate information for rye bread this year. This time, you’ll use named ranges for your formulas.

Complete the following steps:

1. In your spreadsheet “On the Rise forecast report_YOURNAME”, select cells Q3:S102, right-click, and select Define the named range.

2. Name the range “RyeBreadQuarter1” and select Done.

3. Name the following ranges:

a. T3-V102 “RyeBreadQuarter2”

b. W3-Y102 “RyeBreadQuarter3”

c. Z3-AB102 “RyeBreadQuarter4”

4. In cell S103, use a SUM formula to calculate the total rye bread sales forecast for quarter 1. Type =SUM and select the named range RyeBreadQuarter1.

5. In cell S104, use an AVERAGE formula to calculate the average rye bread sales forecast for quarter 1. Type =AVERAGE and select the named range RyeBreadQuarter1.

6. Repeat steps 4 and 5 for all rye bread quarters.

Now let’s add some formatting.

7. Select Rows 103-104, then click the Bold toolbar icon.

8. Select cells E3:AN104, then click Format as currency.

9. Select Columns E-AN, right click, then choose Resize columns E-AN, then select Fit to data, then click OK.

Do not close your Google Sheet. You will use it in the next activity.