Working with Multiple Worksheets ? Challenge activity Follow the instruction given here https://edu.gcf
Working with Multiple Worksheets ? Challenge activity Follow the instruction given here 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. 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 Follow the instruction given here 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. 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 Follow the instruction given here 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. 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 Follow the instructions given here https://edu.gcfglobal.org/en/excel2016/page-layout-and-printing/1/ 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. 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.) 45 45
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
