Create a workbook named:

Formula_Tab_Practice.xlsx

Part 1 — Basic Formulas

Create:

Product	Quantity	Price	Total
Pen	10	20
Notebook	5	50
File	8	40
Folder	6	60

Calculate Total using:

=B2*C2

Part 2 — References

Add:

Tax Rate = 18%

Calculate tax using an absolute reference.

=C2*$F$1

Part 3 — Named Range

Create a named range:

TaxRate

Use:

=C2*TaxRate

Part 4 — Operators

Perform:

• Addition
• Subtraction
• Multiplication
• Division
• Percentage
• Power

Part 5 — Formula Auditing

Use:

• Trace Precedents
• Trace Dependents
• Show Formulas
• Remove Arrows
• Error Checking

Part 6 — Calculation

Test:

• Automatic Calculation
• Manual Calculation
• Calculate Now
• Calculate Sheet

Final Task

Create a professional Formula Practice Workbook demonstrating all the concepts learned in this Topic.