English, asked by ihtishamurrehman3, 9 months ago

excel spreadsheets organize information i.e text and number by

Answers

Answered by Robinhood118
0

Answer:

See below and please mark as Brainliest.

Explanation:

1.] Select the data to sort    

i] Select a range of tabular data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). The range can include the first row of headings that identify each column.

2.] Sort quickly and easily    

i]Select a single cell in the column you want to sort.

 ii]On the Data tab, in the Sort & Filter group, click A to Z command in Excel that sorts A to Z or smallest number to largest to perform an ascending sort (from A to Z, or smallest number to largest).

 iii]Click Z to A command in Excel that sorts Z to A or largest number to smallest to perform a descending sort (from Z to A, or largest number to smallest).

 3.] Sort by specifying criteria    

Use this technique to choose the column you want to sort, together with other criteria such as font or cell colors.

i.]Select a single cell anywhere in the range that you want to sort.

ii.]On the Data tab, in the Sort & Filter group, click Sort to display the Sort popup window.  

iii]In the Sort by dropdown list, select the first column on which you want to sort.  

iv]In the Sort On list, choose Values, Cell Color, Font Color, or Cell Icon. v]In the Order list, choose the order that you want to apply to the sort operation—alphabetically or numerically, ascending or descending (that is, from A to Z (or Z to A) for text, or lower to higher, or higher to lower for numbers).

Similar questions