Grauer and Barber Series Microsoft Excel Chapter Two

1. Grauer and Barber Series Microsoft Excel Chapter Two Microsoft Excel

2. Cell Ranges • Cell Ranges can be • Single cell A1 • Group of cells containing rows A1:C1 • Group of cells containing columns A1:A5 • Group of cells containing rows and columns A1:C5 • Entire spreadsheet • Click to a single cell as the range • Click and drag to select a group of cells as the range Microsoft Excel

3. Copy Command • Use the copy command to duplicate contents • Cells to copy are called source range • Cells to copy to are called the destination range • Different ways to copy include • Edit copy and Edit Paste commands • Autofill handle + • Edit fill command • Drag-and-Drop using CTRL • Uses the clipboard to hold copied information Microsoft Excel

4. Relative, Absolute, and Mixed Cells • Relative cells adjust to row and column copy locations (default) • Absolute Cell reference maintains a given cell or constant when copying • Indicated with a $ in front of row and column $C$5 • Mixed cells uses a $ in front of row or column for copying $A5 or A$6 Microsoft Excel

5. Moving • Different ways to move include • Edit cut and Edit paste • Drag-and-Drop • Uses the clipboard to hold cut information Right-click For shortcut menu Microsoft Excel

6. Hands-On Exercise One • Enter and save a spreadsheet • Use File, Save to save the worksheet • Enter formulas in the spreadsheet • Use Edit, copy to copy cells to other locations • Enter functions such as =AVERAGE • Use What if to change and view results Microsoft Excel

7. Formatting a Worksheet • Adjust column and row areas • Use the Format Column or Row to adjust • Use the double-arrow between column or row • Format cells including (Format, Cells menu) • Numeric formats • Alignment • Fonts • Borders, patterns, and shading Format tabs Microsoft Excel

8. Hands-On Exercise Two • Use File, Open to retrieve a file from disk • Use Format, Cells to change appearance of cells • Use Format, Column to adjust width • Use Noncontiguous ranges to select different areas of worksheet • Use File, Page Setup to change margins • Use Tools, options to show formulas Microsoft Excel

9. Excel and the Internet • Add hyperlinks to incorporate Internet into Excel • Save an Excel spreadsheet as a Web page for Internet Viewing Hyperlink button Enter file or URL Microsoft Excel

10. Hands-On Exercise Three • Use Insert, Hyperlink and insert a link to a Internet address • Use File, Save as Web Page to save the spreadsheet as a web page • Use File, Web Page Preview to view the web page • Proceed with publishing to Internet Server (Find a location to publish page to) Microsoft Excel