Which of the following would be an effective calculated field labeled Retail Price to calculate a retail price that is 300% of wholesale price (for example,the wholesale price is $3 and retail price is $9)from a Wholesale Price field?
A)* Wholesale Price * 3
And accept default Name in the Insert Calculated Field dialog box
B)= Wholesale Price * 300
With a Name of Retail Price in the Insert Calculated Field dialog box
C)= Wholesale Price * 3
With a Name of Retail Price in the Insert Calculated Field dialog box
D)Wholesale Price *300
With a Name of Retail Price in the Insert Calculated Field dialog box

Question

Quizplus · Accepted Answer

Option C is the correct answer because the formula is correctly written as "= Wholesale Price * 3" to calculate a retail price that is 300% of the wholesale price. Additionally, the name of the calculated field is given as "Retail Price" which accurately describes the data that will be displayed in the new column. Option A is incorrect because it is missing the "=" sign needed to create a formula, and it does not specify a name for the calculated field. Option B is not correct because the formula uses the number 300 instead of 3, which would result in an incorrect value. Option D is also incorrect because it is missing the "=" sign needed to create a formula.

Which of the Following Would Be an Effective Calculated Field