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.
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