PdfPrep.com

What will occur when you load the data to a worksheet?

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

Exit mobile version