FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To filter data means to
A
arrange data to line up a certain way
B
represent data in a certain way
C
sort for items by specific criteria
D
rename data
Explanation: 

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.

There is 1 question to complete.