1 To display the Sort dialog box, you click Sort & Filter group under the.......... tab.
2. The ....... command arranges data in ascending/descending order.
3. The..
The ... command displays data the user wants to see.
formatting sets a cell's format according to conditions specified by the user.
5.
When you enter a formula in a cell, it also appears in the .......... bar.
Answers
A Microsoft Excel spreadsheet can contain a great deal of information. With more rows and columns than previous versions, Excel 2007 gives you the ability to analyze and work with an enormous amount of data. To most effectively use this data, you may need to manipulate it in different ways.
In this lesson, you will learn how to sort,group, and filter data in various ways that will enable you to most effectively and efficiently use spreadsheets to locate and analyze information.
.hope it will help you
The correct answers are as follows:
1. Data (The Data tab contains the commands with the help of which one can sort, filter, hide details and analyze the data)
2. Sort (The Sort command allows the user to arrange the data in the spreadsheet in the ascending order or the descending order. )
3. Show Details ( With the help of this command, the user can go through the hidden details and information in the chart)
5. Formula Bar (The Formula bar presents the data inserted into each cell of the Excel Spreadsheet.)