Bsbwor501 Final Exam
1. (TCO 1) Which of the following describes the function of the Formula Bar (as it applies to Excel 2010)?
Answer: Displays the content of the active cell
2. Question : (TCO 1) In Excel 2010, a sheet tab ________.
Answer: displays the name of a worksheet within a workbook 3. Question : (TCO 1) If you wanted to insert the current date into an active cell, which of the following would you use?
Answer: The Ctrl and semicolon key combination 4. Question : (TCO 1) Why would you use cell references in formulas instead of constant values?
Answer: You can change the input values without changing the formulas 5. …show more content…
Question : (TCO 1) Which of the following best describes the result of using the fill handle on a cell containing a formula?
Answer: Copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula
6. Question : (TCO 1) Ribbon Commands with arrows indicate_____.
Answer: there are two or more sub-commands related to the command
7. Question : (TCO 1) The three types of data that can be entered in a cell in an Excel worksheet are ________________.
Answer: text, values, and formulas
8. Question : (TCO 1) When you paste copied data, Excel displays the Paste Options button:
Answer: in the bottom right corner of the pasted data. 9. Question : (TCO 3) Groups of related numeric values in an Excel worksheet are:
Answer: data series 10. Question : (TCO 3) Which of the following best describes a column
chart?
Answer: Displays data comparisons vertically in columns 11. Question : (TCO 3) Which of the following best describes the chart area?
Answer: Contains the entire chart and all of its elements
12. Question : (TCO 3) Stock market or economic trends over long periods of time are frequently shown on a _________.
Answer: line chart 13. Question : (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:
Answer: legend. 14. Question : (TCO 3) In Excel, an area chart _______.
Answer: emhasizes the magnitude of changes over time by filling in the space between lines with a color 15. Question : (TCO 3) After creating a chart, you can change the chart type by using _____.
Answer: Displays the content of the active cell
2. Question : (TCO 1) In Excel 2010, a sheet tab ________.
Answer: displays the name of a worksheet within a workbook 3. Question : (TCO 1) If you wanted to insert the current date into an active cell, which of the following would you use?
Answer: The Ctrl and semicolon key combination 4. Question : (TCO 1) Why would you use cell references in formulas instead of constant values?
Answer: You can change the input values without changing the formulas 5. …show more content…
Question : (TCO 1) Which of the following best describes the result of using the fill handle on a cell containing a formula?
Answer: Copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula
6. Question : (TCO 1) Ribbon Commands with arrows indicate_____.
Answer: there are two or more sub-commands related to the command
7. Question : (TCO 1) The three types of data that can be entered in a cell in an Excel worksheet are ________________.
Answer: text, values, and formulas
8. Question : (TCO 1) When you paste copied data, Excel displays the Paste Options button:
Answer: in the bottom right corner of the pasted data. 9. Question : (TCO 3) Groups of related numeric values in an Excel worksheet are:
Answer: data series 10. Question : (TCO 3) Which of the following best describes a column
chart?
Answer: Displays data comparisons vertically in columns 11. Question : (TCO 3) Which of the following best describes the chart area?
Answer: Contains the entire chart and all of its elements
12. Question : (TCO 3) Stock market or economic trends over long periods of time are frequently shown on a _________.
Answer: line chart 13. Question : (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:
Answer: legend. 14. Question : (TCO 3) In Excel, an area chart _______.
Answer: emhasizes the magnitude of changes over time by filling in the space between lines with a color 15. Question : (TCO 3) After creating a chart, you can change the chart type by using _____.