DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
sort data
|
|
|
data format
|
|
|
save data
|
|
|
background paint
|
Detailed explanation-1: -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: -Sorting is the process of arranging data into meaningful order so that you can analyze it more effectively. For example, you might want to order sales data by calendar month so that you can produce a graph of sales performance. You can use Discoverer to sort data as follows: sort text data into alphabetical order.
Detailed explanation-3: -In the ribbon, click Data > Sort. In the Sort popup window, in the Sort by drop-down, choose the column on which you need to sort. For example, if you want to re-sort the previous example by delivery date, under Sort by, choose delivery.
Detailed explanation-4: -In the Editing group under Home tab, you will easily get the Sort & Filter button.