USING MICROSOFT EXCEL
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: -Go to the Data tab > Sort & Filter group, and click Clear. Go to the Home tab > Editing group, and click Sort & Filter > 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 ("").