(TCO 1) Which of the following describes the function of the Formula Bar (as it applies to Excel 2010)? (Points : 2)

$9.99
BIS 155 Data Analysis with Spreadsheets w/Lab Week 1 Quiz Answers (Excel Fundamentals and Charting)

 

  1. (TCO 1) Which of the following describes the function of the Formula Bar (as it applies to Excel 2010)? (Points : 2) 
  2. (TCO 1) Which of the following best describes a cell address? (Points : 2
  3. (TCO 1) If you wanted to insert the current date into an active cell, which of the following would you use? (Points : 2) 
  4. (TCO 1) In Excel a Formula is _______. (Points : 2)
  5. (TCO 1) Which of the following describes the Auto Fill in Excel 2010? (Points : 2)
  6. (TCO 1) Ribbon Commands with arrows indicate_____.
  7. (TCO 1) The three types of data that can be entered in a cell in an Excel worksheet are ________________.
  8. (TCO1) In Excel, a border ________.
  9. (TCO 3) A data series is a group of related ____________
  10. (TCO 3) A __________ is usually the most effective way to display proportional relationships, such as market share data, where the individual data values represent parts of a whole. (Points : 2)
  11. (TCO 3) When creating a chart in Excel, a single data series _____.
  12. . (TCO 3) To display similar data in a single column, with each series of data distinguished by a different color, use a:
  13. (TCO 3) To provide your viewers with an explanation of the representations of the colors utilized in the data series in your chart, provide a:
  14. (TCO 3) Which of the following best describes the X Y (scatter) chart?
  15. (TCO 3) Which of the following best describes a trendline?