Excel Lesson 9 2019

Ryan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to known how many members are in the same first period class. Which feature would allow him to do this?

• Group

• Collapse

• Subtotal

• Outline

How can a table be quickly modified to meet user preferences?

• Right click on a style and choose modify

• Right click on a style and choose Duplicate

• Double click a style from the Table Quick Styles Gallery

• Choose Modify from the Styles Group on the Home Ribbon

Which ribbon includes the commands to apply a quick table style to a range of cells?

• Home

• Insert

• Page Layout

• Data

Jane 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

• Custom Filter

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

• Auto Fill

• Filter

• Find and Replace

• Sort

Jane has created a spreadsheet that displays sales of her employees. She would like to view only those employees with sales above $25, 000 who are from Region 3. What option will allow her to do that?

• Ascending

• Descending

• Filter

• Custom Filter

Which command on the Home Ribbon do you use to organize data ascending or descending order?

• Find & Select

• Format Cell

• Sort & Filter

• Organize

Conner is creating a spreadsheet for FBLA and wants to able to put the spreadsheet in alphabetical order by last name. What should Connor apply to the spreadsheet?

• Marco

• Sort

• Filter

• Formula

Dom 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?

• AutoFill

• Filter

• Find and Replace

• Sort

Which is a way to qualify data by specifying a matching condition or asking of the data?

• Insert

• Sort

• Query

• Probe