Which of the following best describes the Auto Complete function?

(TCO 1) An Input Area (as it applies to Excel 2010) is defined as______. (Poin Show more Question 1.1. (TCO 1) An Input Area (as it applies to Excel 2010) is defined as______. (Points : 2) a range of cells containing results based on the output area displays the name of a worksheet within a workbook a range of cells containing values for variables used in formulas displays the content of the active cell Question 2.2. (TCO 1) In Excel 2010 a sheet tab ________. (Points : 2) displays the content of the active cell conceals the applicable formulas for the workbook identifies the address of the current cell displays the name of a worksheet within a workbook Question 3.3. (TCO 1) Which of the following best describes the Auto Complete function? (Points : 2) Adds all the numbers in the row automatically Searches for and displays any other similar label in the current column as you begin to type Adds all the numbers in the columns automatically Is a number that represents a quantity and can be the basis of calculations Question 4.4. (TCO 1) In Excel a Formula is _______. (Points : 2) a number that represents a date and can be the basis of calculations a combination of cell references operators values and/or functions used to perform calculations a number that represents a quantity and can be the basis of calculations should be used in each column of a workbook 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) Cannot complete a sequence of dates in a column Changes the background color of the selected cells to yellow Copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula Has two or more sub-commands related to the command Show less

QUICK QUOTE

Approximately 250 words