MS Excel Honors #11

Match it! Select the correct answer from the pull down...Good luck!

What Home Ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style?

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

Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to show a summary view of all of the first period classes. Which feature would allow him to do this?

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

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

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

What is the process of bringing data containing text fields separated by commas into Excel called?

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?