PAUSE & PRACTICE: EXCEL 7-3

PAUSE & PRACTICE: EXCEL 7-3

In this project, you inspect a workbook, check it for accessibility, save it to OneDrive, and share it for editing in Excel for the web. Note: You must have access to a secondary email address or work with a classmate or co-worker to complete this project.

File Needed: [your initials] PP E7-2Workbook.xlsx

Completed Project File Names: [your initials] PP E7-3.xlsx and [your initials] PP E7-3Shared.xlsx

1. Open the [your initials] PP E7-2Workbook workbook completed in Pause & Practice 7-2 and save it as [your initials] PP E7-3 in your usual folder for saving work.
2. Remove sheet protection.
   1. Note that many commands on the Ribbon are grayed out. The Reservations sheet in your template was protected.
   2. Click the Info command on the File tab (Figure 7-60).
   3. Click Unprotect in the Protect Workbook group.
   4. Return to the workbook.
3. Check accessibility.
   1. Click the Check Accessibility button [Review tab, Accessibility group]. Objects without alternative text are identified in the Accessibility pane. The workbook does not include merged cells.
   2. Expand the Missing alternative text group.
   3. Click Logo (Reservations) in the Accessibility pane. The image in column A is selected.
   4. Click the drop-down list for Logo (Reservations) and choose Mark as decorative (Figure 7-61).
   5. Click Drop Down N (Reservations) in the Accessibility pane. The combo box is selected.
   6. Click the drop-down list for Drop Down N (Reservations) and choose Add a description.
   7. Click the entry box in the Alt Text pane and type This is a drop-down list with the names of properties. as the text.
   8. Close the Alt Text pane and then close the Accessibility pane.
   9. Select cell A17.
4. Inspect the workbook for issues.
   1. Click the Check for Issues button [File tab, Info group] and choose Inspect Document.
   2. Select Yes to save the workbook.
   3. Click Inspect. Properties and personal information that can be removed are noted.
   4. Scroll the list to locate the Headers and Footers category. You will not remove these elements.
   5. Scroll to the top of the list and click Remove All for Document Properties and Personal Information.
   6. Click Close. Note that the workbook now has a setting to remove personal information each time it is saved (Figure 7-62).
   7. Return to the workbook.
5. Format data as a table.
   1. Click the PopUps sheet tab and select cell A4.
   2. Format the data as a table using White, Table Style Light 1.
   3. Select cell A3.
   4. Click the Save button in the title bar. This resaves the [your initials] PP E7-3 workbook.
6. Save the workbook to OneDrive.
   1. Click the File tab and select Save As.
   2. Click OneDrive – [Identifier] and then click Documents or your preferred cloud folder in the list.
   3. Edit the file name to display [your initials] PP E7-3Shared in the entry box.
   4. Click Save. The [your initials] PP E7-3 workbook is preserved in your local folder.
   5. Verify in the title bar that AutoSave is on.
7. Share the workbook.
   1. Click the Share button in the upper-right corner of the workbook window.
   2. Click the To: area and type your secondary email address. If you are working with a classmate or co-worker, type that email address.
   3. Click Message: and type Make a choice about pets. including the period.
   4. Click Send and close the confirmation window.
8. Open a shared workbook.
   1. Launch your email program and sign in to your secondary email account.
   2. Open the email message about the shared workbook and click the link. If you are working with another individual, ask them to open the email message.
   3. Click the Viewing button on the Ribbon and choose Editing.
   4. Click the Reservations sheet tab. Note that form controls are unavailable in Excel for the web.
9. Create a sheet view. You should be working in Excel for the web for this step.
   1. Select the PopUps sheet tab and select cell A5.
   2. Click the New Sheet View button [View tab, Sheet View group]. Your view is named Temporary View.
   3. Filter the data to display records for Illinois, Indiana, and Kentucky.
   4. Click the Keep Sheet View button [View tab, Sheet View group]. Your view is named View1.
   5. Click the Sheet View Options button [View tab, Sheet View group].
   6. Rename your view as ThreeStates.
10. Enter data in the shared workbook.
    1. Select cell F7, which should be the first property for Indiana.
    2. Choose No for the entry.
    3. Choose Yes for the remaining Indiana properties (Figure 7-63).
11. Enter a comment in the shared workbook.
    1. Select cell H1.
    2. Click the New Comment button [Review tab, Comments group].
    3. Type I filtered the table. in the comment box and click the Post button.
    4. Select cell A1.
    5. Close the Excel for the web window.
    6. Close your secondary email message and the email client.
12. Review work in the shared workbook.
    1. Return to your [your initials] PP E7-3Shared workbook in Excel.
    2. Select the PopUps sheet tab.
    3. Hover the pointer at cell H1 to read the comment (Figure 7-64).
    4. Click the Switch Sheet View drop-down list [View tab, Sheet View group] and choose Default.
13. Click the File tab and choose Save a Copy. Navigate to your local folder and save the workbook using the same name [your initials] PP E7-3Shared.
14. Close the workbook. It is saved by AutoSave in your OneDrive folder.