Multiple Choice
To remove duplicate records (rows) ,
A) select any cell in the table, then click Remove Duplicates from the Tools group on the Table Tools Design tab.
B) click the Remove tab and then Duplicate in the Records group.
C) click in a cell and on the Home tab, click the Remove arrow in the Cells group.
D) convert it to a Range.
Correct Answer:

Verified
Correct Answer:
Verified
Q22: Each _ in an Excel table represents
Q23: To Freeze Columns and / or rows
Q24: Conditional formatting is the process conditioning data
Q25: In Excel 2010, Dataset<br>A) indicates where data
Q26: Sorting Dates oldest to newest<br>A) is the
Q28: A _ reference is a tag or
Q29: Once you set custom page breaks, Excel
Q30: A _ bar is a horizontal gradient
Q31: To create a _ from an existing
Q32: Filtering the Date column (field)to show only