350 likes | 467 Views
Excel 2007 ® Business and Personal Finances. How can Excel 2007 help you format a workbook?. Lesson 3: Format Data and Content. Excel 2007 provides many different tools to format the data and overall look of a spreadsheet. Lesson 3: Format Data and Content.
E N D
Excel 2007® Business and Personal Finances How can Excel 2007 help you format a workbook?
Lesson 3: Format Data and Content Excel 2007 provides many different tools to format the data and overall look of a spreadsheet.
Lesson 3: Format Data and Content View This Presentation to Answer the Following Questions: • How can I change fonts and font styles? • How can I apply a border? • How do I convert text to columns? • How do I make sure cells are consistently formatted? • How do I modify the size of rows and columns? • Why change horizontal and vertical alignment? • What vocabulary words should I review?
1. Lesson 3: Format Data and Content Choose the right font to make your worksheet more readable. The font is the “look” of the characters. A fontstyle is a trait such as bold, italic, or underline.
2. Lesson 3: Format Data and Content To change a font or font style, use the Format group or launch the Format Cells dialog box.
Lesson 3: Format Data and Content You might use different font colors for totals to make them distinct. You can change the font color of text and numbers.
3. Lesson 3: Format Data and Content To change font color, use the Format menu or the Formattingtoolbar. You can also copy a font color from one cell to another without changing any of the data.
4. Lesson 3: Format Data and Content Click the Borders button drop-down arrow to apply a border to the edges of a cell. A border is a line along one or more edges of a cell. Applying a border to a cell or groups of cells, makes information easier and quicker to find.
5. Lesson 3: Format Data and Content To apply a border around certain cells and not around others, change the settings to copy the text without copying the border. Use the Paste Special dialog box to control which information is pasted into a new cell.
Lesson 3: Format Data and Content Academic Skills Check How can you ensure readability in a worksheet? Answer: Choosing the right font can help ensure readability in a worksheet.
Lesson 3: Format Data and Content Tech Check How do you change font color in a worksheet? Answer: Use the Format menu or the Formatting toolbar to change font color.
Lesson 3: Format Data and Content Tech Check How do you copy text without copying the border in a worksheet? Answer: Use the Paste Special dialog box to copy text without copying the border in a worksheet.
6. Lesson 3: Format Data and Content To make many changes to a group of data in one step, use the Convert Text to Columns Wizard. Excel makes use of a delimiter, or divider, to separate the text. The Convert Text to Columns Wizard separates the content of a cell, such as a list of first names and last names, into different columns.
7. Lesson 3: Format Data and Content To make sure cells are consistently formatted, use themes, table styles, and cell styles. A theme is a predefined set of colors, fonts, and effects you can apply to an entire workbook. Microsoft Office Excel 2007 has 16 built-in themes that you can apply or modify to create your own.
8. Lesson 3: Format Data and Content To apply a table style, or predefined set of formats, to a range of data, use the Format as Table command. Themes and table styles save time by making formatting changes, such as adding borders and changing font colors, in one step.
9. Lesson 3: Format Data and Content A cell style is a set of formatting traits that has been given a name. When you apply a cell style, you apply all of the formatting traits of that style.
10. Lesson 3: Format Data and Content Microsoft Office 2007 has several built-in cell styles, called Quick Styles. Quick Styles allow you to change the look of a group of data—such as applying currency or percentages—in one quick step.
Lesson 3: Format Data and Content Tech Check How can you make many changes to a group of data in one step? Answer: Use the Convert Text to Columns function to make many changes to a group of data in one step.
Lesson 3: Format Data and Content Tech Check How can using themes and table styles help you save time in formatting a worksheet? Answer: Themes and table styles save time by making formatting changes, such as adding borders and changing font colors, in one step.
11. Lesson 3: Format Data and Content Excel 2007 offers several ways to change the size of rows and columns. To change column width, drag the line between the column headings and double-click the line between the column headings to AutoFit them. You can also use the Format menu to adjust column width using a specified value.
12. Lesson 3: Format Data and Content To change the row height… Drag the line between row headings or use the Formatmenu.
13. Lesson 3: Format Data and Content To center text across a range of cells… use the Center Across Selection feature.
14. Lesson 3: Format Data and Content Change the horizontalalignmentto align the contents of a cell to the left, center, or right. To change the alignment of a cell’s contents, use the Format Cells dialog box or the buttons in the Alignment group on the Home tab.
15. Lesson 3: Format Data and Content Change the vertical alignment to position the contents of a cell in relation to the top and bottom of the cell. To change the verticalalignment of a cell’s contents, use the Format Cells dialog box.
Lesson 3: Format Data and Content Tech Check How can you adjust column width? Answer: To adjust column width, drag the line between the column headings, double-click the line between the column headings to AutoFit them, or use the Format menu.
Lesson 3: Format Data and Content Tech Check How do you change the vertical alignment of a cell’s contents? Answer: Use the Format Cells dialog box to change the vertical alignment of a cell’s contents.
Lesson 3: Format Data and Content Tech Check How do you center text across a range of cells? Answer: To center text across a range of cells, use Center Across Selection.
Lesson 3: Format Data and Content Vocabulary Review font The overall design of a full set of characters. Also known as typeface.
Lesson 3: Format Data and Content Vocabulary Review font style An effect that can be applied to a font, such as bold, italic, or underline.
Lesson 3: Format Data and Content Vocabulary Review border A line or box that frames text or a cell.
Lesson 3: Format Data and Content Vocabulary Review delimiter A divider that separates text.
Lesson 3: Format Data and Content Vocabulary Review theme A collection of design elements, graphics, and colors that help items such as documents, presentations, and Web pages maintain a consistent image.
Lesson 3: Format Data and Content Vocabulary Review cell style A set of formatting traits that has been given a name.
Lesson 3: Format Data and Content Vocabulary Review table style A pre-defined set of formats that can be applied to a range of data.