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
Sum
C
Max
D
Count
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 Names
B
Months
C
Oil Prices
D
Stock Prices
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
Pie
C
Scatter
D
Line
4) Which function can an accounting department use in Cell A2 that will result in the current date?
A
Count A
B
Count
C
Now
D
Days360
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
Pie
B
Scatter
C
Column
D
Line
6) Which chart will best represent a comparison of the average family income for three states, with emphasis on the states?
A
Pie
B
Line
C
Scatter
D
Column
7) Amanda has created multiple charts for each product sold. How will her manager know the name of each chart?
A
Chart Title
B
Legend
C
X Axis
D
Y 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
Y Axis
B
Legend
C
Chart Title
D
X Axis
9) Which chart type BEST represents the thousands of hits on multiple websites due to advertising?
A
Pie
B
Scatter
C
Line
D
Column
10) 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
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
Count
B
Sum
C
Count A
D
If
*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?