Free Google Sheets Practice Exercises

Question 1 of 3

Try it yourself

In D2, multiply the price (B2) by the quantity (C2).

A

B

C

D

E

F

G

H

I

J

1

2

3

4

5

6

7

8

Item

Price

Qty

Total

Notebook

$4.50

3

Pens

$2.25

4

Folder

$1.75

6

Stapler

$8.00

1

Tape

$3.25

5

Question 2 of 3

Try it yourself

In H2, write an IF that returns "Bonus" when the Revenue in F2 is over 400, and "No Bonus" when it is not.

A

B

C

D

E

F

G

H

I

J

K

L

1

2

3

4

5

6

Date

Salesperson

Region

Product

Units

Revenue

Commission

Bonus?

1/5/2026

Sherlock Holmes

Baker Street

Listening Device

12

$239.88

$24.00

Question 3 of 3

Try it yourself

In G2, write a VLOOKUP that returns the Price for the ID typed in F2.

A

B

C

D

E

F

G

H

I

J

K

1

2

3

4

5

6

7

8

Product ID

Product Name

Price

Stock

Search

Result

SKU-101

Magnifying Glass

$24.99

150

SKU-104

SKU-102

Forensic Chemistry Set

$45.00

75

SKU-101

SKU-103

Pocket Watch

$35.00

200

SKU-105

SKU-104

Field Binoculars

$65.00

50

SKU-102

SKU-105

Cipher Decoder

$28.50

120

SKU-103

Practice Google Sheets right here

Or pick a function

VLOOKUP

XLOOKUP

INDEX MATCH

QUERY

IF

Date Functions

Text Functions