Preview

10 - Sorting and Filtering in Excel

 1. Excel offers a variety of sorting and filtering tools to help you refine your data and keep it _______.

  queried

  dropped

  organised

  featured

 2. A company has a spreadsheet containing all the orders customers have made over the last month. They may want to sort by:

  letters contained in each order ID

  date of the order

  alphabetical order

  number of words in each order

 3. Sorting means rearranging the rows based on ____________. For example, you may want to sort a column in alphabetical order.
sorting_by_order_a_to_z_beginner_excel.png

  a report

  some specific criteria

  a number value only

  a letter value alone

 4. The following table contains the data of a real estate company. Each item in the Header Row of the table contains a drop down arrow. The drop down arrows are known as _______ buttons.
real_estate_company_example.png

  formatting

  melted

  formula

  filter

 5. The image below shows a spreadsheet that is sorted.
sorted_or_unsorted_Excel_beginner1.jpg

  TRUE

  FALSE

 6. If a student sorted the following in descending order, which international capital would be first?

  Beirut

  Bogota

  Moscow

  Paris

 7. When the data in one column is related to the data in the remaining columns of the table, you will need to ________ the selection.
how_to_sort.gif

  expand

  query

  form

  report

 8. The filter feature applies a ____________to each column heading, allowing you to select specific choices to narrow a table.
how_to_filter.gif

  drop down menu

  report

  form

  manual sort

 9. In addition to the right-click menu sorting option and the Filter tool on the Data ribbon, Excel has a Sort & Filter tool that allows for __________.

  sorting by alphabetical order only

  finding a specific item

  custom sorting

  searching

 10. For a __________, click the arrow below the Sort & Filtering icon in the Editing Group of the Home Ribbon and choose the Sort A to Z / Z to A icons in the Sort & Filter Group of the Data Ribbon.

  report creation sort

  quick sort

  query sort

  slow sort


Report an error