USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the folowing is a way to sort numbers in decreasing order?
|
|
Select all number s and Click Sort ascending or Sort descending form the View tab
|
|
|
Select all numbers and click on Descending order from the Data tab
|
|
|
Select all numbers and click Sort from the Data tav, then check, Sort left to right form Sort options
|
|
|
all of them
|
Explanation:
Detailed explanation-1: -Select a single cell in the column you want to sort. Click Sort A to Z to perform an ascending sort (A to Z or smallest number to largest). Click Sort Z to A to perform a descending sort (Z to A or largest number to smallest).
Detailed explanation-2: -Sorting them in descending order would look like this: 80, 56, 49, 20, 11 . You always start first with the largest number on the left and end with the smallest one on the right. In this example, 80 is the largest and 11 is the smallest. The numbers in between are also in order from largest to smallest.
Detailed explanation-3: -To sort the records in descending order, use the DESC keyword.
There is 1 question to complete.