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
Count
B
Sum
C
Min
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
Months
C
Stock Names
D
Oil 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
Scatter
B
Line
C
Column
D
Pie
4) Which function can an accounting department use in Cell A2 that will result in the current date?
A
Count
B
Days360
C
Now
D
Count A
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
Line
B
Column
C
Scatter
D
Pie
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
Legend
B
X Axis
C
Chart Title
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
Chart Title
C
Legend
D
X Axis
9) Which chart type BEST represents the thousands of hits on multiple websites due to advertising?
A
Column
B
Scatter
C
Pie
D
Line
10) Which chart will BEST represent the percentage of expenses for travel, food, and entertainment, with emphasis on the entertainment expense?
A
Line
B
Exploded Pie
C
Pie
D
XY Scatter
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
Sum
C
Count
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?