1 / 9

Introduction to Information Systems bus adm 230

Introduction to Information Systems bus adm 230. Week 6. Agenda. Excel Chapter 3 in-class assignment is due Excel Project 3 on SAM is due Remember To Use All Three Attempts!! Today work on Excel Chapter 6 Due NEXT Week – D2L Dropbox or Mailbox Next Week – Extra Credit

wilkinson-junior
Download Presentation

Introduction to Information Systems bus adm 230

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introduction to Information Systemsbus adm 230 Week 6

  2. Agenda • Excel Chapter 3 in-class assignment is due • Excel Project 3 on SAM is due • Remember To Use All Three Attempts!! • Today work on Excel Chapter 6 • Due NEXT Week – D2L Dropbox or Mailbox • Next Week – Extra Credit • D2L is current as of last week • Excel Chapter 6 (EX423 to EX476) • 3 pages – Company’s worksheet, formula sheet, and chart • Create Template • 3-D Referencing • Ex: =SUM(Sheet2:Sheet10!B2)

  3. Create Template • Create a template (company worksheet) • Copy and paste to other worksheets (Louisville, Kansas City, & Portland)

  4. Company Worksheet

  5. Louisville Worksheet

  6. Entering and Copying 3-D References Using the Paste Button Menu • Click the Louisville tab and then click cell B5. While holding down the SHIFT key, click the Portland tab to surround cell Louisville!B5 with a marquee • Click the Enter box in the formula bar to enter the SUM function with the 3-D references in cell Company!B5 • With cell B5 active, click the Copy button on the Ribbon to copy the SUM function and the formats assigned to cell B5 to the Office Clipboard • Select the range B6:B11 and then click the Paste button arrow on the Ribbon to display the Paste button menu

  7. Entering and Copying 3-D References Using the Paste Button Menu • Click Formulas on the Paste button menu to copy the SUM function in cell B5 to the range B6:B11 and automatically adjust the cell references in the SUM function to reference the corresponding cells on the three sheets in the workbook • Press the ESC key to clear the marquee surrounding cell B5 and then select cell A14 to deselect the range B6:B11 • Click the Save button on the Quick Access Toolbar to save the NextDVR Profit Potential workbook • Completed Company sheet sample on next slide.

  8. Drawing the Clustered Cone Chart Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista Edition

  9. Next Week • Special Extra Credit Lab Activity • A survey

More Related