Question: teps to Perform: table [ [ Step , Instructions, table [ [ Points ] , [ Possible ] ] ] , [ 1
teps to Perform:
tableStepInstructions,tablePointsPossibletableStart Excel. Download and open the file namedExcelChAssessmentVariationAutoBody.xIsx. Grader has automatically added your lastname to the beginning of the filename. Save the file to the location where you are storing yourfilestableRename Sheet Sales and change the worksheet tab color to Light Blue.Rename Sheet DocumentationtableTo improve the readability of the worksheet, center the worksheets titles.On the Sales worksheet, set the horizontal alignment for cell ranges A:H to Center AcrossSelectiontableTo allow for future formatting of the title, increase the height of row only to Hide row tableIn cell H type TotalIn cell A type TotaltableTo save time entering data, use the fill handle to copy the month cell B through GTo make the worksheet visually appealing, in cell range B:H apply the AngleCounterclockwise orientation.tableNext you want to total the services by month.In cell range B:G enter a function to calculate the monthly totals.In cell range : enter a function to calculate the total of each service offered.,tableContinue formatting the worksheet by completing the following:In cell range A:H apply Heading cell style.In cell A apply Title cell style.In cell A apply Heading cell style.tableTo improve the readability of the worksheet numbers, in cell ranges : and : applythe Accounting Number Format.tableTo align the numbers with the totals in cell range : in cell range : apply theComma Style format.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
