Q1. Which of the following is a method in a spreadsheet for arranging data in ascending or descending order?
Explanation
In a spreadsheet, sorting arranges records according to a selected column or range, either in ascending order such as A to Z or smallest to largest, or in descending order such as Z to A or largest to smallest. Filter is used to display only rows that meet chosen conditions, not to arrange all data. Auto Sum calculates totals or related aggregate values. A logical operator, such as AND or OR, is used in formulas to test conditions. Therefore, the method specifically meant for arranging data by order is sorting.
