Weekly Quiz

Only available on StudyMode
  • Download(s) : 2112
  • Published : June 10, 2012
Open Document
Text Preview
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 chart?

Answer: Displays data comparisons vertically in columns
11.Question :(TCO 3) Which of the following best describes...
tracking img