DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Under which Tab, the Filters options are available in MS Excel?
|
|
Data
|
|
|
Insert
|
|
|
Home
|
|
|
View
|
Explanation:
Detailed explanation-1: -On the Data tab, in the Sort & Filter group, click Filter. in the column header to display a list in which you can make filter choices.
Detailed explanation-2: -Sort and filter command is available on the a) HOME tab. Go to the Home tab, and then click the arrow below the Sort & Filtering icon in the Editing Group under the home tab and choose Filter or Sort according to your needs. To clear under the same drop-down box, click on clear.
Detailed explanation-3: -The Home menu is the second menu in the Excel menu bar. The Home ribbon items include options for formatting font, color, conditional formatting, filter, number type, and more. All these functions help one in performing various effective calculations.
There is 1 question to complete.