Which of the following functions will allow the data analyst to organize the table in this manner?

A data analyst has been asked to organize the table below in the following ways:

By sales from high to low –

By state in alphabetic order –

Which of the following functions will allow the data analyst to organize the table in this manner?
A . Conditional formatting
B . Grouping
C . Filtering
D . Sorting

View Answer

Answer: D

Explanation:

Sorting is the function that will allow the data analyst to organize the table in the desired manner. Sorting means arranging the data in a specific order, such as ascending or descending, based on one or more criteria. Sorting can be applied to any column in the table, such as sales or state.

Reference: CompTIA Data+ Certification Exam Objectives, page 11