Excel work ….. edit excel document ……. do today…… 5

due in 5 hours…… no late work…… 

Edit the excel attachment following the directions below.  Upload when finished so i can turn in

Do the following: 

  1. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook.
  2. Rename Sheet1 and change the color of the sheet tab.
    1. Right-click on the Sheet1 tab, choose Rename, and type: WF300
    2. Press Enter.
    3. Right-click the sheet tab again, point to Tab Color, and select Blue, Accent 1 (the fifth color in the first row of theme colors).
  3. Make a copy of the WF300 sheet.
    1. Right-click the sheet tab and select Move or Copy… to open the Move or Copy dialog.
    2. In the Before sheet box, select Sheet2.
    3. Check the Create a copy check box.
    4. Click OK.
  4. Name the new sheet WF301 and change the tab color.
    1. Right-click the new WF300(2) sheet tab, choose Rename, and type: WF301
    2. Press Enter.
    3. Right-click the sheet tab again, point to Tab Color, and select Green, Accent 6 (the last color in the first row of theme colors).
  5. Group sheets WF300 and WF301 so you can apply formatting changes to both sheets at once.
    1. Click the WF300 sheet tab, press and hold Ctrl, and click the WF301 sheet tab. Now any changes made to one of the sheets will be made to both sheets.
    2. Verify that Group appears in the title bar, indicating that the selected sheets are grouped.
  6. Resize column A in both worksheets at once to best fit the data by double-clicking the right border of the column heading.
  7. Add a header and footer to both worksheets at once.
    1. Switch to Page Layout view by clicking the Page Layout button on the status bar.
    2. Click in the center section of the header.
    3. On the Header & Footer Tools Design tab, in the Header & Footer Elements group, click the File Name button. The code &[File] will be entered in the center section of the header. Once you click somewhere else, this will display the name of your file.
      Alternate Instruction for Microsoft 365 Apps icon On the Header & Footer tab, in the Header & Footer Elements group, click the File Name button. The code &[File] will be entered in the center section of the header. Once you click somewhere else, this will display the name of your file.
    4. Click in the right section of the header and type your own name.
    5. On the Header & Footer Tools Design tab, in the Navigation group, click the Go to Footer button.
      Alternate Instruction for Microsoft 365 Apps icon On the Header & Footer tab, in the Navigation group, click the Go to Footer button.
    6. Click in the center section of the footer.
    7. On the Header & Footer Tools Design tab, in the Header & Footer Elements group, click the Sheet Name button. The code &[Tab] will be entered. Once you click somewhere else, this will display the name of the sheet.
      Alternate Instruction for Microsoft 365 Apps icon On the Header & Footer tab, in the Header & Footer Elements group, click the Sheet Name button. The code &[Tab] will be entered. Once you click somewhere else, this will display the name of the sheet.
    8. Click in the right section of the footer.
    9. On the Header & Footer Tools Design tab, in the Header & Footer Elements group, click the Current Date button. Once you click somewhere else, this will display the current date.
      Alternate Instruction for Microsoft 365 Apps icon On the Header & Footer tab, in the Header & Footer Elements group, click the Current Date button. Once you click somewhere else, this will display the current date.
    10. Click in any cell of the worksheet and click the Normal button on the status bar.
  8. Ungroup the sheets by clicking Sheet2. Verify that the same formatting was applied to both sheets and that they are now ungrouped.
  9. Apply the Gallery theme to the workbook.
    1. On the Page Layout tab, in the Themes group, click the Themes button to display the Themes gallery.
    2. Notice that as you hover the mouse pointer over each option in the Themes gallery, Excel updates the worksheet to display a live preview of how the theme would affect the worksheet.
    3. Click the Gallery option.
  10. Select the WF300 sheet. It can be difficult to work with such a wide worksheet. Scroll to the right to see the end of the semester, and you can no longer see the student names. Split the screen into two views of different parts of this worksheet.
    1. Click cell D1. On the View tab, in the Window group, click the Split button. Now you can scroll each pane separately, but it is all still the same worksheet. You can drag the split bar to the right or left as needed.
    2. Scroll to show the student names and the last few weeks of the semester on your screen.
    3. Click the Split button again to return to normal.
  11. Insert a new row to add a new student to the list.
    1. Right-click on the row heading for row number 9 and select Insert.
    2. Click the Insert Options button that appears immediately below where you right-clicked, and select Format Same As Below.
    3. Enter the new student name: Abrams, Maria
    4. Enter her student ID #: 1350417
  12. Select the WF301 sheet. Because this sheet was copied from the WF300 class worksheet, the student names and ID numbers are not those of the students in WF301 class. Copy the student data from Sheet2, and then hide Sheet2 when it is no longer needed.
    1. On sheet WF301, select cells A9:B29. Press Delete to delete the content.
    2. Go to Sheet2 and copy the student names and ID numbers from cells A2:B20.
    3. Paste the copied names and ID numbers to cell A9 in the WF301 sheet.
    4. Hide Sheet2 by right-clicking on the sheet name and selecting Hide.
  13. Mary Wahl has decided to drop the class. Remove her from the WF301 class roster.
    1. On worksheet WF301, delete the entire row for Mary by right-clicking on the row heading for row number 25 and selecting Delete.
  14. Use the Freeze Panes option to keep rows 1:8 and columns A:B visible at all times.
    1. Verify that the WF301 sheet is selected, and click cell C9.
    2. On the View tab, in the Window group, click the Freeze Panes button, then click the Freeze Panes option.
    3. Verify that you selected the correct point at which to freeze panes. Scroll down and to the right. Are rows 1:8 and columns A:B visible regardless of where you scroll?
  15. There is an extra blank worksheet in the workbook. Right-click Sheet3 and select Delete.

Modify sheet WF301 to print as an attendance sign-in sheet.

  1. First, hide the student ID numbers by right-clicking on the column B heading and selecting Hide.
  2. Set the page layout options.
    1. On the Page Layout tab, in the Page Setup group, click the Orientation button, and select Landscape.
    2. On the Page Layout tab, in the Page Setup group, click the Margins button, and select Narrow.
    3. On the Page Layout tab, in the Scale to Fit group, expand the Width list and select 1 page, and expand the Height list and select 1 page.
    4. On the Page Layout tab, in the Sheet Options group, click the Print check box under Gridlines.
  3. Print only the part of the worksheet to use as the attendance sign-in sheet.
    1. Select the appropriate cells to print as an attendance sign-in by selecting cells A1:C26.
    2. Click the File tab to open Backstage view, and then click Print to display the Print page.
    3. Under Settings, click the Print Active Sheets button to expand the options, and select Print Selection.
    4. If your instructor has directed you to print the attendance sign-in list, click the Print button.
    5. Click the Back arrow to exit Backstage view.

At the end of the semester you will need to print all the attendance records to turn in to the administration office. Let’s set this up for the WF300 class worksheet.

  1. Select the WF300 worksheet, and hide the attendance sign-in column by right-clicking the column C heading and selecting Hide.
  2. Modify the worksheet so column A and rows 1 through 8 will print on every page.
    1. On the Page Layout tab, in the Page Setup group, click the Print Titles button.
    2. Click in the Rows to repeat at top box, and then click and drag with the mouse to select rows 1:8. When you release the mouse button, you should see $1:$8 in the box.
    3. Click in the Columns to repeat at left box, and then click with the mouse to select column A. When you release the mouse button, you should see $A:$A in the box.
    4. Click OK.
  3. Preview how the worksheet will look when printed and make adjustments from the Print page to keep the report to four or fewer pages.
    1. Click the File tab to open Backstage view, and then click Print.
    2. If necessary, click the Print Selection under Settings and select Print Active Sheets. Click the Show Print Preview button.
    3. Note that the current settings will cause the worksheet to print on five pages.
    4. Under Settings, click the Portrait Orientation button and switch to Landscape Orientation instead.
    5. Under Settings, click the Normal Margins button, and select Custom Margins… to set your own margins.
    6. In the Page Setup dialog, on the Margins tab, change the Top, Bottom, Left, and Right values to 0.5 inches. Click OK.
    7. Under Settings, click the No Scaling button, and select Fit All Rows on One Page.
    8. Click the Back arrow to exit Backstage.
  4. Modify the worksheet page breaks so weeks 1-8 print on the first page and weeks 9-16 print on the second page.
    1. If necessary, scroll to the right so columns T:V are visible. Note that the current page break occurs between columns U and V (after week 9).
    2. Click cell T1.
    3. On the Page Layout tab, in the Page Setup group, click the Breaks button, and select Insert Page Break. This inserts a page break to the left of the selected cell (after week 8).
    4. Click the File tab to open Backstage view, and then click Print to preview how the change will affect the printed pages.
    5. If your instructor has directed you to print the worksheet, click the Print button.
    6. Click the Back arrow to exit Backstage view.
  5. Save and close the workbook.
HelpHub
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Choose HelpHub

HelpHub

Quality Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

HelpHub

Qualified Writers

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

StudyAcer

Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account.

StudyAcer

On Time Delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. We will always strive to deliver on time.

StudyAcer

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text.

StudyAcer

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Help Hub

Place your order

Fill in the order form and provide all details of your assignment.

Help Hub

Proceed with the payment

Choose the payment system that suits you most.

Help Hub

Receive the final file

Once your paper is ready, we will email it to you.

HelpHub Writing Services

No need to work on essay at night. Sleep tight, we will cover your back. We offer all kinds of essay writing services.

HelpHub HelpHub

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

HelpHub HelpHub

Admissions

Admission Essays

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

HelpHub HelpHub

Editing

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

HelpHub HelpHub

Revision

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied.