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