Problem: Using the functions learned in the eText Excel Module 12. Be detailed in your explanation.
Using the Internet, conduct a thorough search for more information on developing Excel applications such as creating WordArt graphics, validating data entry, protecting a worksheet, etc. Choose one bullet listed below and explain what this formatting does and how it can be used in your chosen career field. Feel free to also discuss how this can be used throughout your academic endeavors.
Session 1
- Create WordArt graphic
- Plot data with a funnel chart
- Hide error values with the IFERROR function
Session 2
- Validate data entry
- Hide worksheet rows and columns
- Hide worksheets
- Protect worksheets and workbooks from edits
- Unlock worksheets cells to allow edits