{"id":202949,"date":"2018-09-13T23:15:57","date_gmt":"2018-09-13T23:15:57","guid":{"rendered":"http:\/\/localhost\/wordpress\/index.php\/2018\/09\/13\/bis-155-week-3-quiz-data-analysis-functions\/"},"modified":"2018-10-24T09:13:13","modified_gmt":"2018-10-24T09:13:13","slug":"bis-155-week-3-quiz-data-analysis-functions","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/bis-155-week-3-quiz-data-analysis-functions\/","title":{"rendered":"BIS 155 Week 3 Quiz (Data Analysis Functions)"},"content":{"rendered":"<p>Week 3 Quiz\t\t\t(TCO 4) If there are certain columns of information that are not needed at a particular time but might be needed later,_ the unneeded columns to allow users to focus on only the essential information. (Points:2)\t\t\t(TCO 4) In Excel, the print area is defined as _____. (Points : 2)\t\t\t(TCO 4) When sorting in Excel, it arranges records in a table _____. (Points : 2)\t\t\t(TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is&#8230;&#8230;__. (Points:2)\t\t\t(TCO 4) To create a new Conditional Formatting Rule, _____. (Points : 2)\t\t\t(TCO 4) In addition to sorting and filtering cells by content, you can sort and\/or filter by _____. (Points : 2)\t\t\t(TCO 4) When data is grouped, the margin area displays the _____. (Points : 2)\t\t\t(TCO 4) A\u00a0_____ allows you to identify relationships between variables in your data. (Points : 2)\t\t\t(TCO 4) Data mining techniques such as PivotTables can detect\u00a0_____ of data. (Points : 2)\t\t\t(TCO 4) A faster way to expand all categories at one time is to click _____. (Points : 2)\t\t\t(TCO 4) Data displayed in the PivotTable will be updated _____. (Points : 2)\t\t\t(TCO 4) A quick way to display the Go to dialog box is to press the\u00a0_____ key(s). (Points : 2)\t\t\t(TCO 4) After a PivotChart has been created, the PivotTable Settings can still be changed&#8230;.___.(Points:2)\t\t\t(TCO 4) To build a PivotTable and PivotChart at the same time, click the PivotTable arrow&#8230;&#8230;__. (Points:2)\t\t\t(TCO 4) Which of the following will NOT delete a PivotChart? (Points : 2)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Week 3 Quiz (TCO 4) If there are certain columns of information that are not needed at a particular time but might be needed later,_ the unneeded columns to allow users to focus on only the essential information. (Points:2) (TCO <a href=\"https:\/\/www.benedictsol.com\/blogs\/bis-155-week-3-quiz-data-analysis-functions\/\" 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-202949","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/202949","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=202949"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/202949\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=202949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=202949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=202949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}