Analyzing and Visualizing Data with Microsoft Excel — Question 9

You have a workbook query that loads data from a table named Products.
Products contains a column named InternalPrice that has a Data Type of Decimal.
From Query Editor, you create a custom column named ResellerPrice that uses a formula to multiply InternalPrice by 1.2, and then you remove the InternalPrice column.
What will occur when you load the data to a worksheet?

Answer options

• A. An error message will appear and all the columns except InternalPrice and ResellerPrice will load to the worksheet.
• B. All the columns except InternalPrice will load to the worksheet. The values in ResellerPrice will be correct.
• C. All the columns except InternalPrice will load to the worksheet. The values in ResellerPrice will be null.
• D. An error message will appear and all the data will fail to load.

Correct answer: C

Explanation

The correct answer is C because when the InternalPrice column is removed, the calculation for ResellerPrice has no reference point, leading to null values. Options A and D suggest that an error will occur, but there will be no error message; the data will still load with some columns present. Option B incorrectly states that ResellerPrice will have correct values, which is not the case due to the removal of InternalPrice.