Question

vii. dash box is used to copy the filtered data at another location.​

Answer 1

Explanation:

In addition to sorting, you may find that adding a filter allows you to better analyze your data. When data is filtered, only rows that meet the filter criteria will display and other rows will be hidden. With filtered data, you can then copy, format, print, etc., your data, without having to sort or move it first. To use a filter,

Go to the Home ribbon, click the arrow below the Sort & Filtering icon in the Editing group and choose Filter.