Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I'm using pc excel and stuck from number 13 Can someone help me with explain and picture if possible?? begin{tabular}{|c|l|} hline 9 & Ungroupthesheets,andtheninsertanewworksheet.ChangethesheetnametoSummaryandthenwidencolumnAto28andcolumnsB:Eto21
I'm using pc excel and stuck from number 13 Can someone help me with explain and picture if possible??
\begin{tabular}{|c|l|} \hline 9 & Ungroupthesheets,andtheninsertanewworksheet.ChangethesheetnametoSummaryandthenwidencolumnAto28andcolumnsB:Eto21 \\ \hline 10 & MovetheSummarysheetsothatitisthefirstsheetintheworkbook.IncellA1oftheSummarysheet,typeRosedaleLandscapeandGardenandthenMerge&CenterthetitleacrosstherangeA1:E1.ApplytheTitlecellstyle.IncellA2,typeJuneCommercialSalespersonBonusSummary:CaliforniaandthenMerge&CenterthetextacrosstherangeA2:E2.ApplytheHeading1cellstyle. \\ \hline 11 & IntherangeA5:A7,typethefollowingrowtitlesandthenapplytheHeading4cellstyle:BonusBaseSalaryTotalCompensation \\ \hline 12 & IntherangeB4:E4,typethefollowingcolumntitles,andthenCenterandapplytheHeading3cellstyle:Northern/SouthernNorthernSouthernTotal \\ \hline 13 & IncellC5,enteraformulathatreferencescellD9intheNorthernworksheetsothatthetotalbonusamountfortheNorthernregiondisplaysincellC5.CreatesimilarformulastoenterthetotalBaseSalaryfortheNorthernregionincellC6.Usingthesametechnique,enterformulasintherangeD5:D6sothattheSoutherntotalsdisplay. \\ \hline 14 & SumtheBonusandBaseSalaryrows,andthencalculateTotalCompensationfortheNorthern,Southern,andTotalcolumns. \\ \hline 15 & IncellB5,insertaColumnSparklinefortherangeC5:D5.IncellsB6andB7,insertColumnsparklinesfortheappropriaterangestocompareNortherntotalswithSoutherntotals. \\ \hline Groupthethreeworksheets,andthencentertheworksheetsHorizontallyonthepageandinsertaCustomFooterintheleftsectionwiththefilename.ChangetheOrientationtoLandscapethendisplaytheprintpreview.ChangethescalingtoFitAllColumnsonOnePage. \\ \hline 16 \end{tabular} \begin{tabular}{|c|l|} \hline 9 & Ungroupthesheets,andtheninsertanewworksheet.ChangethesheetnametoSummaryandthenwidencolumnAto28andcolumnsB:Eto21 \\ \hline 10 & MovetheSummarysheetsothatitisthefirstsheetintheworkbook.IncellA1oftheSummarysheet,typeRosedaleLandscapeandGardenandthenMerge&CenterthetitleacrosstherangeA1:E1.ApplytheTitlecellstyle.IncellA2,typeJuneCommercialSalespersonBonusSummary:CaliforniaandthenMerge&CenterthetextacrosstherangeA2:E2.ApplytheHeading1cellstyle. \\ \hline 11 & IntherangeA5:A7,typethefollowingrowtitlesandthenapplytheHeading4cellstyle:BonusBaseSalaryTotalCompensation \\ \hline 12 & IntherangeB4:E4,typethefollowingcolumntitles,andthenCenterandapplytheHeading3cellstyle:Northern/SouthernNorthernSouthernTotal \\ \hline 13 & IncellC5,enteraformulathatreferencescellD9intheNorthernworksheetsothatthetotalbonusamountfortheNorthernregiondisplaysincellC5.CreatesimilarformulastoenterthetotalBaseSalaryfortheNorthernregionincellC6.Usingthesametechnique,enterformulasintherangeD5:D6sothattheSoutherntotalsdisplay. \\ \hline 14 & SumtheBonusandBaseSalaryrows,andthencalculateTotalCompensationfortheNorthern,Southern,andTotalcolumns. \\ \hline 15 & IncellB5,insertaColumnSparklinefortherangeC5:D5.IncellsB6andB7,insertColumnsparklinesfortheappropriaterangestocompareNortherntotalswithSoutherntotals. \\ \hline Groupthethreeworksheets,andthencentertheworksheetsHorizontallyonthepageandinsertaCustomFooterintheleftsectionwiththefilename.ChangetheOrientationtoLandscapethendisplaytheprintpreview.ChangethescalingtoFitAllColumnsonOnePage. \\ \hline 16 \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started