NEW
Font size
S
M
L
XL
WorksheetsSpreadsheet Charts & Advanced Functions
Total questions: 11
Worksheet time: 6mins
Name
Class
Date
1.
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
2.
When creating a chart to analyze the effect of the 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
3.
Which chart type will best represent the percentage of examples for office supplies, salaries, and travel for a company’s budget?
a)
Column
b)
Line
c)
Pie
d)
. Scatter
4.
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
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)
Line
c)
Pie
d)
Scatter
6.
Which chart will best represent a comparison of the average family income for the states, with emphasis on the states?
a)
Column
b)
Line
c)
Pie
d)
Scatter
7.
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
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)
Line
c)
Pie
d)
Scatter
10.
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
11.
What functions 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
Reset
