USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
true
|
|
|
false
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons. Excel can summarize data in a range of data by inserting subtotals. You can create at most one Excel table in a worksheet.
Detailed explanation-2: -Alphabetize and keep rows together If your data set contains two or more columns, you can use the A-Z or Z-A button to put one of the columns in alphabetical order and Excel will automatically move the data in other columns, keeping the rows intact.
Detailed explanation-3: -Select a cell in the column you want to sort. 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 column that you want to sort.
Detailed explanation-4: -Re: Excel sorting one column only If you highlight just the column you want to sort, then under sort & Filter in the home tab, hit sort A-Z, then press the “continue with current selection” option. This will only sort the selected data, leaving the data next to it alone.