SMS221 Lecture 2: NP Excel M02
Document Summary
Formatting text selections: the mini toolbar contains buttons for common formatting options used for the selection. Working with fill colors and backgrounds: fill colors can be helpful for distinguishing different parts of a worksheet or adding visual interest. Using functions and formulas to calculate sales data. Formatting numbers: goal: make workbook easier to interpret, accomplished by, adding a comma as a thousands separator, setting the number of decimal places, using percentage and currency symbols. Applying number formats: excel supports two monetary formats, currency format. Places a currency symbol left of the first digit. Displays negative numbers with a negative sign: accounting format. Fixes a currency symbol at the left edge of the column. Slightly indents values from the right edge. Formatting worksheet cells: format appearance of individual cells by, modifying alignment of text within the cell, indenting cell text, adding borders of different styles and colors.
