DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
filter
|
|
|
sort
|
|
|
replace
|
|
|
find
|
Detailed explanation-1: -Click the Data tab, and then click Clear.
Detailed explanation-2: -Once the data is filtered, you can delete only the filtered rows by selecting the filtered data and pressing the “Ctrl” and “-” keys on your keyboard at the same time. This will open the “Delete” dialog box. Make sure that the “Shift cells up” option is selected and then click the “OK” button.
Detailed explanation-3: -To simply remove an embedded file or object, select it and press Delete.
Detailed explanation-4: -The FILTER function allows you to filter a range of data based on criteria you define. In the following example we used the formula =FILTER(A5:D20, C5:C20=H2, "") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").
Detailed explanation-5: -Once the auto filter is applied you will see that column headers will have drop-down buttons. You can also clear the filter by clicking on Home tab > Sort and Filter > Clear.