### CSA II Spreadsheet Chart Review. Answers? Play games to get them!

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) Count A
c) If
d) Sum

Which chart type BEST represents the thousands of hits on multiple websites due to advertising?
a) Column
b) Line
c) Pie
d) Scatter

Which chart will BEST represent the percentage of expenses for travel, food, and entertainment, with emphasis on the entertainment expense?
a) Exploded Pie
b) Line
c) Pie
d) XY Scatter

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

Which chart will best represent a comparison of the average family income for three states, with emphasis on the states?
a) Column
b) Line
c) Pie
d) Scatter

Amanda has created multiple charts for each product sold. How will her manager know the name of each chart?
a) X Axis
b) Y Axis
c) Legend
d) Chart Title

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) Line
c) Pie
d) Scatter

Which function can an accounting department use in Cell A2 that will result in the current date?
a) Count
b) Count A
c) Days360
d) Now

Which function will result in the total number of entries in the cell range B5 to B14?
a) Count
b) Max
c) Min
d) Sum

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) Months
b) Oil Prices
c) Stock Names
d) Stock Prices

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) Pie
d) Scatter

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 22279 in the upper right hand corner or click here.

TEACHERS / EDUCATORS