Skip to main content

Excel Chapter 12

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.
  • Excel: Formatting Participation Project
  • MyLab Lesson A
  • Homework #1
  • Homework #2
  • Homework #3
  • MyLab Lesson A
  • MyLab Bonus Project #1
Protect spreadsheets from changes.
  • MyLab Lesson B
  • MyLab Lesson B

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

  1. 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.