please please give me right answer please friends please fast fast
class 7
sub computer
ch name Advanced MS- Excel
Answers
Answer:
Explanation:
FILL IN THE BLANKS:-
1. Data can be arrange in ascending or descending order using the ...sort... option from the ...data... menu.
2. Data can be filter either in two ways ...Auto Filter... or ...Advanced Filter... .
3. ..SQL..view the data that satisfy more than one condition.
4. The...Blur....filtered are indicated in blue color.
5. In ....conditional.... formatting the cell shading will change when it
satisfy a given condition.
ANSWER THE FOLLOWING QUESTIONS:-
1. Ans: Data sorting is any process that involves arranging the data into some meaningful order to make it easier to understand, analyze or visualize. When working with research data, sorting is a common method used for visualizing data in a form that makes it easier to comprehend the story the data is telling.
2. Ans: (i) Sorting means to arrange data in a particular order which could be ascending or descending order. ... (ii) Filtering is a quick and efficient method where you display only that data that meets a given criteria. Ms excel uses two types of filtering methods, that is, Auto filter and Advanced filter.
3. Ans: you can only add one auto-filter group per worksheet. custom expressions can have only up to two conditions. Excel does not automatically update filters after changing the data in cells.
4. Ans: Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value.
5. Ans: Grouping is also commonly referred to as Outlines. Outlines allow you to organise and your data as well as letting you temporarily hide data you do not want to see. They allow you to collapse or expand levels of details quickly allowing you to create a hierarchy of rows and columns.