Question: table [ [ Step , Instructions,Points Possible ] , [ 1 , Start Excel. Download and open the file named Exp 1 9 _

\table[[Step,Instructions,Points Possible],[1,Start Excel. Download and open the file named Exp19_Excel_Ch09_ML2_Pizza.xIsx. Grader has automatically added your last name to the beginning of the filename,0],[2,\table[[You want to enter totals from the Augusta workbook into the Pizza workbook.],[Display the Augusta worksheet; in cell B4, insert a link to the Dine-In total in cell F4 in the Exp19_Excel_Ch09_ML2_Augusta workbook. Edit the formula to make the cell reference relative.]],5],[3,\table[[You want to copy the formula down the column but preserve the original formatting],[Use AutoFill to copy the formula from cell B4 to the range B5:B7 in the Augusta worksheet. Close the Augusta workbook; keep the Pizza workbook open]],6],[4,\table[[You want to enter totals from the Portland workbook into the Pizza workbook.],[Display the Portland worksheet; in cell B4 insert a link to the Dine-In total in cell F4 in the Exp19_Excel_Ch09_ML2_Portland workbook. Edit the formula to make the cell reference relative.]],5],[5,\table[[You want to copy the formula down the column but preserve the original formatting],[Use AutoFill to copy the formula from cell B4 to the range B5:B7 in the Portland worksheet. Close the Portland workbook, keep the Pizza workbook open.]],6],[6,\table[[You want to enter totals from the Lewiston workbook into the Pizza workbook.],[Display the Lewiston worksheet, in cell B4 insert a link to the Dine-In total in cell F4 in the Exp19_ExceI_Ch09_ML2_Lewiston workbook. Edit the formula to make the cell reference relative.]],5],[7,\table[[You want to copy the formula down the column but preserve the original formatting.],[Use AutoFill to copy the formula from cell B4 to the range B5:B7 in the Lewiston worksheet. Close the Lewiston workbook; keep the Pizza workbook open.]],6],[8,\table[[The Summary sheet should contain the same formatting as the other sheets.],[Select the range A1:B7 in the Lewiston worksheet. Group the Lewiston and Summary worksheets. Fill formatting only across the grouped worksheets.]],5],[9,Ungroup the worksheets and change the width of column B to 16 in the Summary workshet,],[,,2]]
\ table [ [ Step , Instructions,Points Possible ]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!