Question 1. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 2) In Excel, a relative cell reference\tindicates a cell’s specific location and the reference does not change when you copy the formula.\tcontains both an absolute and a relative cell reference.\tindicates a cell’s relative location from the cell containing the formula; the reference changes when you copy the formula.\toccurs when a formula directly or indirectly refers to the cell containing the formula.\t\u00a0\tQuestion 2. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 2) Which of the following best describes a mixed cell reference?\tOccurs when a formula directly or indirectly refers to the cell containing the formula\tCauses a potential error\tContains absolute or relative cell references, but not both\t\u00a0Contains both an absolute and a relative cell reference\t\u00a0\tQuestion 3. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 2) You have a cell that contains the formula =A1*2. When you copy this formula to other cells, you want it to always reference column A, but you want the row number to change automatically. You should make the A1 in this formula a(n) _____ cell reference.\tabstract\trelative\t\u00a0mixed\tabsolute\t\u00a0\tQuestion 4. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 2) In Excel, an argument would be best described by which of the following statements?\tCalculates the total of values contained in two or more cells\t\u00a0Is an input, such as a cell reference or a value needed to complete a function\tIs a small pop-up description that displays the results of the cell\t\u00a0\tQuestion 5. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 2) Which of the following describes the AVERAGE function?\t\u00a0Calculates the arithmetic mean of values in a range\tIdentifies the midpoint value in a set of values\tIdentifies the highest value in a range\tDisplays the lowest value in a range\t\u00a0\tQuestion 6. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 2) The MIN function would identify the _____.\thighest value in a range\tTallies of the number of blank cells in a range\tlowest value in a range\tmidpoint value in a range\t\u00a0\tQuestion 7. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 2) The NOW function would perform which of the following?\tContains another function embedded inside one or more of its arguments\tEvaluates a condition and returns one value if the condition is true and a different value if the condition is false\tEvaluates true or false\t\u00a0Displays the current date and time\t\u00a0\tQuestion 8. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 2) The _____ number is the number of the column in the lookup table that contains the return values.\t\u00a0lookup value\t\u00a0column index\tlookup table\trandom\t\u00a0\tQuestion 9. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 2) Arithmetic operations, cell references, and _____ can be used in Excel formulas.\t\u00a0constants\tmacros\tprograms\tprocedures\t\u00a0\tQuestion 10.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 2) To simplify entering ranges in formulas, you can use _____.\t\u00a0range names\ta cell’s relative location\tboth an absolute and a relative cell reference\ta cell’s specific location\t\u00a0\tQuestion 11.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 2) When calculating a PMT function, the RATE would be described best by which of the following?\t\u00a0It is the periodic interest rate, such as a monthly interest rate.\tIt is the total number of payment periods.\tIt is a word or a string of characters that represent one or more cells.\tIt is the present value of the loan.\t\u00a0\tQuestion 12.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 7) A _____ helps to ensure consistency and standardization for similar workbooks, such as detailed income statements for all 12 months in a year.\t\u00a0template\tmacro\tweb query\tfunction\t\u00a0\tQuestion 13.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 7) To unlock cells, click the _____ tab, then click Format in the Cells group and select Lock Cell.\t\u00a0home\tpage layout\tdata\tview\t\u00a0\tQuestion 14.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 7) You must _____ the recording of the macro when you have completed the tasks it was designed to do.\tbegin\tstop\tcopy\tpaste\t\u00a0\tQuestion 15.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 7) To create a macro button, click the _____ tab, click Insert, then click Button in the Form Controls section of the Insert palette.\tView\tData\tInsert\tDeveloper<\/p>\n","protected":false},"excerpt":{"rendered":"
Question 1. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 2) In Excel, a relative cell reference 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 Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-202971","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/202971","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=202971"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/202971\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=202971"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=202971"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=202971"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}