Have an account?
Skip to Content
Build your own quiz
11 questions
Show Answers
See Preview
- 1. Multiple ChoiceWhich function will result in the total number of entries in the cell range B5 to B14?CountMaxMinSum
- 2. Multiple ChoiceWhen creating a chart to analyze the effect of the oil prices on the cost of stocks, which data will appear on the x-axis?MonthsOil pricesStock namesStock prices
- 3. Multiple ChoiceWhich chart type will best represent the percentage of examples for office supplies, salaries, and travel for a company’s budget?ColumnLinePie. Scatter
- 4. Multiple ChoiceWhich function can an accounting department use in Cell A2 that will result in the current date?CountCount ADays360Now
- 5. Multiple ChoiceIf 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?ColumnLinePieScatter
- 6. Multiple ChoiceWhich chart will best represent a comparison of the average family income for the states, with emphasis on the states?ColumnLinePieScatter
- 7. Multiple ChoiceAmanda has created multiple charts for each product sold. How will her manager know the name of each chart?X-axisY-axisLegendChart title
- 8. Multiple ChoiceHal has used four different colors to show the different products that his company sells. What will Hal use to explain the different product colors?X-axisY-axisLegendChart title
- 9. Multiple ChoiceWhich chart type BEST represents the thousands of hits on multiple websites due to advertising?ColumnLinePieScatter
- 10. Multiple ChoiceWhich chart will BEST represent the percentage of expenses for travel, food, and entertainment, with emphasis on the entertainment expense?Exploded pieLinePieXY scatter
- 11. Multiple ChoiceWhat functions will produce results that indicate whether a student has passed or failed a course by entering the text “Pass” or “Fail”?CountCount AIfSum
- Answer choicesTagsAnswer choicesTags