Excel Skills - 2

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

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

Mary wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should she use?

• COUNTIF
• AVERAGEIF
• SUMIF
• TOTALIF

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

All forumulas in Excel begin with the following symbol

• +
• =
• %
• /

Solid lines that mark off the rows and columns in a worksheet.

• Bold
• Merge
• Gridlines
• Underline

The column letter and row number that identify a cell, such as B3.

• Cell
• Active Cell
• Cell Reference 
• Row

How do you select a cell range?

• Click
• Hold
• Drag
• All of the above

Joan wants to see her sales representatives in numerical order with the sales person who sold the least at the top. Which sorting option should she choose?

• Ascending
• Descending
• Primary Sort
• Customer Filter