Spreadsheet Charts & Advanced Functions

  Which function will result in the total number of entries in the cell range B5 to B14?   

•   Count 
•  Max
•   Min
•   Sum

 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?  

•  Months 
•   Oil prices
•   Stock names
•   Stock prices

 Which chart type will best represent the percentage of examples for office supplies, salaries, and travel for a company’s budget?   

•   Column
•  Line
•   Pie
• .  Scatter

Which function can an accounting department use in Cell A2 that will result in the current date?  

•   Count
•   Count A 
•   Days360 
•  Now

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?  

•    Column 
•   Line
•   Pie
•  Scatter

Which chart will best represent a comparison of the average family income for the states, with emphasis on the states?    

•   Column
•   Line
•   Pie
•   Scatter

 Amanda has created multiple charts for each product sold. How will her manager know the name of each chart?  

•   X-axis
•   Y-axis 
•   Legend
•  Chart title

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?   

•   X-axis
•  Y-axis
•   Legend
•  Chart title

 Which chart type BEST represents the thousands of hits on multiple websites due to advertising? 

•  Column
•   Line 
• Pie
•  Scatter

 Which chart will BEST represent the percentage of expenses for travel, food, and entertainment, with emphasis on the entertainment expense?  

•   Exploded pie 
•  Line
•  Pie 
•   XY scatter