Question

----helps to enhance the overall look of a worksheet​

Answer 1

Answer:

Entering data into a workbook efficiently saves you time, but you must also ensure that your data is easy to read. 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. Changing how data appears on a worksheet helps set the contents of a cell apart from the contents of surrounding cells. To save time, you can define a number of custom formats and then apply them quickly to the cells you want to emphasize.

You might also want to specially format a cell’s contents to reflect the value in that cell. For example, you could create a worksheet that displays the percentage of improperly delivered packages from each regional distribution center. 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.

This chapter guides you through procedures related to changing the appearance of data, applying existing formats to data, making numbers easier to read, changing data’s appearance based on its value, and adding images to worksheets.

Format cells

Excel worksheets can hold and process lots of data, but when you manage numerous worksheets, it can be hard to remember from a worksheet’s title exactly what data is kept in that worksheet. Data labels give you and your colleagues information about data in a worksheet, but it’s important to format the labels so that they stand out visually. To make your data labels or any other data stand out, you can change the format of the cells that hold your data.Many of the formatting-related buttons on the ribbon have arrows at their right edges. Clicking the arrow displays a list of options for that button, such as the fonts available on your system or the colors you can assign to a cell.You can also make a cell stand apart from its neighbors by adding a border around the cell or changing the color or shading of the cell’s interior.