Excel.02 - COMPREHENSIVE Excel Tutorial 2 Formatting a...

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

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: COMPREHENSIVE Excel Tutorial 2 Formatting a Workbook XP XP Objectives • Format text, numbers, and dates • Change font colors and fill colors • Merge a range into a single cell • Apply a built-in cell style • Select a different theme New Perspectives on Microsoft Office Excel 2007 2 XP XP Objectives • Apply a built-in table style • Add conditional formats to tables with highlight rules and data bars • Hide worksheet rows • Insert print titles, set print areas, and insert page breaks • Enter headers and footers New Perspectives on Microsoft Office Excel 2007 3 XP XP Formatting Workbooks • Formatting is the process of changing a workbook’s appearance by defining the fonts, styles, colors, and decorative features • A theme is a collection of formatting that specifies the fonts, colors, and graphical effects used throughout the workbook • As you work, Live Preview shows the effects of formatting options on the workbook’s appearance before you apply them New Perspectives on Microsoft Office Excel 2007 4 XP XP Formatting Text • The appearance of text is determined by its typeface , which is the specific design used for the characters – Font • Serif fonts • Sans serif fonts • Theme font • Non-theme font – Font Style – Font Size • Measured in points New Perspectives on Microsoft Office Excel 2007 5 XP XP Working with Color • Theme colors are the 12 colors that belong to the workbook’s theme • Standard and custom colors • Apply a color by selecting a cell or range of cells, clicking the Font Color or Fill Color button arrow, and then selecting an appropriate color New Perspectives on Microsoft Office Excel 2007 6 XP XP Formatting Text Selections • The Mini toolbar appears when you select text and contains buttons for commonly used text formats New Perspectives on Microsoft Office Excel 2007 7 XP XP Setting a Background Image • You can use a picture or image as the background for all the cells in a worksheet • Click the Page Layout tab on the Ribbon • Click the Background button • Locate the background, and then click the Insert button New Perspectives on Microsoft Office Excel 2007 8 XP XP Formatting Data • By default, values appear in the General number format , which, for the most part, displays numbers exactly as you enter them • The Number group on the Home tab has buttons for formatting the appearance of numbers • Comma style button • Decrease Decimal button • Percent Style button • Increase Decimal button • Accounting Number Format button New Perspectives on Microsoft Office Excel 2007 9 XP XP Formatting Data New Perspectives on Microsoft Office Excel 2007 10 XP...
View Full Document

{[ snackBarMessage ]}

Page1 / 40

Excel.02 - COMPREHENSIVE Excel Tutorial 2 Formatting a...

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online