Excel & Sheets practice: Anatomy of a Formula & Cell Locking
Chapter 1 · 2 questions · free to solve
Question 1 · easy
Lock the GST rate
Solve it in your browserCell M1 holds the GST rate (18%). In K2, calculate the revenue including GST for order SO-1001. Write it so it can be filled down to K21 — the revenue should move with each row, the GST rate must not.
Question 2 · easy
Where does the reference go?
Solve it in your browserCell D2 contains
=B2*C1. You copy D2 and paste it into D3. What formula is in D3?
These questions are free.
Make a free account to solve them, with instant checking and an AI tutor for hints.
Start free