Challenge Project 7-9

In this project, you select an Excel template from the Office group and create a workbook. You explore features used in the template and edit the workbook to customize it.

[Student Learning Outcomes 7.1, 7.2, 7.3, 7.4, 7.5, 7.6]

File Needed: None

Completed Project File Name: [your initials] Excel 7-9.xlsx

Create a new workbook from one of the Excel templates in the Office category or search a topic of interest to you. Save the workbook as [your initials] Excel 7-9. Modify your workbook according to the following guidelines:

• Review sample data and formulas in the workbook.
• Determine if hidden elements (worksheets, columns, rows) are included and display them.
• Use Find & Select and Go To Special to locate data validation. If the workbook includes data validation, review the settings to make a change that makes sense for the worksheet. If validation criteria does not exist, identify a cell or range in which you can build and apply validation.
• Enter or edit sample data to test formulas and other elements in the worksheet.
• Insert a note in a blank cell to explain the purpose of the workbook. The note should be easy to see for a new user.
• Insert a check box or option button form control used to indicate that you have reviewed the sheet. Decide how to present this in the control and on the sheet.
• Inspect the workbook and remove metadata that you think can be safely removed.
• Check accessibility and add alt text or mark objects as decorative as needed.
• Check compatibility and copy the results to a new sheet.