Excel Quiz

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

• =C11+D11

• =SUM(D11:D14)

• =C11*D11

• =C11*C12

What is the formula to calculate the total of Sales?

• =SUM(C11:C14*D11:D14)

• =C11:C14*D11:D14

• =SUM(E11:E16)

• =SUM(E11:E14)

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

• =E17*(1+D18)

• =E17+E18

• =E17*D18

• =E17/D18

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

• =SUM(E11:E18)

• =E17+E18*D18

• =SUM(E17:E18)

• =E17+E18

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

• =16/03/2025

• =TODAY()

• =TODAY(TRUE)

• =NOW()

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 Standard format

• Apply the Currency format