Basics & operators8 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

MediumFree

Defined name: VAT rate

Mr. Hendra owns a computer store in Mangga Dua, Jakarta. The 11% VAT (PPN) rate is in F1, and that cell has been named PPN in the Name Manager so formulas across the file are easier to read.

Task

Fill C2:C6 with the price including VAT: the price (column B) times (1 + the VAT rate). Use the name PPN in the formula instead of the address F1.

Cells to fillC2:C6

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
A defined name can be typed straight into a formula, just like a cell address. Try typing =PPN in an empty cell: it returns 11%.
Hint 2
Price including tax = price times (1 + rate). The parentheses make sure 1 + rate is calculated first.
Hint 3
In C2, multiply B2 by (1+PPN), then copy it down.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

C2:C6

=B2*(1+PPN)

Write it in C2, then fill down to C6.

Explanation

=B2*(1+PPN) reads the rate from the cell named PPN (F1). A name always points to the same cell, so it behaves like an absolute reference without any $ signs. If the VAT rate changes, just update F1 and every price updates. Create your own names in the Name Box left of the formula bar or via Formulas > Define Name.

Starting worksheet: Sheet1
Row	A	B	C	E	F
1	Product	Price	Price incl. VAT	VAT (PPN)	11%
2	14-inch laptop	7,850,000
3	Inkjet printer	2,150,000
4	24-inch monitor	1,899,000
5	Mechanical keyboard	650,000
6	SSD 1 TB	1,275,000
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result