wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Quiz

Total questions: 6

Worksheet time: 3mins

Name
Class
Date
1.

What is the formula to calculate the amount of sales for each product?

a)

=C11+D11

b)

=SUM(D11:D14)

c)

=C11*D11

d)

=C11*C12

2.

What is the formula to calculate the total of Sales?

a)

=SUM(C11:C14*D11:D14)

b)

=C11:C14*D11:D14

c)

=SUM(E11:E16)

d)

=SUM(E11:E14)

3.

What is the formula to return the amount of tax according to the amount of Sales?

a)

=E17*(1+D18)

b)

=E17+E18

c)

=E17*D18

d)

=E17/D18

4.

What is the formula for the amount of Sales with tax?

a)

=SUM(E11:E18)

b)

=E17+E18*D18

c)

=SUM(E17:E18)

d)

=E17+E18

5.

For each invoice, you want to add the current date in E1.

a)

=16/03/2025

b)

=TODAY()

c)

=TODAY(TRUE)

d)

=NOW()

6.

How to display each currency number (the unit price and the total) with only 2 digits and the currency symbol in each cell?

a)

Reduce the number of digits

b)

Apply the Accounting format

c)

Apply the Standard format

d)

Apply the Currency format