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