Search Header Logo
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

Practice Problem

Hard

Created by

Wayground 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

5 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Cell A1

Cell H3

Cell C2

Cell D15

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

60 days

30 days

45 days

15 days

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

$50

$200

$250

$150

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?