Excel Lesson 9
Quiz by Lisa DeCastillia
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
7 questions
Show answers
- Q1Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?Sort & FilterOrganizeFormat CellFind & Select45s
- Q2Cooper 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?MacroFilterSortFormula45s
- Q3Joan 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?Custom FilterFilterDescendingAscending45s
- Q4Dylan 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?SubtotalOutlineCollapseGroup45s
- Q5Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select?Conditional FormattingFill ColorFormat as TableCell Style45s
- Q6David 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?FilterSortFind and ReplaceAutoFill45s
- Q7What Home Ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style?EditingStylesAlignmentFont45s