Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Access Final Review 81-100
Test Description: Excel access final review 81-100
Instructions: Answer all questions to get your test result.
1) Which command on the Page Layout Ribbon enables a user to flip objects on a worksheet?
A
Arrange
B
Rotate
2) John wants to create a chart that shows trends of sales for 4 quarters. What type of chart should he create?
A
line chart
B
embedded chart
3) Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet?
A
screen shot
B
smart art
4) Which is the name of an interactive graphical representation of data that allows a user to change the groupings?
A
pivot chart
B
pivot table
5) Which command on the Insert Ribbon inserts a graphic from the Microsoft Office collection into a worksheet?
A
picture
B
clip art
6) What is a visual way to show how two variables relate to each other in a table?
A
trendline
B
data trend
7) What ribbon contains the commands for creating charts in Microsoft Excel?
A
page layout
B
insert
8) Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?
A
design
B
style
9) Which ribbon contains commands to add a comment about a selected cell in a worksheet?
A
insert
B
review
10) In a worksheet, which command suggests other words with a similar meaning that can be used?
A
thesaurus
B
research
11) What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook?
A
Protect Workbook
B
Protect Sheet
12) 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
Primary Sort
B
Ascending
13) 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
AutoFil
B
Filter
14) Trey would like to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text. Which formatting style should he select?
A
Conditional Formatting
B
Cell Style
15) 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
Custom Filter
B
Descending
16) What is the process of bringing data containing text fields separated by commas into Excel called?
A
Data collection
B
Importing data
17) What Home Ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style?
A
Styles
B
Editing
18) Amy would like to quickly create a form in layout view so that she can easily modify contents and formatting. Which option uses layout view and gives the user greater control over the form's appearance while displaying the data?
A
Form Wizard
B
Blank Form
19) Curt needs to finish a database project from yesterday. What action should he take in order to start working on the database?
A
Close
B
Open from Existing
20) Johnny has planned his baseball card database and determined a logical arrangement. What is his next step?
A
Gather the information
B
Discuss the database with users
*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?