Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Access Finals 61-80
Test Description: Excel access finals 61-80
Instructions: Answer all questions to get your test result.
1) Which command on the Insert Ribbon enables a user to insert a picture of a part of a screen into a worksheet?
A
Screenshot
B
Screen Clipping
2) On a PivotTable, what is a field with values not entered as data but determined by a computation involving data in other fields called?
A
Total field
B
Calculated field
3) Which is a tiny chart that provides a visual representation of data in a worksheet cell?
A
Sparkline
B
data line
4) Dorothy designed a column chart and would like to add an element that will help lead the eye and improve readability of the chart. Which chart feature should she include?
A
Gridlines
B
Axis Title
5) John has created a Pivot chart and would like to include a guide that would display the names of the series of data included on the chart. Which option would allow him to do this?
A
Values
B
Legend Fields
6) Which command creates decorative text in a worksheet?
A
artwork
B
wordart
7) Edward would like to create a chart that shows the trend in iPod sales over the past 2 years. Which chart type should he create?
A
line
B
column
8) What ribbon contains the commands used to create a chart in Excel?
A
formula ribbon
B
insert ribbon
9) . What is the process of viewing a PivotTable report for a subset that meets the criterion only?
A
filtering
B
arranging
10) What term refers to an Excel Chart with offset pieces?
A
exploded
B
separated
11) What graphically represents trends in plotted data and predicts future values?
A
chartline
B
trendline
12) What is typically included in the range of data selected to create a chart?
A
Numeric data and titles
B
title only
13) Leigh Ann designed a bar chart and would like to add an element above the chart to make the data more meaningful. Which chart feature would she need to include?
A
chart title
B
data label
14) Which of the following is the default method for summarizing data in a PivotTable?
A
PivotChart
B
PivotTable
15) Which tab in the PivotChart Tools Ribbon allows a user to apply chart titles to the PivotChart?
A
layout
B
format
16) What can you use to easily filter pivot tables and cube functions interactively in a worksheet?
A
slicer
B
division
17) Which ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable?
A
layout
B
design
18) Dorothy designed a column chart and would like to change the background color to yellow. Which chart feature should she modify?
A
plot area
B
chart titles
19) What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts?
A
movers
B
slicers
*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?