Working with Multiple Worksheets – Challenge activity Follow the instruction given here https://edu

Subject:Computer SciencePrice: Bought3

Share With

Working with Multiple Worksheets – Challenge activity

1. Follow the instruction given here
2. https://edu.gcfglobal.org/en/excel2016/working-with-multiple-worksheets/1/
   • Insert a new worksheet, and rename it Q1 Summary.
   • Move the Expenses Summary worksheet to the far right, then move the Q1 Summary worksheet so that it is between March and April.
   • Create a copy of the Expenses Summary worksheet by right-clicking . Do not just copy and paste the content of the worksheet into a new worksheet.
   • Change the color of the January tab to blue and the color of the February tab to red.
   • Group the worksheets September, October, and November.
3. Use the file provided on the site. Create a screen shot of your edited document and paste it in Word before saving. Save as YourName_MultipleWorksheets.docx

25

25

You nailed it!

Using Find & Replace – Challenge activity

1. Follow the instruction given here
2. https://edu.gcfglobal.org/en/excel2016/using-find-replace/1/
   • Select the Challenge worksheet in the bottom-left of the workbook.
   • Crystal Lewis was married and changed her last name to Taylor. Use Find and Replace to change Crystal's last name from Lewis to Taylor. Be careful to only change Crystal's last name!
   • Find and replace Bio with Biology. Be careful not to change the major Biomedical Engineering!
   • Use Find and Replace All to replace the Physics major to Physical Science.
3. Use the file provided on the site. Create a screen shot of your edited document and paste it in Word before saving. Save as YourName_FindAndReplace.docx

15

15

Checking Spelling – Challenge activity

1. Follow the instruction given here
2. https://edu.gcfglobal.org/en/excel2016/checking-spelling/1/
   • Select the Challenge worksheet in the bottom-left of the workbook.
   • Run the Spell Check to correct any spelling errors in the workbook.
   • Correct the words coffe and medum using the suggested spelling.
   • Ignore the spelling suggestion for the word Amanecer.
3. Use the file provided on the site. Create a screen shot of your edited document and paste it in Word before saving. Save as YourName_Spelling.docx

15

15

Page Layout and Printing – Challenge activity

1. Follow the instructions given here
2. https://edu.gcfglobal.org/en/excel2016/page-layout-and-printing/1/
3. Provide a screen image of the following:
   • Select East Coast at the bottom of the workbook.
   • In the Page Layout tab, use the Print Titles feature to repeat row 1 at the top and column A at the left.
   • Using the Page Break Preview command, move the break between rows 47 and 48 up so it's between rows 40 and 41.
   • In Backstage view, open the Print Pane.
   • In the Print pane, change the orientation to Landscape.
   • Change the margins to Narrow.
   • Change the scaling to Fit All Columns on One Page.
4. Put your name on the file and screen shot the document showing your name. Paste the screenshot into Word before saving as YourName_PageLayout.pdf. (Be sure to save it as a PDF file.)