The Complete Excel Guide: Beginners to Advanced - Exercise 6

In this video tutorial, the instructor guides students through exercise 6, focusing on setting the due date for invoice payments. The exercise involves using table references in formulae and determining payment terms based on the invoice value. If the invoice is under $100, payment is due in 15 days; otherwise, it's due in 30 days. The tutorial concludes with a summary of the exercise.

What has the instructor done to the formulae in the order details table?

• Replaced table references with cell references

• Replaced cell references with table references

• Added new formulae

• Removed all formulae

Where should the due date for the invoice payment be entered?

• Cell A1

• Cell H3

• Cell C2

• Cell D15

What is the payment term if the invoice value is less than $100?

• 60 days

• 30 days

• 45 days

• 15 days

If the invoice value is $100 or more, how many days does the client have to pay?

• 10 days

• 20 days

• 15 days

• 30 days

In the example provided, what is the approximate value of the invoice?

• $50

• $200

• $250

• $150