Multiple Choice
Dante uses a worksheet to list sales data from five stores he manages.The worksheet includes a column named Product Type, and Dante wants to calculate subtotals for each product type.What must he do before using the Subtotal feature?
A) Sort the data in the Product Type column.,
B) Convert the range to a table.
C) Outline the data.
D) Remove calculated columns.
Correct Answer:
Verified
Correct Answer:
Verified
Q2: You can use the DELETE key to
Q3: Which of the following is true about
Q19: Stuart inserts the formula '=YEAR ('23-Aug-2012)' into
Q45: To remove conditional formatting from a selected
Q54: How can you move a picture, chart,
Q56: Haley needs to delete an out-of-date column
Q58: Eleanor wants to print the titles that
Q60: Tracing formula _ shows which formulas are
Q61: Which of the following can be the
Q62: To embed an Excel chart in a