What is filter? Write down the steps to filter records using the Standard Filter option
)
What are reports? Write down all the necessary stens to make a renon
Answers
Q. 1 Answer
To filter data:
Begin with a worksheet that identifies each column using a header row.
Select the Data tab, then locate the Sort & Filter group.
Click the Filter command.
Drop-down arrows will appear in the header of each column.
Click the drop-down arrow for the column you want to filter.
The Filter menu appears
Q. 2 Answer
Report writing is a formal style of writing elaborately on a topic.
1) Executive summary – highlights of the main report.
2) Table of Contents – index page.
3) Introduction – origin, essentials of the main subject.
4) Body – main report.
5) Conclusion – inferences, measures taken, projections.
Explanation:
Filter for the top or bottom set of values
1.Click a cell in the range or table that you want to filter.
On the Data tab, click Filter.
2.Click the arrow.
3.in the column that contains the content that you want to filter.
4.Under Filter, click Choose One, and then enter your filter criteria.