Multiple Choice
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
Correct Answer:
Verified
Correct Answer:
Verified
Q52: Excel is able to group data both
Q53: The first step in using the subtotal
Q54: You created a PivotTable and later made
Q55: Which of the following is not controlled
Q56: When the underlying data changes, a PivotTable
Q58: A(n)_ quickly formats a PivotTable with bold,
Q59: A PivotTable can only display one summary
Q60: A Recommended PivotTable creates a PivotTable on
Q61: If the underlying data for a PivotTable
Q62: The row level above the row you