Week 2 Quiz\t\t\t(TCO 2)\u00a0An absolute cell reference: (Points : 2)\t\t\t(TCO 2)\u00a0Which of the following best describes a circular reference? (Points: 2)\t\t\t(TCO 2)\u00a0=$E2-G$4 contains examples of\u00a0_____ cell references. (Points: 2)\t\t\t(TCO 2)\u00a0In Excel, an Argument would be best described by which of the following statements? (Points: 2)\t\t\t(TCO 2)\u00a0The MEDIAN function would identify the ____. (Points: 2)\t\t\t(TCO 2)\u00a0The MAX function identifies the _____. (Points: 2)\t\t\t(TCO 2)\u00a0The NOW function would perform which of the following? (Points:2)\t\t\t(TCO 2)\u00a0The\u00a0_____ number is the number of the column in the lookup table that contains the return values.\u00a0(Points : 2)\t\t\t(TCO 2)\u00a0Arithmetic operations, cell references, and\u00a0____can be used in Excel formulas.\u00a0(Points : 2)\t\t\t(TCO 2)\u00a0To simplify entering ranges in formulas, you can use _____. (Points : 2)\t\t\t(TCO 7)\u00a0A\u00a0_____ helps to\u00a0ensure consistency and standardization for similar workbooks, such as detailed income statements for all 12 months in a year.\u00a0(Points : 2)\t\t\t(TCO 2)\u00a0When calculating a PMT function, the PV is best described by which of the following? (Points : 2)\t\t\t(TCO 7)\u00a0Before protecting a worksheet, you should\u00a0__ the cells that you want users to be able to edit.\u00a0(Points : 2)\t\t\t(TCO 7)\u00a0Which of the following file formats can store macros?\u00a0(Points : 2)\t\t\t(TCO 7)\u00a0By default, Excel automatically\u00a0_____ macros and displays a security warning when a file containing macros is opened.\u00a0(Points : 2)<\/p>\n","protected":false},"excerpt":{"rendered":"
Week 2 Quiz (TCO 2)\u00a0An absolute cell reference: (Points : 2) (TCO 2)\u00a0Which of the following best describes a circular reference? (Points: 2) (TCO 2)\u00a0=$E2-G$4 contains examples of\u00a0_____ cell references. (Points: 2) (TCO 2)\u00a0In Excel, an Argument would be best 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-202976","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/202976","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=202976"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/202976\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=202976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=202976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=202976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}