Count and Sort

Sorting of data in excel means---------------

• arranging the data in ascending or descending order

• arranging data in any order

• arranging data in mixed combination of letters

• arranging data in mixed combination of numbers

The command we use to sort data in an excel sheet located in

• File menu

• Home menu

• Data menu

• Insert menu

What are the names of the fields need to fill in the sort dialogue box

• sort,filter, advanced

• column, sort on, Order

• Sort and Filter

• Conditional formatting

To arrange data in descending order ,which order need to select in the order field in the sort dialogue box

• A to Z(smallest to largest)

• Z to A(Largest to smallest)

• Custom level

• Asceding or descening

To arrange data in ascending order ,which order need to select in the order field in the sort dialogue box

• A to Z(smallest to largest)

• Z to A(Largest to smallest)

• Custom level

• Asceding or descening

In this diagram what does the selected area represent?

• a Row
• a Cell
• a Column
• a Chart

William wants to arrange the employee salaries in Column A of his spreadsheet from lowest to highest. What command should he use to complete this task?

• Sort
• Filter
• AutoFill
• Find & Replace

Dan only wants to view the employees in the Marketing department who earn a salary of more than £30,000. What command should he use to complete this task?

• Sort
• Filter
• Find & Replace
• AutoFill

Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?

• Find & Select
• Sort & Filter
• Organize
• Format Cell

Cooper is creating a spreadsheet for the school and wants to be able to put the spreadsheet in alphabetical order by last name. What should Cooper apply to the spreadsheet?

• Outline
• Collapse
• Sort
• Subtotal