Microsoft Excel 2021365 - Beginner to Advanced - Exercise 10 - formula auditing

What is the first task you need to perform in the spreadsheet?

• Create a new table

• Delete unnecessary data

• Fix the errors in the spreadsheet

• Add a new column

What should the VLOOKUP formula return based on the order number?

• Customer name and address

• Product and price

• Order date and time

• Supplier details

What is a common cause of a name error in a formula?

• Incorrect data type

• Missing data

• Misspelled formula name

• Incorrect cell reference

How can you identify where an error lies in a formula?

• By guessing

• Using the Evaluate Formula tool

• By deleting the formula

• By changing the cell format

What should you do if a named range is not valid?

• Delete the named range

• Replace it with actual cell references or create a valid named range

• Ignore the error

• Change the worksheet name

What is a likely reason for an NA error in a VLOOKUP formula?

• The formula is too complex

• The lookup value is not found in the table

• The table is too large

• The worksheet is protected

How can you make an error message more meaningful in a VLOOKUP formula?

• By adding more data to the table

• By wrapping the formula in an IFNA function

• By ignoring the error

• By changing the font color