Question 1. \ufffd Question : \ufffd\u00a0\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.\thide\tdelete\tfreeze\tformat\t\u00a0\tQuestion 2. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 4) In Excel, the print area is defined as _____.\t\u00a0an individual piece of data, such as a last name\ta complete set of data for an entity\tthe sequence in which pages print\t\u00a0the range of data to print\t\u00a0\tQuestion 3. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 4) When sorting in Excel, it arranges records in a table _____.\t\u00a0by the number of pages in the worksheet\tby the number of pages in the workbook\t\u00a0by the value in field(s) within a table\tby permanently removing extraneous data\t\u00a0\tQuestion 4. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 4) Filtering the Last_Name column (field) to show only records that begin with the letter S is an application of _____.\t\u00a0the use of a table element as a formula\ta Number Filter\t\u00a0a Text Filter\ta Date Filter\t\u00a0\tQuestion 5. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 4) To apply a red background color to cells for employees who have sales greater than $1,000, you can use _____.\t\u00a0a pivot table\ta multiple level sort\t\u00a0conditional formatting\ta range name\t\u00a0\tQuestion 6. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 4) In addition to sorting and filtering cells by content, you can sort and\/or filter by _____.\t\u00a0top\/bottom rules\t\u00a0conditional formatting\ticon sets\tthe data bar\t\u00a0\tQuestion 7. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 4) For subtotals to be useful and accurate, it is important that the data be _____ correctly.\tsorted\tformatted\taligned\t\u00a0labeled\t\u00a0\tQuestion 8. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 4) _____ are created to organize and summarize data in pivot tables.\tCategories\tTypes\tTitles\tLevels\t\u00a0\tQuestion 9. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 4) Data mining techniques, such as pivot tables can detect _____ of data.\tpatterns\tcategories\tstyles\tgroups\t\u00a0\tQuestion 10.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 4) To create a calculated field, select _____ located on the Pivot Table Tools Options tab.\tCalculations\tTools\tPivot Table Calculation\t\u00a0None of the above\t\u00a0\tQuestion 11.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 4) A Pivot Table Style controls all the following EXCEPT _____.\t\u00a0bolding\tfont colors\tnumber format\tshading colors\t\u00a0\tQuestion 12.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 4) A quick way to display the Go to dialog box is to press the _____ key(s).\t\u00a0F4\tCtrl+Home\tCtrl+End\t\u00a0F5\t\u00a0\tQuestion 13.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 4) To go to the top of your spreadsheet quickly, use the _____ key(s).\tCtrl+End\tArrow\tCtrl+Home\tEsc\t\u00a0\tQuestion 14.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 4)\u00a0 When Excel creates a PivotChart it uses the current PivotTable settings – if you want to change that data you might use\t\u00a0Insert PivotTable\tInsert Function\t\u00a0 PivotTable Field List\tFilter Connections\t\u00a0\tQuestion 15.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 4) Which of the following will NOT delete a pivot chart?\t\u00a0 Go to the Home tab and click Cut\t\u00a0Right-click the chart and click Cut\t\u00a0Select the chart and then press Delete\t\u00a0Click and drag the pivot chart off the worksheet<\/p>\n","protected":false},"excerpt":{"rendered":"
Question 1. \ufffd Question : \ufffd\u00a0\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 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-202945","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/202945","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=202945"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/202945\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=202945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=202945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=202945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}