Câu 11: 70-779: Analyzing and Visualizing Data with Microsoft Excel

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?

1. A. An error message will appear and all the columns except InternalPrice and ResellerPrice will load to the worksheet.
2. B. All the columns except InternalPrice will load to the worksheet. The values in ResellerPrice will be correct.
3. C. All the columns except InternalPrice will load to the worksheet. The values in ResellerPrice will be null. — đáp án hiện tại
4. D. An error message will appear and all the data will fail to load.