2010 13 xp formatting calculated valuesxp applying

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: t, and divide values New Perspectives on Microsoft Excel 2010 13 XP Formatting Calculated ValuesXP • Applying number formats – Use General number format for simple calculations – Apply Excel’s additional formatting to make numbers easier to interpret • Accounting style – Lines up currency values within a column by currency symbol and decimal point – Encloses negative numbers within parentheses New Perspectives on Microsoft Excel 2010 14 Applying Number Formats New Perspectives on Microsoft Excel 2010 XP XP 15 Applying Number Formats New Perspectives on Microsoft Excel 2010 XP XP 16 XP Formatting Calculated ValuesXP • Formatting dates and times – Dates/times are stored as numbers, not as text • Applying different formats does not affect values • Makes it easier to calculate time intervals – Short Date format or Long Date format – 12- or 24-hour time New Perspectives on Microsoft Excel 2010 17 Formatting Worksheet Cells • XP XP Format appearance of individual cells by: – Modifying alignment of text within the cell – Indenting cell text – Adding borders of different styles and colors to individual cells or ranges New Perspectives on Microsoft Excel 2010 18 Formatting Worksheet Cells • XP XP Aligning cell content – Default: • Cell text aligned with left bottom borders • Cell values aligned with right bottom borders – Buttons to set alignment options are in Alignment group on Home tab New Perspectives on Microsoft Excel 2010 19 Formatting Worksheet Cells • XP XP Indenting cell content – Useful for entries considered subsections of a worksheet New Perspectives on Microsoft Excel 2010 20 Formatting Worksheet Cells • XP XP Merging cells – Retains only content (and cell reference) from upper-left cell in the range – Merge options: Merge & Center, Merge Across, Merge Cell, and Unmerge Cells New Perspectives on Microsoft Excel 2010 21 Formatting Worksheet Cells • XP XP Rotating cell contents saves space and provides visual interest New Perspectives on Microsoft Excel 2010 22 Formatting Worksheet Cells • XP XP Adding cell borders enhances readability of rows and columns or data – Add borders to left, top, right, or bottom of cell or range; around an entire cell; or around outside edges of a range – Specify thickness and number of lines in border New Perspectives on Microsoft Excel 2010 23 Options in the Format Cells Dialog Box XP XP Presents formats available from Home tab in a different way and prov...
View Full Document

Ask a homework question - tutors are online