Question: table [ [ Step , Instructions,Points Possible ] , [ 1 , Start Excel. Download and open the file named Exp 1 9 _
tableStepInstructions,Points PossibleStart Excel. Download and open the file named ExpExcelChMLPizza.xIsx. Grader has automatically added your last name to the beginning of the filename,tableYou want to enter totals from the Augusta workbook into the Pizza workbook.Display the Augusta worksheet; in cell B insert a link to the DineIn total in cell F in the ExpExcelChMLAugusta workbook. Edit the formula to make the cell reference relative.tableYou want to copy the formula down the column but preserve the original formattingUse AutoFill to copy the formula from cell B to the range B:B in the Augusta worksheet. Close the Augusta workbook; keep the Pizza workbook opentableYou want to enter totals from the Portland workbook into the Pizza workbook.Display the Portland worksheet; in cell B insert a link to the DineIn total in cell F in the ExpExcelChMLPortland workbook. Edit the formula to make the cell reference relative.tableYou want to copy the formula down the column but preserve the original formattingUse AutoFill to copy the formula from cell B to the range B:B in the Portland worksheet. Close the Portland workbook, keep the Pizza workbook open.tableYou want to enter totals from the Lewiston workbook into the Pizza workbook.Display the Lewiston worksheet, in cell B insert a link to the DineIn total in cell F in the ExpExceIChMLLewiston workbook. Edit the formula to make the cell reference relative.tableYou want to copy the formula down the column but preserve the original formatting.Use AutoFill to copy the formula from cell B to the range B:B in the Lewiston worksheet. Close the Lewiston workbook; keep the Pizza workbook open.tableThe Summary sheet should contain the same formatting as the other sheets.Select the range A:B in the Lewiston worksheet. Group the Lewiston and Summary worksheets. Fill formatting only across the grouped worksheets.Ungroup the worksheets and change the width of column B to in the Summary workshet,
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
