ExcelChapter5 - Microsoft Office 2007 Excel Chapter 5...

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

View Full Document Right Arrow Icon
Microsoft Office 2007 Excel Chapter 5 Creating, Sorting and Querying a Table
Background image of page 1

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

View Full DocumentRight Arrow Icon
Objectives Create and manipulate a table Delete sheets in a workbook Validate data Add calculated columns to a table Use icon sets with conditional formatting Use the VLOOKUP function to look up a value in a table Print a table Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 2
Background image of page 2
Objectives Add and delete records and change field values in a table Sort a table on one field or multiple fields Display automatic subtotals Use Group and Outline features to hide and unhide data Query a table Apply database functions, the SUMIF function, and the COUNTIF function Save a workbook in different file formats Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 3
Background image of page 3

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

View Full DocumentRight Arrow Icon
Plan Ahead Create and format the sales rep table. Sort the sales rep table. Display subtotals by grouping the sales reps. Obtain answers to questions (queries) about the sales reps using a variety of methods to query the sales rep table Extract records from the table based on given criteria Save the worksheet in different fi le formats Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 4
Background image of page 4
Starting Excel Start Excel based on a typical installation of Microsoft Office on your computer or see instructions on page EX 343 Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 5
Background image of page 5

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

View Full DocumentRight Arrow Icon
Entering the Column Headings for a Table Use the mouse to change the column widths as follows: A = 16.43, B = 11.57, C = 8.29, D = 13.14, E = 9.43, F = 14.00, G = 13.29, H = 13.29, I = 14.57, and J = 10.29 Enter Silver Photography Accessories Sales Rep Table as the table title in cell A7 Apply the Title cell style to cell A7. Click the Font Color button on the Home tab on the Ribbon and then click Red, Accent 2 (column 6 row 1) on the Font Color palette Select the range A7:H7. Right-click the selected range and then click Format Cells on the shortcut menu. When Excel displays the Format Cells dialog box, if necessary, click the Alignment tab, click the Horizontal box arrow in the Text alignment area, click Center Across Selection in the Horizontal list, and then click the OK button Enter the column headings in row 8 as shown in Figure 5–4. Center the column headings in the range B8:H8 Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 6
Background image of page 6
Entering the Column Headings for a Table Apply the Heading 3 cell style to the range A8:H8 Double-click the Sheet1 tab at the bottom of the screen. Type Sales Rep Table as the sheet name. Press the ENTER key. Right- click the tab, point to Tab Color on the shortcut menu, and then click Red, Accent 2 (column 6, row 1) Click the Sheet2 tab, hold down the CTRL key, and then click the Sheet3 tab. Right-click the selected sheet tabs and then click Delete on the shortcut menu to delete the selected sheets from the workbook
Background image of page 7

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

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

Page1 / 87

ExcelChapter5 - Microsoft Office 2007 Excel Chapter 5...

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

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