{"id":202951,"date":"2018-09-13T23:16:01","date_gmt":"2018-09-13T23:16:01","guid":{"rendered":"http:\/\/localhost\/wordpress\/index.php\/2018\/09\/13\/bis-155-week-5-quiz-consolidating-data-and-what-if-analysis\/"},"modified":"2018-10-24T08:45:29","modified_gmt":"2018-10-24T08:45:29","slug":"bis-155-week-5-quiz-consolidating-data-and-what-if-analysis","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/bis-155-week-5-quiz-consolidating-data-and-what-if-analysis\/","title":{"rendered":"BIS 155 Week 5 Quiz (Consolidating Data and What-If Analysis)"},"content":{"rendered":"<p>Week 5 Quiz\t\t\t(TCO 5) When multiple worksheets are selected, the word ________ appears in the title bar. (Points : 2)\t\t\t(TCO 5) In Excel, which of the following would you perform to group adjacent worksheets? (Points : 2)\t\t\t(TCO 5) When two windows of the same workbook are opened, Excel adds ________ to the&#8230;. (Points:2)\t\t\t(TCO 5) After saving the arrangement of windows, a workbook can be opened by opening __file. (Points:2)\t\t\t(TCO 5) Which of the following functions do NOT work with 3D formulas? (Points : 2)\t\t\t(TCO 5) Excel&#8217;s ability to manage worksheets allows you to do all EXCEPT: (Points : 2)\t\t\t(TCO 5) If A1 contains the hourly pay rate of $10.25, A2 contains the hours worked (40), and A3 contains =A1*A2, which cell is the dependent cell(s)? (Points : 2)\t\t\t(TCO 6) In a what-if analysis of a car purchase, the original interest rates of 6% and 5%, 5.5% and 6.5% are the ________ values. (Points : 2)\t\t\t(TCO 6) Which What-If Analysis tool would be best at comparing the combined effects of&#8230;..? (Points : 2)\t\t\t(TCO 6) After entering the substitution values and the reference to a formula, the next step to complete a two-variable data table and view the results is to: (Points : 2)\t\t\t(TCO 6) The Goal Seek command is located in the ________ command on the Data tab. (Points : 2)\t\t\t(TCO 6) Which of the following is NOT in the What-If Analysis command in the Data Tools&#8230;..? (Points:2)\t\t\t(TCO 6) Which of the following is NOT one of the three parameters in Solver? (Points : 2)\t\t\t(TCO 6) Which of the following is NOT required for Solver to generate a solution? (Points : 2)\t\t\t(TCO 6) The initial results of a Goal Seek are: (Points : 2)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Week 5 Quiz (TCO 5) When multiple worksheets are selected, the word ________ appears in the title bar. (Points : 2) (TCO 5) In Excel, which of the following would you perform to group adjacent worksheets? (Points : 2) (TCO <a href=\"https:\/\/www.benedictsol.com\/blogs\/bis-155-week-5-quiz-consolidating-data-and-what-if-analysis\/\" class=\"read-more\">Read More &#8230;<\/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-202951","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/202951","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=202951"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/202951\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=202951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=202951"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=202951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}