Unit 1: Formatting Spreadsheets
When making a spreadsheet, it is important to use formatting techniques to improve readability for the user. We use formatting tools to highlight information we want to emphasize and clearly organize large amounts of data. In this unit, we discuss how to format cells, text, numbers, and dates in depth. We also introduce conditional formatting tools to format text and numbers based on specific criteria or conditions.
Completing this unit should take you approximately 1 hour.
1.1: Formatting Cells and Numbers
In this section, we discuss methods of formatting the contents of cells and numerical values in spreadsheets. This is particularly important when sharing a spreadsheet with other users. All users must be able to locate data within a spreadsheet easily.
1.2: Formatting Worksheet Tabs
Often, one workbook will have multiple worksheets, each with different data and calculations. It is important to keep track of what each worksheet represents in an organized and manageable way. You can accomplish this by formatting the tabs at the bottom of the workbook representing the different worksheets.
1.3: Conditional Formatting
Conditional formatting lets you apply formatting, such as using a different font, color, or bolding, to cells in a spreadsheet based on their value. This can be useful for observing trends in data.
For example, you may be recording the daily temperature in a worksheet. You can use conditional formatting to change the font color for all the days that were above the freezing point. This way, you can easily visualize dates when the temperature was above a certain limit.
You can also use conditional formatting to find errors in large data sets. It is hard to scroll through a large set of data to find an error. But, you can use conditional formatting to highlight cells that have mistakes.
For example, imagine you are recording your weekly income in a spreadsheet. At the end of the year, you notice the total does not match what you expect. You can use conditional formatting to highlight any cells that are outside of your expected range of income. This allows you to quickly and easily see if you accidentally mistyped one week's income entry.