# DEVRY BIS155/BIS 155 WEEK 2 QUIZ (PERFECT ANSWER) - 89119

Solution Posted by ## anjis_devis

Rating : (21)B
Solution Detail
Price: \$12.00
• Posted on: Wed 18 Mar, 2015
• Request id: None
• Purchased: 0 time(s)
• Average Rating: No rating
Request Description
Question 1.1.(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 2.2.(TCO 2) In Excel, a function can be defined as a _____.(Points : 2) 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 for a formula Question 3.3.(TCO 2) =\$E2-G\$4 contains examples of _____ cell references.(Points : 2) Absolute Mixed Relative Constant Question 4.4.(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 5.5.(TCO 2) The MEDIAN function would identify the ____.(Points : 2) lowest value in a range. midpoint value in a range. highest value in a range. total number of cells in a range. Question 6.6.(TCO 2) Which of the following best describes the COUNT function?(Points : 2) Tallies the number of cells in a range that are not empty. Tallies the number of blank cells in a range. Displays the current date. Tallies the number of cells in a range that contain values. Question 7.7.(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. Question 8.8.(TCO 2) A(n) _____ is tested in an IF function to determine if it is true or false.(Points : 2) feature formula condition option Question 9.9.(TCO 2) Arithmetic operations, cell references, and _____ can be used in Excel formulas.(Points : 2) constants macros programs procedures Question 10.10.(TCO 2) To simplify entering ranges in formulas, you can use _____.(Points : 2) range names a cell's relative location both an absolute and a relative cell reference a cell's specific location Question 11.11.(TCO 2) When calculating a PMT function, the RATE would be described best by which of the following?(Points : 2) It is the periodic interest rate, such as a monthly interest rate It is the total number of payment periods. It is a word or a string of characters that represent one or more cells. It is the present value of the loan. Question 12.12.(TCO 7) A _____ helps to ensure consistency and standardization for similar workbooks, such as detailed income statements for all 12 months in a year.(Points : 2) template macro web query function Question 13.13.(TCO 7) To unlock cells, click the _____ tab, then click Format in the Cells group and select Lock Cell.(Points : 2) home page layout data view Question 14.14.(TCO 7) Which of the following file formats can store macros?(Points : 2) xlsm csv xml xlsx Question 15.15.(TCO 7) By default, Excel automatically _____ macros and displays a security warning when a file containing macros is opened.(Points : 2) saves deletes runs disables
Solution Description

Question 1.1.(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 2.2.(TCO 2) In Excel, a function can be defined as a _____.(Points : 2)

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 for a formula
Question 3.3.(TCO 2) =\$E2-G\$4 contains exa

Attachments  ### Computer Science ### Mathematics ### Applied Science ### Humanities Tutor 