DATABASE FUNDAMENTALS
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: -Quick Sort With Sort Buttons Follow these steps to sort with the Quick Sort command buttons: Select one cell in the column you want to sort. On the Excel Ribbon, click the Data tab. Click Sort A to Z (smallest to largest) or Sort Z to A (largest to smallest)
Detailed explanation-3: -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-4: -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.