DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
arrange data to line up a certain way
|
|
|
represent data in a certain way
|
|
|
sort for items by specific criteria
|
|
|
rename data
|
Detailed explanation-1: -You sort data to quickly organize your data and to find the data that you want. You filter data to display only the rows that meet criteria that you specify and hide rows that you do not want displayed, for one or more columns of data.
Detailed explanation-2: -What is data filtering in IT? Data filtering is the process of examining a dataset to exclude, rearrange, or apportion data according to certain criteria. For example, data filtering may involve finding out the total number of sales per quarter and excluding records from last month.
Detailed explanation-3: -If the data you want to filter requires complex criteria (such as Type = “Produce” OR Salesperson = “Davolio"), you can use the Advanced Filter dialog box.