Question Details

Question 1.1. (TCO 1) An Output Area (as it applies to Excel 2010) is defined as_______. (Points : 2)

Question 2.2. (TCO 1) In Excel 2010, a cell is best described by which of the following? (Points : 2)

Question 3.3. (TCO 1) Which of the following best describes the AutoComplete function? (Points : 2)

Question 4.4. (TCO 1) Why would you use cell references in formulas instead of constant values? (Points : 2)

Question 5.5. (TCO 1) The fill handle in Excel 2010 _______. (Points : 2)

Question 5.5. (TCO 1) Which of the following best describes the result of using the fill handle on a cell containing a formula? (Points : 2)

Question 6.6. (TCO 1) In Excel 2010, a column width ________. (Points : 2)

Question 6.6. (TCO 1) Ribbon Commands with arrows indicate_____. (Points : 2)

Question 7.7. Which of the following best describes a "Range" in Excel 2010? (Points : 2)

Question 7.7. (TCO 1) If you had worksheets that contained the inventory of each room in your house, with a separate sheet for each room, all the sheets together would be a: (Points : 2)

Question 8.8. (TCO 1) Which of the following describes the horizontal Alignment in Excel 2010? (Points : 2)

Question 9.9. (TCO 3) A data series is a group of related ____________. (Points : 2)

Question 10.10. (TCO 3) Which of the following best describes a column chart? (Points : 2)

Question 11.11. (TCO 3) When creating a chart in Excel, a single data series _____. (Points : 2)

Question 12.12. (TCO 3) Stock market or economic trends over long periods of time are frequently shown on a _________. (Points : 2)

Question 12.12. (TCO 3) When creating a chart in Excel, a multiple data series _______. (Points : 2)

Question 13.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: (Points : 2)

Question 13.13. (TCO 3) A pie chart with one or more slices separated for emphasis is called a(n) ____________ pie chart. (Points : 2)

Question 14.14. (TCO 3) Which of the following best describes the X Y (scatter) chart? (Points : 2)

Question 14.14. (TCO 3) When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs: (Points : 2)

Question 15.15. (TCO 3) After creating a chart, you can change the chart type by using _____. (Points : 2)

Question 15.15. (TCO 3) Which of the following best describes a sparkline? (Points : 2)

(TCO 1) Which of the following best describes a cell address?

(TCO 1) Which of the following best describes the order of precedence as it applies to math operations in Excel?

(TCO 1) When you paste copied data, Excel displays the Paste Options button:

(TCO 3) Groups of related numeric values in an Excel worksheet are:

(TCO 3) Which of the following best describes the chart area?

(TCO 3) To display similar data in a single column, with each series of data distinguished by a different color, use a:

(TCO 3) In Excel, an area chart _______

(TCO 3) After creating a chart, you can change the chart type by using _____