Excercise for beginner: Create an Invoice with Excel

This exercise will show you how to fill the calculated cells to create an invoice template

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

=C11*C12

=C11+D11

=C11*D11

=SUM(D11:D14)

2. What is the formula to calculate the total of Sales?

=SUM(C11:C14*D11:D14)

=C11:C14*D11:D14

=SUM(E11:E14)

=SUM(E11:E16)

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

=E17+E18

=E17/D18

=E17*D18

=E17*(1+D18)

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

=E17+E18

=SUM(E17:E18)

=E17+E18*D18

=SUM(E11:E18)

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

What is the formula to return the current date?

=TODAY(TRUE)

=14/11/2022

=TODAY()

=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?

Reduce the number of digits

Apply the Accounting format

Apply the Currency format

Apply the Standard format

Most Viewed Posts