Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Spreadsheet Charts And Advanced Features
Test Description: CSA II Spreadsheet Chart Review
Instructions: Answer all questions to get your test result.
1) Which function will result in the total number of entries in the cell range B5 to B14?
A
Min
B
Count
C
Sum
D
Max
2) 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
Oil Prices
D
Months
3) Which chart type will best represent the percentage of expenses for office supplies, salaries, and travel for a company's total budget?
A
Column
B
Line
C
Scatter
D
Pie
4) Which function can an accounting department use in Cell A2 that will result in the current date?
A
Count A
B
Days360
C
Count
D
Now
5) 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 use?
A
Column
B
Scatter
C
Line
D
Pie
6) Which chart will best represent a comparison of the average family income for three states, with emphasis on the states?
A
Column
B
Pie
C
Scatter
D
Line
7) Amanda has created multiple charts for each product sold. How will her manager know the name of each chart?
A
Legend
B
Chart Title
C
Y Axis
D
X Axis
8) Hal has used four different colors to show the different products that his company sells. What will Hal use to explain the different product colors?
A
X Axis
B
Y Axis
C
Legend
D
Chart Title
9) Which chart type BEST represents the thousands of hits on multiple websites due to advertising?
A
Column
B
Pie
C
Scatter
D
Line
10) Which chart will BEST represent the percentage of expenses for travel, food, and entertainment, with emphasis on the entertainment expense?
A
Pie
B
XY Scatter
C
Line
D
Exploded Pie
11) What function will produce results that indicate whether a student has passed or failed a course by entering the text 'Pass' or 'Fail'
A
If
B
Count
C
Sum
D
Count A
*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?