Fixed Discount References1/1
Spreadsheet practice
Complete each goal to unlock the next task.
Module progress0/1
Goal
Apply an absolute discount reference.
Calculate the discounted price for Notebook using the fixed rate in H25.
Steps
- 1Use the Notebook price.
- 2Subtract the fixed discount rate from 1 before multiplying.
- 3Keep the discount-rate cell fixed with an absolute reference.
- 4Type = to start a formula.
- 5Use B22*(1-$H$25) for this task.
- 6Use the worksheet labels to identify the correct range, criteria, lookup table, or return column.
- 7Press Enter and check the result.
0 points
Spreadsheet workspace
Loading spreadsheet engine...