{"id":108356,"date":"2022-12-06T22:57:23","date_gmt":"2022-12-06T22:57:23","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/devry-chicago-bis-155-week-3-quiz-2014\/"},"modified":"2022-12-06T22:57:23","modified_gmt":"2022-12-06T22:57:23","slug":"devry-chicago-bis-155-week-3-quiz-2014","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/devry-chicago-bis-155-week-3-quiz-2014\/","title":{"rendered":"Devry chicago bis 155 week 3 quiz 2014"},"content":{"rendered":"
\n

Week3\u00a0Quiz
\u00a01.\u00a0Question :\u00a0(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.<\/p>\n

\u00a0\u00a0Student Answer:\u00a0 \u00a0\u00a0 hide<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 delete<\/p>\n

\u00a0\u00a0\u00a0 \u00a0\u00a0 freeze<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 format<\/p>\n

\u00a0<\/p>\n

Question 2.\u00a0Question :\u00a0(TCO 4) Which of the following best describes a page break?<\/p>\n

\u00a0\u00a0Student Answer:\u00a0\u00a0\u00a0 Freezes only the top row<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 The sequence in which pages print<\/p>\n

\u00a0\u00a0\u00a0 \u00a0\u00a0 Indicates where data starts on a new printed page<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 Stops the printer from printing<\/p>\n

\u00a0<\/p>\n

Question 3.\u00a0Question :\u00a0(TCO 4) To create a table from an existing range of data, _____.<\/p>\n

\u00a0\u00a0Student Answer:\u00a0 \u00a0\u00a0 click within the range, click the Table Tools Design tab, and then select Convert to Table
\u00a0\u00a0\u00a0\u00a0\u00a0 select any cell in the worksheet and then click Existing Range in the Tools group
\u00a0\u00a0\u00a0\u00a0\u00a0 click in a cell and on the Home tab, and click the Insert arrow in the Cells group
\u00a0\u00a0\u00a0 \u00a0\u00a0 click the Insert tab and then click Table in the Tables group<\/p>\n

\u00a0<\/p>\n

Question 4.\u00a0Question :\u00a0(TCO 4) Which of the following best describes the Excel filtering feature?<\/p>\n

\u00a0\u00a0Student Answer:\u00a0\u00a0\u00a0 Helps to clean the data before printing in Backstage view<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 Displays data in chronological order<\/p>\n

\u00a0\u00a0\u00a0 \u00a0\u00a0 The process of displaying only records that meet specific conditions
\u00a0\u00a0\u00a0 \u00a0\u00a0 Arranges dates in alphabetical order<\/p>\n

Question 5.\u00a0Question :\u00a0(TCO 4) To apply a red background color to cells for employees who have sales greater than $1,000, you can use _____.<\/p>\n

\u00a0\u00a0Student Answer:\u00a0\u00a0\u00a0 a PivotTable<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 a multiple level sort<\/p>\n

\u00a0\u00a0\u00a0 \u00a0\u00a0 conditional formatting<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 a range name<\/p>\n

\u00a0<\/p>\n

Question 6.\u00a0Question :\u00a0(TCO 4) In addition to sorting and filtering cells by content, you can sort and\/or filter by _____.<\/p>\n

\u00a0\u00a0Student Answer:\u00a0\u00a0\u00a0 top\/bottom rules<\/p>\n

\u00a0\u00a0\u00a0 \u00a0\u00a0 conditional formatting<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 icon sets<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 the data bar<\/p>\n

\u00a0<\/p>\n

Question 7.\u00a0Question :\u00a0(TCO 4) When data is grouped, the margin area displays the _____.<\/p>\n

\u00a0\u00a0Student Answer:\u00a0\u00a0\u00a0 aggregate columns<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 group headings<\/p>\n

\u00a0\u00a0\u00a0 \u00a0\u00a0 collapse and expand buttons<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 group totals<\/p>\n

Question 8.\u00a0Question :\u00a0(TCO 4) _____ are created to organize and summarize data in PivotTables.<\/p>\n

\u00a0\u00a0Student Answer:\u00a0 \u00a0\u00a0 Categories<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 Types<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 Titles<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 Levels<\/p>\n

\u00a0<\/p>\n

Question 9.\u00a0Question :\u00a0(TCO 4) Data mining techniques such as PivotTables can detect _____ of data.<\/p>\n

\u00a0\u00a0Student Answer:\u00a0 \u00a0\u00a0 patterns<\/p>\n

\u00a0\u00a0\u00a0 \u00a0\u00a0 categories<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 styles<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 groups<\/p>\n

Question 10.\u00a0Question :\u00a0(TCO 4) The Insert Calculated Field dialog box requires you do all the following EXCEPT _____.<\/p>\n

\u00a0\u00a0Student Answer:\u00a0\u00a0\u00a0 enter formulas using field names instead of cell references<\/p>\n

\u00a0\u00a0\u00a0 \u00a0\u00a0 enter a description column heading for the calculated field<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 build formulas using mathematical operands such as +, -, and *<\/p>\n

\u00a0\u00a0\u00a0 \u00a0\u00a0 enter formulas using cell references<\/p>\n

Question 11.\u00a0Question :\u00a0(TCO 4) Excel applies basic formatting to PivotTables such as _____.<\/p>\n

\u00a0\u00a0Student Answer:\u00a0\u00a0\u00a0 subtotals in italics<\/p>\n

\u00a0\u00a0\u00a0 \u00a0\u00a0 primary row labels in bold<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 primary row labels in italics<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 subtotals in red<\/p>\n

\u00a0<\/p>\n

Question 12.\u00a0Question :\u00a0(TCO 4) The _____ enables you to move to a cell quickly by typing the desired cell reference in it and pressing Enter.<\/p>\n

\u00a0\u00a0Student Answer:\u00a0\u00a0\u00a0 Formula bar<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 F4 function key<\/p>\n

\u00a0\u00a0\u00a0 \u00a0\u00a0 Go to dialog box<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 Find and Replace dialog box<\/p>\n

Question 13.\u00a0Question :\u00a0(TCO 4) To go to the top of your spreadsheet quickly, use the _____ key(s).<\/p>\n

\u00a0\u00a0Student Answer:\u00a0\u00a0\u00a0 Ctrl+End<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 Arrow<\/p>\n

\u00a0\u00a0\u00a0 \u00a0\u00a0 Ctrl+Home<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 Esc<\/p>\n

Question 14.\u00a0Question :\u00a0(TCO 4) Click the _____ to sort or filter the chart representation based on the values.<\/p>\n

\u00a0\u00a0Student Answer:\u00a0\u00a0\u00a0 Axis Field arrows<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 Report Filter arrows<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 Values arrows<\/p>\n

\u00a0\u00a0\u00a0 \u00a0\u00a0 Legend Field arrows<\/p>\n

Question 15.\u00a0Question :\u00a0(TCO 4) Pivot Charts look best when they use basic charts, such as a _____.<\/p>\n

\u00a0\u00a0Student Answer:\u00a0 \u00a0\u00a0 column chart<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 scatter chart<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 radar chart<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 surface chart<\/p>\n

\u00a0<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Week3\u00a0Quiz\u00a01.\u00a0Question :\u00a0(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. \u00a0\u00a0Student Answer:\u00a0 \u00a0\u00a0 hide \u00a0\u00a0\u00a0\u00a0\u00a0 delete \u00a0\u00a0\u00a0 \u00a0\u00a0 freeze \u00a0\u00a0\u00a0\u00a0\u00a0 format \u00a0 Question 2.\u00a0Question :\u00a0(TCO 4) Which of […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-108356","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/108356","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=108356"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/108356\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=108356"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=108356"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=108356"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}