# CengageHomeworkCh2ClassTemplate.xlsx - Color Key Insert...

• 29

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 4 out of 29 pages.

Color KeyInsert your dataCalculate/Identify The AnswerData AnalysisAuto CalculatedAuto Calculated DecisionYear-end AudConstruct Frequency Distribution Pivot TableStep 1– Select any cell in the data setStep 2– ClickInserton the RibbonStep 3– In theTablesgroup clickPivot TableStep 4 -When theCreate PivotTabledialog box a(a PivotTable and PivotTable Fields dianew worksheet)To construct the frequency distribution, wrowscontaining audit time.Step 1 -Right click any cell in the PivotTabcontaining a an audit time.
Pivot Tables (PT): Used to create Frequency Distributions, Cumulative Distributions, aSelect all your dataset in ExcelGo to InsertClick on Pivot Table (PT)Ensure that all your data is selected in the Select a table or range fieldPlace your PT results either in a New Worksheet or in the Existing WoClick on and drag the category(ies) into the Rows sectionClick on and drag the category(ies) into the Column section (if neededClick on and drag the category(ies) into the Values sectionoFrequency: Use CountoFrequency Percentage: Use Count and Percent of Parent RowoCumulative Frequency: Use Count and Running Total In…oCumulative Percentage: Use Count and % Running Total In…Group: Right Click on row or column value and select group.oUncheck Starting at value and set to 0oCheck Ending at value and set to your largest valueoSet By to the value you want your grouping to be divided incontaining a an audit time.Step 2 -ChooseGroupfrom the list of optiStep 3-When the Grouping dialog box aEnter 10 in theStarting atboxEnter 34 in theEnding atboxEnter 5 in theByboxClickOK
dit Time (in Days)appears: Clickalog box will appear in aStep 5Step 6Step 7Step 8Summwe must group theble report

Course Hero member to access this document

Course Hero member to access this document

End of preview. Want to read all 29 pages?