Multiple Choice
To create a table from an existing range of data,
A) click within the range, click the Table Tools Design tab, and then select Convert to Table.
B) select any cell in the worksheet then click Existing Range in the Tools group.
C) click in a cell and on the Home tab, click the Insert arrow in the Cells group.
D) click the Insert tab and then click Table in the Tables group.
Correct Answer:

Verified
Correct Answer:
Verified
Q2: In Excel 2010, you can create formatting
Q3: To Freeze Columns and / or rows<br>A)
Q4: In addition to sorting and filtering cells
Q5: You can sort data by one or
Q6: The Table Style Options Group<br>A) enables you
Q8: Filtering<br>A) helps to clean the data before
Q9: Previewing the worksheet in Backstage view<br>A) autoprints<br>B)
Q10: Top Bottom Rules<br>A) is a horizontal gradient
Q11: Freezing keeps rows and / or columns
Q12: The Table Style _ group contains check