Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
MS Excel Honors #11
Test Description: Review
Instructions: Answer all questions to get your test result.
1) Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select?
A
Format as Table
B
Fill Color
C
Conditional Formatting
D
Cell Style
2) Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?
A
Format Cells
B
Sort and Filter
C
Organize
D
Find and Select
3) How can a table style be quickly modified to meet user preferences?
A
Double-click a style from the Table Quick Styles Gallery
B
Choose Modify from the Styles Group on the Home Ribbon
C
Right-click on a style and choose Modify
D
Right-click on a style and choose Duplicate
4) What is the process of bringing data containing text fields separated by commas into Excel called?
A
Importing data
B
Data collection
C
Data integration
D
Data migration
5) Which command on the Home Ribbon do you use to organize data in ascending or descending order?
A
Organize
B
Format Cells
C
Find and Select
D
Sort and Filter
6) Which is a way to qualify data by specifying a matching condition or asking a question of the data?
A
Probe
B
Query
C
Insert
D
Sort
7) What Home Ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style?
A
Font
B
Styles
C
Editing
D
Alignment
8) Which ribbon includes the commands to apply a quick table style to a range of cells?
A
Data
B
Page Layout
C
Home
D
Insert
9) 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?
A
AutoFill
B
Sort
C
Filter
D
Find and Replace
10) 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?
A
Sort
B
Filter
C
AutoFill
D
Find and Replace
11) 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?
A
Custom Filter
B
Primary Sort
C
Descending
D
Ascending
12) 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?
A
Descending
B
Filter
C
Ascending
D
Custom Filter
13) 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?
A
Group
B
Collapse
C
Outline
D
Subtotal
14) 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?
A
Group
B
Subtotal
C
Collapse
D
Outlinejavascript://
15) 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?
A
Formula
B
Macro
C
Filter
D
Sort
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?