Microsoft Excel 1.09

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

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?

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

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?

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

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?

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

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?

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