Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Advanced
Test Description: Excel Advanced Study
Instructions: Answer all questions to get your test result.
1) John has used four different colors to show the different products his company sells. How will John show which color is used with which product?
A
y axis
B
Legend
C
Chart
D
X axis
2) John has created multiple charts for each product sold. How will his manager know the name of each chart?
A
X axis
B
Y axis
C
Chart Title
D
Legend
3) Which chart will best present a comparison of the average family income for three states, with emphasis on the states?
A
Column
B
Line
C
Pie
D
Scatter
4) If Jake wants to study the relationship between the daily temperature and the amount of fruit sold during a week, what kind of chart should he used?
A
Line
B
Scatter
C
Pie
D
Column
5) Which chart will BEST represent the percentage of expenses for travel, food, and entertainment, with emphasis on the entertainment expense?
A
XY Scatter
B
Pie
C
Exploded Pie
D
Line
6) Which chart type BEST represents the thousands of hits on multiple websites due to advertising?
A
Scatter
B
Pie
C
Exploded Pie
D
Line
7) Which function can an accounting department use in Cell A2 that will result in the current date?
A
Day360
B
Count
C
Now
D
Count A
8) Which function will result in the total number of entries in the cell range B5 to B14?
A
Now
B
Count
C
Day360
D
Count A
9) When creating a chart to analyze the effect of oil prices on the cost of stocks, which data will appear on the x-axis?
A
Stock Prices
B
Stock Names
C
Months
D
Oil Prices
10) Which chart type will best represent the percentage of expenses for office supplies, salaries, and travel for a company's total budget?
A
Scatter
B
Pie
C
Column
D
Line
*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?