Edit Excel Attachment Following Directions Below ✓ Solved

Edit Excel Attachment Following Directions Below

Edit the Excel attachment following the directions below:

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.

Rename Sheet1 and change the color of the sheet tab. Right-click on the Sheet1 tab, choose Rename, and type: WF300. Press Enter. 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).

Make a copy of the WF300 sheet. Right-click the sheet tab and select Move or Copy... to open the Move or Copy dialog. In the Before sheet box, select Sheet2. Check the Create a copy check box. Click OK. Name the new sheet WF301 and change the tab color. Right-click the new WF300(2) sheet tab, choose Rename, and type: WF301. Press Enter. 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).

Group sheets WF300 and WF301 so you can apply formatting changes to both sheets at once. 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. Verify that Group appears in the title bar, indicating that the selected sheets are grouped.

Resize column A in both worksheets at once to best fit the data by double-clicking the right border of the column heading.

Add a header and footer to both worksheets at once. Switch to Page Layout view by clicking the button on the status bar. Click in the center section of the header. 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.

On the Header & Footer tab, in the Header & Footer Elements group, click the File Name button again. Then click in the right section of the header and type your own name. Click in the center section of the footer. On the Header & Footer Tools Design tab, click the Sheet Name button to add it.

Click in the right section of the footer. On the Header & Footer Tools Design tab, click the Current Date button. Click in any cell of the worksheet and click the Normal button on the status bar. Ungroup the sheets by clicking Sheet2. Verify that the same formatting was applied to both sheets and that they are now ungrouped.

Apply the Gallery theme to the workbook. Select the WF300 sheet and scroll to the right to see the end of the semester. Click cell D1. On the View tab, in the Window group, click the Split button. Scroll to show the student names and the last few weeks of the semester on your screen.

Insert a new row to add a new student to the list. Right-click on the row heading for row number 9 and select Insert. Click the Insert Options button and select Format Same As Below. Enter the new student name: Abrams, Maria and her student ID #.

Select the WF301 sheet. Copy the student data from Sheet2 and then hide Sheet2 when it is no longer needed. On WF301, select cells A9:B29 and press Delete. Go to Sheet2 and copy the student names and ID numbers from A2:B20. Paste them to cell A9 in the WF301 sheet. Hide Sheet2 by right-clicking on the sheet name.

Remove Mary Wahl from the WF301 class roster. Delete her entire row from WF301 by right-clicking and selecting Delete. Use the Freeze Panes option to keep rows 1-8 and columns A-B visible at all times.

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. Hide the student ID numbers by right-clicking on column B. Set the page layout options such as landscape orientation and narrow margins. Print the selected cells as an attendance sign-in sheet.

Select the WF300 worksheet, hide the attendance sign-in column, and set it to print column A and rows 1-8 on every page. Adjust the layout to fit on fewer pages, insert page breaks as necessary, and preview how the worksheet will print.

Save and close the workbook and upload the completed assignment.

Paper For Above Instructions

In today's fast-paced educational environment, the use of digital tools such as Microsoft Excel has become essential for managing student data effectively. Editing an Excel workbook requires proficiency in various features, which can significantly enhance the organization and accessibility of information. This document aims to detail the necessary steps to modify an Excel workbook as instructed and how such modifications can facilitate better management of classroom data.

The first step involves renaming the default worksheet, which is typically labeled "Sheet1." This can be accomplished by right-clicking on the sheet tab, selecting "Rename," and typing the new name, "WF300," followed by pressing Enter. Additionally, changing the tab color to Blue, Accent 1 allows for easier identification of the sheet, especially when multiple sheets are present in the workbook.

After setting up the first sheet, creating a copy is essential. This can be done by right-clicking the WF300 sheet tab and selecting "Move or Copy." In the subsequent dialog box, one must choose "Sheet2" as the destination while ensuring that the "Create a copy" checkbox is selected. Denoting this new sheet as "WF301" provides a clear distinction between the classes or groups represented by each sheet. The color coding of the tab to Green, Accent 6 is similarly beneficial for visual organization.

Grouping sheets WF300 and WF301 offers a significant advantage, as formatting changes can then be applied simultaneously. This functionality is particularly useful in educational settings where multiple classes may share the same structure or data format. After grouping the sheets, actions such as resizing column A to fit the data optimally enhances the readability of the spreadsheet.

The addition of headers and footers across both worksheets streamlines documentation practices. By incorporating the file name automatically through the Header & Footer Tools Design tab, one can ensure that the document retains a professional appearance. Including personal identifiers, such as the instructor's name in the right section of the header, personalizes the workbook and adheres to formal documentation standards.

Modern features such as freezing panes are invaluable for maintaining visibility on critical data, particularly student names and identifiers, while scrolling through extensive data sets. The Freeze Panes option effectively keeps essential rows and columns in view, which is especially helpful during data entry and review sessions.

Updating student information lists is a common requirement in educational settings. The process of inserting a new student, as highlighted, involves a few simple steps: selecting the appropriate row for insertion, using the right-click context menu to insert and format as per the existing data, and thereafter ensuring accuracy in the newly entered details. In conjunction with this, copying data from one sheet to another (like from Sheet2 to WF301) utilizes the cut/copy-paste features effectively to transfer necessary information while maintaining organizational standards.

Maintaining data integrity is crucial; therefore, deleting unneeded information, like the removal of a student who decides to drop the course, must be executed carefully. These tasks make regular data management more seamless, especially when combined with the ability to hide columns that are not pertinent to the upcoming tasks, such as student ID numbers when creating attendance sheets.

Adjusting print settings is the final crucial step in preparing the workbook for distribution, where ensuring that necessary sections are printed and appropriately spaced helps maintain clarity and accessibility for the administration office. Modifying page layout options such as orientation and margins, as well as selecting freeze frames on specific rows and columns, ensures that every page that gets printed retains uniformity and ease of reading.

In conclusion, editing an Excel workbook as directed presents a variety of skills that promotes more efficient data management in educational environments. Following the outlined steps not only adheres to the teacher's assignment but incorporates best practices for keeping student records organized and accessible. Furthermore, mastering these skills is invaluable, not just in academic settings but throughout various professional paths that require data management acumen.

References

  • Excel Easy. (n.d.). Excel Functions and Formulas. Retrieved from https://www.excel-easy.com/functions.html
  • Microsoft. (2021). Use headers and footers in Excel. Retrieved from https://support.microsoft.com/en-us/office/use-headers-and-footers-in-excel-1464c539-a087-4ac4-998b-6a64fd1ed78c
  • Microsoft. (2021). Freeze rows and columns in an Excel spreadsheet. Retrieved from https://support.microsoft.com/en-us/office/freeze-panes-to-keep-row-and-column-headings-visible-9f8d1433-141b-4e48-a345-1cfd3e7f84c1
  • Pearson Education. (2019). Mastering Excel: A Step-by-Step Guide. Boston, MA: Pearson.
  • Chandoo.org. (2020). How to Rename Worksheet Tabs in Excel. Retrieved from https://chandoo.org/wp/rename-worksheet-tabs-excel/
  • Office Tutorials. (2020). Excel Formatting Tips. Retrieved from https://www.officetutorials.com/excel-formatting-tips/
  • ExcelJet. (n.d.). Excel Page Layout: How to Use the Page Layout View. Retrieved from https://exceljet.net/lessons/excel-page-layout-view
  • TechOnTheNet. (2020). Excel Delete Rows. Retrieved from https://www.techonthenet.com/excel/actions/delete.php
  • Excel Campus. (2021). How to Create Attendance Sheets in Excel. Retrieved from https://www.excelcampus.com/templates/attendance-sheet/
  • Contextures. (2020). Excel Copy and Move Worksheets. Retrieved from https://www.contextures.com/excelmoveworksheet.html

Related Assignments