Chapter Demonstrable Skills
After completing the Excel Chapter 12 portion of the Excel & Data Analysis unit, students will be able to:
| Demonstrable Skill | Learning Activities & Informal Assessments |
Formal Assessments (excluding Exams) |
|---|---|---|
| Apply cell styles to provide consistent formatting. |
|
|
Chapter Notes
Cell styles
A cell style is a collection of format settings based on the current theme to provide a consistent appearance within a worksheet and among similar workbooks [1]. You can add cell styles in the Styles group on the Home tab. Cell Styles also uses Live Preview, so placing the pointer on a cell style in the gallery shows what the cell will look like with that cell style applied.
Cell styles control the following formats:
- Font attributes, such as font and font size.
- Borders and fill styles and colors.
- Vertical and horizontal cell alignment.
- Number formatting, such as currency and number of decimal places
- Cell-protection settings.
NOTE:Don't confuse cell styles with table styles!
Protecting sheets and workbooks
If you are collaborating with others, protecting a worksheet might be desirable [1]. For example, you might not want other users to change rates (tax) that are fixed. When a worksheet is protected, users cannot alter locked cells. After a worksheet is protected, most commands on the Ribbon are dimmed, indicating that they are not available. Part of the process of protecting a worksheet, is entering a password so that only those who know the password can unprotect the worksheet. As noted in the Protect Sheet dialog box, do not forget your password. Protecting a worksheet prevents unauthorized modifications of the worksheet, but users can make changes to other parts of the workbook. To prevent users from making unwanted changes, the entire workbook can be protected with a password. We can protect a workbook by electing Protect Workbook in the Changes group on the Review tab
References
- A. Poatsy, K. Mulberry, C. Krebs, L. Hogan, A. Rutledge, and E. Cameron, Exploring Microsoft Office 2013, 1st ed., vol. 2. Upper Saddle River, NJ: Pearson Education, 2013.