Sort, filter, and a simple table

Question 1 of 7

1. A safe habit before sorting Amounts is:

   Sort only column C and ignore the item names Hide column A forever Delete the header row Select or include every column of the list so rows stay together
2. The Sort dialog Microsoft describes is opened from:

   Data tab > Sort & Filter group > Sort File > New Insert > Chart Formulas > AutoSum
3. After Data > Filter, you choose which rows to see by:

   Printing the sheet Typing a formula that starts with # Clicking the arrow in a column header, clearing Select All, and ticking the values you want Changing the file type to PDF
4. Filtered rows that do not match are:

   Permanently deleted from the computer Hidden until you clear the filter or show all values again Moved into a new workbook automatically Converted into a chart
5. Home > Format as Table requires you to:

   Add a trendline Choose a style and confirm the range and whether the list has headers Turn off saving Pass a MOS exam first
6. Quick Analysis > Tables > Table is:

   The only way to make a table on a Mac A way to send email A Windows desktop path Microsoft documents in Basic tasks (you may not see the button on every device) A tax tool
7. This basics course does **not** ask you to build:

   A filter on Category A sort by Amount A simple table A PivotTable or Power Query