Chapter 4: MS Excel: Basic Data Operations
Choose the correct answer.
- Which of the following types of data can be sorted from oldest to newest?
(b) Date
- Sorting can be done in which of the following directions in Excel?
(c) Both a. and b
- The option Contains is available in which of the following filter types?
(a) Text
- Before calculating the subtotals, it is advisable to perform which of the following on the data set?
- Sort the data
- Conditional formatting works on the basis of which of the following?
- Cell value
- Fill in the blanks.
- By default, the First column is considered as basis for sorting the data.
- The options Sort A to Z, Sort Newest to Oldest, etc. are examples of sort Order.
- The Filter operation hides the unwanted data in the data set.
- In Subtotal, At each change in refers to a Field.
- The data can be sorted in 2 directions (ascending and descending).
- Answer the following questions.
- What is the significance of sorting the data?
Sorting data organizes it in a meaningful order, such as alphabetical, numerical, or chronological. This makes it easier to analyze, search, and retrieve specific information. It helps in quickly identifying patterns, trends, and outliers, which can improve data analysis and management tasks.
- Why do we need to sort the data before calculating subtotals?
Sorting data before calculating subtotals is crucial because the subtotal function summarizes groups of related data. Sorting brings together all entries belonging to the same group or category. This allows for accurate and meaningful subtotal calculations based on those distinct groups.
- How does filtering help in understanding the data easily?
Filtering allows users to focus on a specific subset of information that meets certain criteria. It temporarily hides irrelevant data, simplifying the identification of specific patterns, trends, or irregularities within the selected data. This enables more targeted analysis and quicker insights without altering the original dataset.