# Devry BIS 155 Week 1 Quiz

(TCO 1) An Output Area (as it applies to Excel 2016) is defined as _____. **(Points : 2)**

- 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

**Question 2. 2.** (TCO 1) Which of the following best describes a cell address? **(Points : 2)**

- 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

**Question 3. 3.** (TCO 1) Which of the following best describes the active cell? **(Points : 2)**

- Is where all of the functions of the database perform the calculations
- Is the cell that always holds the current date
- Is the location of the insertion point as indicated by a dark border
- Is where all of the formulas of the workbook do the math

**Question 4. 4.** (TCO 1) In Excel a formula _____. **(Points : 2)**

- is a number that represents a date and can be the basis of calculations
- is a combination of cell references, operators, values, and/or functions used to perform calculations
- is 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 2016? **(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 fewer 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 to cell A1
- there are two or more subcommands related to the command
- the next step in the process
- directionality

**Question 7. 7.** (TCO 1) The three types of data that can be entered in a cell in an Excel worksheet are _____. **(Points : 2)**

- columns, rows, and fields
- numbers, fonts, and styles
- functions, comments, and macros
- text, values, and formulas

**Question 8. 8.** (TCO 1) When you paste copied data, Excel displays the Paste Options button _____. **(Points : 2)**

- in the status bar at the left of the screen.
- in the next set of nonadjacent ranges.
- on the toolbar.
- in the bottom right corner of the pasted data.

**Question 9. 9.** (TCO 2) An absolute cell reference **(Points : 2)**

- 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.

**Question 10. 10.** (TCO 2) Which of the following function keys toggles through relative, absolute, and mixed references? **(Points : 2)**

- There is no way to toggle through the various types of references.
- F8
- F4
- B4

**Question 11. 11.** (TCO 2) =$E2-G$4 contains examples of _____ cell references. **(Points : 2)**

- absolute
- mixed
- relative
- constant

**Question 12. 12.** (TCO 2) Which of the following describes the SUM function? **(Points : 2)**

- Identifies the midpoint value in a set of values
- Calculates the total of values contained in two or more cells
- Calculates the arithmetic mean or average of values in a range
- Displays the lowest value in a range

**Question 13. 13.** (TCO 2) Which of the following describes the AVERAGE function? **(Points : 2)**

- Calculates the arithmetic mean of values in a range
- Identifies the midpoint value in a set of values
- Identifies the highest value in a range
- Displays the lowest value in a range

**Question 14. 14.** (TCO 2) The MIN function would identify the _____. **(Points : 2)**

- highest value in a range
- tallies of the number of blank cells in a range
- lowest value in a range
- midpoint value in a range

**Question 15. 15.** (TCO 2) The NOW function would perform which of the following? **(Points : 2)**

- Contains another function embedded inside one or more of its arguments
- Evaluates a condition and returns one value if the condition is true and a different value if the condition is false
- Evaluates true or false
- Displays the current date and time