Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Management Accounting And Control

Authors: Don R. Hansen, Maryanne Mowen

2nd Edition

0538864451, 978-0538864459

More Books

Students also viewed these Accounting questions