Challenge 6

Relative references

1. Open our example file. Make sure you're signed in to Google, then click File > Make a copy.
2. Select the Challenge sheet.
3. In cell D4, create a formula that would calculate how much the customer would save on each item by multiplying the unit price, quantity, and discount shown in cell E2.
4. Use the fill handle to copy the formula you created in step 3 to cells D5:D12.
5. When you're finished, your spreadsheet should look something like this:

Click here for the complete tutorial on this challenge