The Complete Excel Guide: Beginners to Advanced - Exercise 6

The Complete Excel Guide: Beginners to Advanced - Exercise 6

Assessment

Interactive Video

Information Technology (IT), Architecture, Business

University

Hard

Created by

Quizizz Content

FREE Resource

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.

Read more

2 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the significance of the date in cell C2 in relation to the invoice payment?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What does the example answer indicate about the invoice value?

Evaluate responses using AI:

OFF