Page 1
Question 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 cell is best described by which of the following? (Points : 2)
Must have formulas entered into it
Cannot be used for labels or headings
Must have text entered into it
Is the intersection of a column and a row
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) Why would you use cell references in formulas instead of constant
values? (Points : 2)
You can easily include letters, numbers, and spaces
It is easier to debug the errors
You can change the input values without changing the formulas
You can control the sequence in which Excel performs arithmetic operations
This study source was downloaded by 100000829216747 from CourseHero.com on 02-14-2022 01:36:02 GMT -06:00
https://www.coursehero.com/file/13923380/BIS-155-Week-1-Quiz/
, Question 5.5. (TCO 1) The fill handle in Excel 2010 _______. (Points : 2)
is the fastest way to type A1 in the name box
helps carry over the fill to the remaining slides
is the same action as pressing "Enter"
is a small black square at the bottom-right corner of a cell that facilitates fill operations
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
Question 6.6. (TCO 1) In Excel 2010, a column width ________. (Points : 2)
is adjustable so you can display more or less characters in a column
is not adjustable so keep the formulas as short as possible
always switches back to default
is best left unchanged unless you absolutely have to
Question 6.6. (TCO 1) Ribbon Commands with arrows indicate_____. (Points : 2)
a shortcut to cell A1
there are two or more sub-commands related to the command
the next step in the process
directionality
Question 7.7. Which of the following best describes a "Range" in Excel 2010? (Points : 2)
Cannot be selected with the mouse
Are the numbers that fall between the smallest and largest in the formula
Is another word for the active worksheet
Refers to a group of adjacent or contiguous cells
Question 7.7. (TCO 1) If you had worksheets that contained the inventory of each room in your house,
with a separate sheet for each room, all the sheets together would be a: (Points : 2)
workbook.
ledger.
document.
This study source was downloaded by 100000829216747 from CourseHero.com on 02-14-2022 01:36:02 GMT -06:00
https://www.coursehero.com/file/13923380/BIS-155-Week-1-Quiz/
Question 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 cell is best described by which of the following? (Points : 2)
Must have formulas entered into it
Cannot be used for labels or headings
Must have text entered into it
Is the intersection of a column and a row
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) Why would you use cell references in formulas instead of constant
values? (Points : 2)
You can easily include letters, numbers, and spaces
It is easier to debug the errors
You can change the input values without changing the formulas
You can control the sequence in which Excel performs arithmetic operations
This study source was downloaded by 100000829216747 from CourseHero.com on 02-14-2022 01:36:02 GMT -06:00
https://www.coursehero.com/file/13923380/BIS-155-Week-1-Quiz/
, Question 5.5. (TCO 1) The fill handle in Excel 2010 _______. (Points : 2)
is the fastest way to type A1 in the name box
helps carry over the fill to the remaining slides
is the same action as pressing "Enter"
is a small black square at the bottom-right corner of a cell that facilitates fill operations
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
Question 6.6. (TCO 1) In Excel 2010, a column width ________. (Points : 2)
is adjustable so you can display more or less characters in a column
is not adjustable so keep the formulas as short as possible
always switches back to default
is best left unchanged unless you absolutely have to
Question 6.6. (TCO 1) Ribbon Commands with arrows indicate_____. (Points : 2)
a shortcut to cell A1
there are two or more sub-commands related to the command
the next step in the process
directionality
Question 7.7. Which of the following best describes a "Range" in Excel 2010? (Points : 2)
Cannot be selected with the mouse
Are the numbers that fall between the smallest and largest in the formula
Is another word for the active worksheet
Refers to a group of adjacent or contiguous cells
Question 7.7. (TCO 1) If you had worksheets that contained the inventory of each room in your house,
with a separate sheet for each room, all the sheets together would be a: (Points : 2)
workbook.
ledger.
document.
This study source was downloaded by 100000829216747 from CourseHero.com on 02-14-2022 01:36:02 GMT -06:00
https://www.coursehero.com/file/13923380/BIS-155-Week-1-Quiz/
