FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
When you sort data ____
A
You change the values of the cells.
B
You choose how the data will be displayed.
C
You remove values that don’t fit in your data set.
D
None of the above
Explanation: 

Detailed explanation-1: -Select any cell in the data range. On the Data tab, in the Sort & Filter group, click Sort. In the Sort dialog box, under Column, in the Sort by box, select the first column that you want to sort. Under Sort On, select the type of sort.

Detailed explanation-2: -Sort A to Z-sorts the selected column in an ascending order. Sort Z to A-sorts the selected column in a descending order. Custom Sort-sorts data in multiple columns by applying different sort criteria.

Detailed explanation-3: -Quicksort. Quicksort is one of the most efficient sorting algorithms, and this makes of it one of the most used as well. The first thing to do is to select a pivot number, this number will separate the data, on its left are the numbers smaller than it and the greater numbers on the right.

There is 1 question to complete.