The Complete Excel Guide: Beginners to Advanced - Exercise 02

The video tutorial covers exercise two, focusing on developing an invoice in Excel. It begins with setting up VLOOKUP for part descriptions and handling missing data. The tutorial guides viewers through applying discounts, particularly for door handles, and calculating total prices. It emphasizes the importance of leaving cells blank when no valid data is present and explores advanced formula techniques. The instructor encourages finding unique solutions and highlights that multiple correct approaches exist. The session concludes with a reminder to focus on functionality over matching the instructor's method.

What function is used to determine descriptions for entered part numbers in the exercise?

• MATCH

• INDEX

• VLOOKUP

• HLOOKUP

What is the discount percentage applied to door handles in the exercise?

• 5%

• 15%

• 20%

• 10%

What should the quantity column allow according to the exercise instructions?

• Text values

• Numeric whole numbers

• Dates

• Decimal numbers

What should be done if a part number does not exist in the catalog?

• Apply a standard discount

• Show a default price

• Leave the cells blank

• Display an error message

How should cells be handled when there is no valid part displayed?

• Fill with zeros

• Leave them empty

• Display 'N/A'

• Show an error message

What is suggested if the 'find' function is not suitable for detecting door handles?

• Ignore the issue

• Use a different function

• Use a macro

• Manually check each entry

What is encouraged if your solution differs from the instructor's but still works?

• Discard it

• Consider it equally valid

• Submit it for review

• Change it to match the instructor's