# Devry Bis 155 Week 2 Quiz - Updated

1018 Words5 Pages
DeVry BIS 155 Week 2 Quiz - Updated IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.acehomework.net/?download=devry-bis-155-week-2-quiz-updated IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM DeVry BIS 155 Week 2 Quiz Quiz Question 1.1. (TCO 2) In Excel, a relative cell reference: (Points : 2) indicates a cell's specific location and the reference does not change when you copy the formula. contains both an absolute and a relative cell reference. indicates a cell's relative location from the cell containing the formula; the reference changes when you copy the formula. occurs when a formula directly or indirectly refers to the cell…show more content…
(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) The _____ number is the number of the column in the lookup table that contains the return values. (Points : 2) lookup value column index lookup table random Question 9.9. (TCO 2) To copy a formula, you may use the _____, which is found in the bottom right-hand corner of an active cell. (Points : 2) sizing handle pointer fill handle insertion point Question 10.10. (TCO 2) One benefit of using range names in formulas is that _____ . (Points : 2) it directly or indirectly refers to the cell containing the formula it contains both an absolute and a relative cell reference it identifies the present value of the loan if you copy the formula, you do