office 2003 introductory concepts and techniques m i c r o s o f t chapter 6 excel project 1...
TRANSCRIPT
![Page 1: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/1.jpg)
Office 2003Introductory Concepts
and Techniques
M i c r o s o f t
Chapter 6Excel Project 1
Creating a Worksheet and an Embedded Chart
![Page 2: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/2.jpg)
2Excel Project 1: Creating a Worksheet and an Embedded Chart
Objectives
• Start and Quit Excel
• Describe the Excel worksheet
• Enter text and numbers
• Use the AutoSum button to sum a range of cells
• Copy a cell to a range of cells using the fill handle
![Page 3: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/3.jpg)
3Excel Project 1: Creating a Worksheet and an Embedded Chart
Objectives
• Copy a cell to a range of cells using the fill handle
• Format a worksheet
• Create a 3-D Clustered column chart
• Save a workbook and print a worksheet
![Page 4: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/4.jpg)
4Excel Project 1: Creating a Worksheet and an Embedded Chart
Objectives
• Open a workbook
• Use the AutoCalculate area to determine statistics
• Correct errors on a worksheet
• Use the Excel Help system to answer questions
![Page 5: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/5.jpg)
5Excel Project 1: Creating a Worksheet and an Embedded Chart
Starting Excel
• Click the Start button on the Windows taskbar, point to All Programs on the Start menu, point to Microsoft Office on the All Programs submenu, and then point to Microsoft Office Excel 2003 on the Microsoft Office submenu
• Click Microsoft Office Excel 2003• If the Excel window is not maximized,
double-click its title bar to maximize it
![Page 6: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/6.jpg)
6Excel Project 1: Creating a Worksheet and an Embedded Chart
Starting Excel
![Page 7: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/7.jpg)
7Excel Project 1: Creating a Worksheet and an Embedded Chart
Customizing the Excel Window
• Right-click the Language bar
• Click Close the Language bar
• Click the Getting Started task pane Close button in the upper-right corner of the task pane
• If the toolbars are positioned on the same row, click the Toolbar Options button
• Click Show Buttons on Two Rows
![Page 8: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/8.jpg)
8Excel Project 1: Creating a Worksheet and an Embedded Chart
Customizing the Excel Window
![Page 9: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/9.jpg)
9Excel Project 1: Creating a Worksheet and an Embedded Chart
Entering the Worksheet Titles
• Click cell A1
• Type Extreme Blading in cell A1 and then point to the Enter box in the formula bar
• Click the Enter box to complete the entry
• Click cell A2 to select it. Type Second Quarter Sales as the cell entry. Click the Enter box to complete the entry
![Page 10: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/10.jpg)
10Excel Project 1: Creating a Worksheet and an Embedded Chart
Entering the Worksheet Titles
![Page 11: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/11.jpg)
11Excel Project 1: Creating a Worksheet and an Embedded Chart
Entering Column Titles
• Click cell B3
• Type Direct Mail in cell B3
• Press the RIGHT ARROW key
• Repeat the last two steps for the remaining column titles in row 3, as shown on the following slide
![Page 12: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/12.jpg)
12Excel Project 1: Creating a Worksheet and an Embedded Chart
Entering Column Titles
![Page 13: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/13.jpg)
13Excel Project 1: Creating a Worksheet and an Embedded Chart
Entering Row Titles
• Click cell A4. Type Inline Skates and then press the DOWN ARROW key
• Repeat the previous step for the remaining row titles in column A, as shown on the following slide
![Page 14: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/14.jpg)
14Excel Project 1: Creating a Worksheet and an Embedded Chart
Entering Row Titles
![Page 15: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/15.jpg)
15Excel Project 1: Creating a Worksheet and an Embedded Chart
Entering Numbers
• Click cell B4• Type 58835.35 and then press the RIGHT
ARROW key• Enter 97762.50 in cell C4, 71913.73 in cell
D4, and 85367.37 in cell E4• Click cell B5• Enter the remaining fourth quarter sales
provided on the next slide for each of the three remaining product groups in rows 5, 6, and 7
![Page 16: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/16.jpg)
16Excel Project 1: Creating a Worksheet and an Embedded Chart
Entering Numbers
![Page 17: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/17.jpg)
17Excel Project 1: Creating a Worksheet and an Embedded Chart
Summing a Column of Numbers
• Click cell B8• Click the AutoSum
button on the Standard toolbar
• Click the AutoSum button a second time
![Page 18: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/18.jpg)
18Excel Project 1: Creating a Worksheet and an Embedded Chart
Copying a Cell to Adjacent Cells in a Row• With cell B8 active,
point to the fill handle• Drag the fill handle to
select the destination area, range C8:E8
• Release the mouse button
![Page 19: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/19.jpg)
19Excel Project 1: Creating a Worksheet and an Embedded Chart
Determining Multiple Totals at the Same Time• Click cell F4
• With the mouse pointer in cell F4 and in the shape of a block plus sign, drag the mouse pointer down to cell F8
• Click the AutoSum button on the Standard toolbar
• Select cell A9 to deselect the range F4:F8
![Page 20: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/20.jpg)
20Excel Project 1: Creating a Worksheet and an Embedded Chart
Determining Multiple Totals at the Same Time
![Page 21: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/21.jpg)
21Excel Project 1: Creating a Worksheet and an Embedded Chart
Changing the Font Type
• Click cell A1 and then point to the Font box arrow on the Formatting toolbar
• Click the Font box arrow and then point to Arial Rounded MT Bold
• Click Arial Rounded MT Bold
![Page 22: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/22.jpg)
22Excel Project 1: Creating a Worksheet and an Embedded Chart
Changing the Font Type
![Page 23: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/23.jpg)
23Excel Project 1: Creating a Worksheet and an Embedded Chart
Bolding a Cell
• With cell A1 active, click the Bold button on the Formatting toolbar
![Page 24: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/24.jpg)
24Excel Project 1: Creating a Worksheet and an Embedded Chart
Increasing the Font Size of a Cell Entry• With cell A1 selected,
click the Font Size box arrow on the Formatting toolbar
• Click 24 in the Font Size list
![Page 25: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/25.jpg)
25Excel Project 1: Creating a Worksheet and an Embedded Chart
Changing the Font Color of a Cell Entry• With cell A1 selected,
click the Font Color button arrow on the Formatting toolbar
• Click Violet (column 7, row 3) on the Font Color palette
![Page 26: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/26.jpg)
26Excel Project 1: Creating a Worksheet and an Embedded Chart
Centering a Cell Entry across Columns by Merging Cells• With cell A1 selected,
drag to cell F1• Click the Merge and
Center button on the Formatting toolbar
![Page 27: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/27.jpg)
27Excel Project 1: Creating a Worksheet and an Embedded Chart
Formatting the Worksheet Subtitle
• Select cell A2• Click the Font box arrow on the Formatting
toolbar and then click Arial Rounded MT Bold• Click the Bold button on the Formatting toolbar• Click the Font Size box arrow on the Formatting
toolbar and then click 16• Click the Font Color button on the Formatting
toolbar
![Page 28: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/28.jpg)
28Excel Project 1: Creating a Worksheet and an Embedded Chart
Formatting the Worksheet Subtitle
• Select the range A2:F2 and then click the Merge and Center button on the Formatting toolbar
![Page 29: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/29.jpg)
29Excel Project 1: Creating a Worksheet and an Embedded Chart
Using AutoFormat to Format the Body of a Worksheet• Select cell A3, the upper-left corner cell of
the rectangular range to format• Drag the mouse pointer to cell F8, the
lower-right corner cell of the range to format
• Click Format on the menu bar• Click AutoFormat on the Format menu• When Excel displays the AutoFormat
dialog box, click the Accounting 2 format
![Page 30: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/30.jpg)
30Excel Project 1: Creating a Worksheet and an Embedded Chart
Using AutoFormat to Format the Body of a Worksheet• Click the OK button• Select cell A10 to
deselect the range A3:F8
![Page 31: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/31.jpg)
31Excel Project 1: Creating a Worksheet and an Embedded Chart
Using the Name Box to Select a Cell• Click the Name box in
the formula bar and then type a3 as the cell to select
• Press the ENTER key
![Page 32: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/32.jpg)
32Excel Project 1: Creating a Worksheet and an Embedded Chart
![Page 33: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/33.jpg)
33Excel Project 1: Creating a Worksheet and an Embedded Chart
Adding a 3-D Clustered Column Chart to the Worksheet• With cell A3 selected, position the block plus sign mouse
pointer within the cell’s border and drag the mouse pointer to the lower-right corner cell (cell E7) of the range to chart (A3:E7
• Click the Chart Wizard button on the Standard toolbar• When Excel displays the Chart Wizard – Step 1 of 4 –
Chart Type dialog box and with Column selected in the Chart style list, click Clustered column with a 3-D visual effect (column 1, row 2) in the Chart sub-type area
• Click the Finish button• If the Chart toolbar appears, click its Close button
![Page 34: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/34.jpg)
34Excel Project 1: Creating a Worksheet and an Embedded Chart
Adding a 3-D Clustered Column Chart to the Worksheet• When Excel displays the chart, point to an open
area in the lower-right section of the chart area so the ScreenTip, Chart Area, appears next to the mouse pointer
• Drag the chart down and to the left to position the upper-left corner of the dotted line rectangle over the upper-left corner of cell A10
• Release the mouse button• Point to the middle sizing handle on the right
edge of the selection rectangle
![Page 35: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/35.jpg)
35Excel Project 1: Creating a Worksheet and an Embedded Chart
Adding a 3-D Clustered Column Chart to the Worksheet• While holding down the ALT key, drag the
sizing handle to the right edge of column F
• If necessary, hold down the ALT key and drag the lower-middle sizing handle down to the bottom border of row 20
• Click cell H20 to deselect the chart
![Page 36: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/36.jpg)
36Excel Project 1: Creating a Worksheet and an Embedded Chart
Adding a 3-D Clustered Column Chart to the Worksheet
![Page 37: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/37.jpg)
37Excel Project 1: Creating a Worksheet and an Embedded Chart
Saving a Workbook
• Click the Save button on the Standard toolbar
• Type Extreme Blading 2nd Quarter Sales in the File name box
• Click the Save in box arrow
• Click USB flash drive in the Save in list
• Click the Save button in the Save As dialog box
![Page 38: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/38.jpg)
38Excel Project 1: Creating a Worksheet and an Embedded Chart
Saving a Workbook
![Page 39: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/39.jpg)
39Excel Project 1: Creating a Worksheet and an Embedded Chart
Printing a Worksheet
• Ready the printer according to the printer instructions and then click the Print button on the Standard toolbar
• When the printer stops printing the worksheet and the chart, retrieve the printout
![Page 40: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/40.jpg)
40Excel Project 1: Creating a Worksheet and an Embedded Chart
Quitting Excel
• Point to the Close button on the right side of the title bar
• Click the Close button• Click the No button
![Page 41: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/41.jpg)
41Excel Project 1: Creating a Worksheet and an Embedded Chart
Starting Excel and Opening a Workbook• With your USB flash drive connected, click the
Start button on the Windows taskbar, point to All Programs on the Start menu, point to Microsoft Office on the All Programs submenu, and then click Microsoft Office Excel 2003 on the Microsoft Office submenu
• Click Extreme Blading 2nd Quarter Sales in the Open area in the Getting Started task pane
![Page 42: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/42.jpg)
42Excel Project 1: Creating a Worksheet and an Embedded Chart
Starting Excel and Opening a Workbook
![Page 43: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/43.jpg)
43Excel Project 1: Creating a Worksheet and an Embedded Chart
Using the AutoCalculate Area to Determine an Average• Select the range B6:E6 and then right-click
the AutoCalculate area on the status bar
• Click Average on the shortcut menu
• Right-click the AutoCalculate area and then click Sum on the shortcut menu
![Page 44: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/44.jpg)
44Excel Project 1: Creating a Worksheet and an Embedded Chart
Using the AutoCalculate Area to Determine an Average
![Page 45: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/45.jpg)
45Excel Project 1: Creating a Worksheet and an Embedded Chart
Clearing Cell Contents
• Fill Handle– Select the cell or range of cells and point to the fill
handle so the mouse pointer changes to a cross hair– Drag the fill handle back into the selected cell or
range until a shadow covers the cell or cells you want to erase. Release the mouse button
• Shortcut Menu– Select the cell or range of cells to be cleared– Right-click the selection– Click Clear Contents on the shortcut menu
![Page 46: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/46.jpg)
46Excel Project 1: Creating a Worksheet and an Embedded Chart
Clearing Cell Contents
• Delete Key– Select the cell or range of cells to be cleared– Press the DELETE key
• Clear Command– Select the cell or range of cells to be cleared– Click Edit on the menu bar and then point to
Clear– Click All on the Clear submenu
![Page 47: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/47.jpg)
47Excel Project 1: Creating a Worksheet and an Embedded Chart
Clearing the Entire Worksheet
• Click the Select All button on the worksheet
• Press the DELETE key or click Edit on the menu bar, point to Clear and then click All on the Clear submenu
![Page 48: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/48.jpg)
48Excel Project 1: Creating a Worksheet and an Embedded Chart
Deleting an Embedded Chart
• Click the chart to select it
• Press the DELETE key
![Page 49: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/49.jpg)
49Excel Project 1: Creating a Worksheet and an Embedded Chart
Obtaining Help Using the Type a Question for Help Box
• Type save a workbook in the Type a Question for help box on the right side of the menu bar
• Press the ENTER key• When Excel displays the Search Results task pane,
scroll down and then click the link Save a file• If necessary, click the AutoTile button to tile the windows• Click the Show All link on the right side of the Microsoft
Excel Help window to expand the links in the window
![Page 50: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/50.jpg)
50Excel Project 1: Creating a Worksheet and an Embedded Chart
Obtaining Help Using the Type a Question for Help Box
• Double-click the Microsoft Excel Help title bar to maximize it
• Click the Close button on the Microsoft Excel Help window title bar
![Page 51: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/51.jpg)
51Excel Project 1: Creating a Worksheet and an Embedded Chart
Obtaining Help Using the Type a Question for Help Box
![Page 52: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/52.jpg)
52Excel Project 1: Creating a Worksheet and an Embedded Chart
Quitting Excel
• Click the Close button on the right side of the title bar, and if necessary, click the No button in the Microsoft Excel dialog box
![Page 53: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/53.jpg)
53Excel Project 1: Creating a Worksheet and an Embedded Chart
Summary
• Start and Quit Excel
• Describe the Excel worksheet
• Enter text and numbers
• Use the AutoSum button to sum a range of cells
• Copy a cell to a range of cells using the fill handle
![Page 54: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/54.jpg)
54Excel Project 1: Creating a Worksheet and an Embedded Chart
Summary
• Copy a cell to a range of cells using the fill handle
• Format a worksheet
• Create a 3-D Clustered column chart
• Save a workbook and print a worksheet
![Page 55: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/55.jpg)
55Excel Project 1: Creating a Worksheet and an Embedded Chart
Summary
• Open a workbook
• Use the AutoCalculate area to determine statistics
• Correct errors on a worksheet
• Use the Excel Help system to answer questions
![Page 56: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/56.jpg)
56Excel Project 1: Creating a Worksheet and an Embedded Chart
Lab #5
• Date: 9-19 & 9/20
• Excel Project 1
• Pages EX7 - EX54
![Page 57: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/57.jpg)
57Excel Project 1: Creating a Worksheet and an Embedded Chart
Lab #6• Date: 9/21 (CS200-02) 9/25 (CS200-01)• College Cash Flow Analysis Worksheet
• Pages EX61 – EX62
![Page 58: Office 2003 Introductory Concepts and Techniques M i c r o s o f t Chapter 6 Excel Project 1 Creating a Worksheet and an Embedded Chart](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f1b5503460f94c30655/html5/thumbnails/58.jpg)
58Excel Project 1: Creating a Worksheet and an Embedded Chart
Chapter 6 Homework
• Due: CS200-01: 9/25/2006
CS200-02: 9/26/2006
• Do the following questions:– Learn It Online on page EX56 :
• 1 (Project Reinforcement): All 30 questions.• 3 (Practice Test): All 20 questions. Show V and X
marks, otherwise there is a 5 points penalty.
– In-the-Lab 2 (Annual Business Expense Analysis Worksheet) on pages EX59-EX61.