CorporalFang3159
1. (TCO 1) An Output Area (as it applies to Excel 2016) is defined…
1. (TCO 1) An Output Area (as it applies to Excel 2016) is defined as _____.
Group of answer choices
a range of cells containing results based upon manipulation of the variables in the input area
displaying the name of a worksheet within a workbook
a range of cells containing values for variables used in formulas
displaying the content of the active cell
2. (TCO 1) Which of the following best describes a cell address?
Group of answer choices
Identifies the electronic “neighborhood” of a spreadsheet
Identifies a cell by a column letter and a row number
Searches for and displays similar labels as you type
Is a number that represents a quantity and can be the basis of calculations
3. (TCO 1) Which of the following best describes the AutoComplete function?
Group of answer choices
Adds all of 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 of the numbers in the columns automatically
Is a number that represents a quantity and can be the basis of calculations
4. (TCO 1) Why would you use cell references in formulas instead of constant values?
Group of answer choices
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.
5. (TCO 1) Which of the following describes the Auto Fill in Excel 2016?
Group of answer choices
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 fewer characters in a column
Helps carry over the fill to the remaining worksheets
6. (TCO 1) Ribbon Commands with arrows indicate _____.
Group of answer choices
a shortcut to cell A1
there are two or more subcommands related to the command
the next step in the process
directionality
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 of the sheets together would be a
Group of answer choices
workbook.
ledger.
document.
journal.
8. (TCO 1) Which of the following describes the horizontal Alignment in Excel 2016?
Group of answer choices
Refers to the up-down position of contents in a cell
Removes the vertical lines running through the data
Puts a line horizontally through the data
Refers to the left-right position of contents in a cell
9.(TCO 2) An absolute cell reference
Group of answer choices
causes a potential error.
indicates a cell’s specific location and the reference does not change when you copy the formula.
occurs when a formula directly or indirectly refers to the cell containing the formula.
contains both an absolute and a relative cell reference.
10. (TCO 2) In Excel, a function can be defined as a _____.
Group of answer choices
the predefined formula that performs a calculation
cell reference or a value
list of values and defined names as you enter data into a spreadsheet
set of rules that govern the structure and components of a formula