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

Wait.... Hire Me To Get 100% Original Help In . With No Upfront Fees. Watch The Video Below For More Information & How It Works!

Play Video

Name: Jennifer Lucas
Status: Online ⬤
Classes Taken: 3878
Ratings: ⭐⭐⭐⭐⭐

Hire Me

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