{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# ExcelChapter5 - Microsoft Office 2007 Excel Chapter 5...

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

Microsoft Office 2007 Excel Chapter 5 Creating, Sorting and Querying a Table

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

View Full Document
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 Edition 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 Edition 3

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

View Full Document
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 Edition 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 Edition 5

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

View Full Document
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 Edition 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 Update the document properties with your name and any other relevant information

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

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

{[ snackBarMessage ]}