HOSP 187 Chapter Notes - Chapter 6: Dialog Box, List Box

• School: University of Delaware
• Department: Hotel, Restaurant and Institutional Management
• Course: HOSP 187
• Professor: Zjisk

Document Summary

Styles and themes: let you create a customized collection of format settings, give that collection a name, and store it in a spreadsheet file, home styles cell styles. If you decide you need to change a style, you need just a few mouse clicks. Themes: a package of styles: font, body font, heading font, colors, 12 key colors, effects, to choose a theme, choose page layout themes themes to see a gallery of choices. The ribbon is packed with useful conditional formatting choices: home styles conditional formatting new rule. The new formatting rule dialog box is surprisingly intuitive. The format only cells that contain rule is by far the most versatile (lets you pick out specific numbers, dates, blank cells, cells with errors and so on) Two rules work well with values that change frequently: format only top or bottom ranked value, format only values that are above or below average.