Spreadsheet Charts & Advanced Functions
3 years ago
flexdowell
Save
Edit
Host a game
Live GameLive
Homework
Solo Practice
Practice
11 QuestionsShow answers
  • Question 1
    30 seconds
    Q.   Which function will result in the total number of entries in the cell range B5 to B14?   
    answer choices
      Count 
     Max
      Min
      Sum
  • Question 2
    30 seconds
    Q.  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?  
    answer choices
     Months 
      Oil prices
      Stock names
      Stock prices
  • Question 3
    30 seconds
    Q.  Which chart type will best represent the percentage of examples for office supplies, salaries, and travel for a company’s budget?   
    answer choices
      Column
     Line
      Pie
    .  Scatter
  • Question 4
    30 seconds
    Q. Which function can an accounting department use in Cell A2 that will result in the current date?  
    answer choices
      Count
      Count A 
      Days360 
     Now
  • Question 5
    30 seconds
    Q. 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?  
    answer choices
       Column 
      Line
      Pie
     Scatter
  • Question 6
    30 seconds
    Q. Which chart will best represent a comparison of the average family income for the states, with emphasis on the states?    
    answer choices
      Column
      Line
      Pie
      Scatter
  • Question 7
    30 seconds
    Q.  Amanda has created multiple charts for each product sold. How will her manager know the name of each chart?  
    answer choices
      X-axis
      Y-axis 
      Legend
     Chart title
  • Question 8
    30 seconds
    Q. 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?   
    answer choices
      X-axis
     Y-axis
      Legend
     Chart title
  • Question 9
    30 seconds
    Q.  Which chart type BEST represents the thousands of hits on multiple websites due to advertising? 
    answer choices
     Column
      Line 
    Pie
     Scatter
  • Question 10
    30 seconds
    Q.  Which chart will BEST represent the percentage of expenses for travel, food, and entertainment, with emphasis on the entertainment expense?  
    answer choices
      Exploded pie 
     Line
     Pie 
      XY scatter
  • Question 11
    30 seconds
    Q.  What functions will produce results that indicate whether a student has passed or failed a course by entering the text “Pass” or “Fail”?  
    answer choices
     Count
      Count A
     If 
      Sum
Report Quiz
Join a game