Excel.02 - XP XP COMPREHENSIVE Excel Tutorial 2 XP XP New...

Info iconThis preview shows pages 1–12. 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 DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: XP XP COMPREHENSIVE Excel Tutorial 2 XP XP New Perspectives on Microsoft Office Excel 2007 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 22 XP XP New Perspectives on Microsoft Office Excel 2007 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 33 XP XP New Perspectives on Microsoft Office Excel 2007 Formatting Workbooks Formatting is the process of changing a workbooks 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 New Perspectives on Microsoft Office Excel 2007 44 XP XP New Perspectives on Microsoft Office Excel 2007 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 New Perspectives on Microsoft Office Excel 2007 55 XP XP New Perspectives on Microsoft Office Excel 2007 Working with Color Theme colors are the 12 colors that belong to the workbooks 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 66 XP XP New Perspectives on Microsoft Office Excel 2007 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 77 XP XP New Perspectives on Microsoft Office Excel 2007 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 88 XP XP New Perspectives on Microsoft Office Excel 2007 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 New Perspectives on Microsoft Office Excel 2007 99 XP XP New Perspectives on Microsoft Office Excel 2007 Formatting Data New Perspectives on Microsoft Office Excel 2007 10 XP XP New Perspectives on Microsoft Office Excel 2007...
View Full Document

Page1 / 40

Excel.02 - XP XP COMPREHENSIVE Excel Tutorial 2 XP XP New...

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

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