If that percentage exceeds a threshold, Excel could display a red traffic light icon, indicating that the center’s performance is out of tolerance and requires attention. For example, you could create a worksheet that displays the percentage of improperly delivered packages from each regional distribution center. You might also want to specially format a cell’s contents to reflect the value in that cell. To save time, you can define a number of custom formats and then apply them quickly to the cells you want to emphasize. Changing how data appears on a worksheet helps set the contents of a cell apart from the contents of surrounding cells.
Microsoft Excel 2016 gives you a wide variety of ways to make your data easier to understand for example, you can change the font, character size, or color used to present a cell’s contents. For practice file download instructions, see the introduction.Įntering data into a workbook efficiently saves you time, but you must also ensure that your data is easy to read.
For this chapter, use the practice files from the Excel2016SBS\Ch04 folder.