BIS115_Quizzes
WEEK 1
1. (TCO 1) An Output Area (as it applies to Excel 2010) is defined as_______. (Points : 2) a range of cells containing results based upon manipulation of the variables in the input 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 AutoComplete 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 describes the Auto Fill in Excel 2010? (Points : 2) Enables you to copy the contents of a cell or to continue a sequence by dragging the fill handle Is the fastest way to type A1 in the name box Is adjustable so you can display more or less characters in a column Helps carry over the fill to the remaining worksheets Question 6. 6. (TCO 1) Ribbon Commands with arrows indicate_____. (Points : 2) a shortcut
1. (TCO 1) An Output Area (as it applies to Excel 2010) is defined as_______. (Points : 2) a range of cells containing results based upon manipulation of the variables in the input 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 AutoComplete 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 describes the Auto Fill in Excel 2010? (Points : 2) Enables you to copy the contents of a cell or to continue a sequence by dragging the fill handle Is the fastest way to type A1 in the name box Is adjustable so you can display more or less characters in a column Helps carry over the fill to the remaining worksheets Question 6. 6. (TCO 1) Ribbon Commands with arrows indicate_____. (Points : 2) a shortcut