You have a workbook query that loads data from a table named Products.
Products contains a column named IntemalPrice 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 IntemalPrice column.
What will occur when you load the data to a worksheet?
A . All the columns except InternalPrice will load to the worksheet The values in ResellerPrice will be correct.
B . An error message will appear and all the data will fail to load.
C . An error message will appear and all the columns except InternalPnce and ResellerPrice will load to the worksheet.
D . All the columns except InternalPrice will load to the worksheet. The values in ResellerPrice will be null.
Answer: A
Leave a Reply