1 / 14

CIS101 Introduction to Computing

CIS101 Introduction to Computing. Review of Charts Excel Project Two. Review of Charts. Basic terminology Data series – a set of information (data) that will be plotted on a graph (same color) Legend – box that displays the relationship between a data series and its assigned color.

Download Presentation

CIS101 Introduction to Computing

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. CIS101Introduction to Computing Review of Charts Excel Project Two

  2. Review of Charts • Basic terminology • Data series – a set of information (data) that will be plotted on a graph (same color) • Legend – box that displays the relationship between a data series and its assigned color

  3. Chart types • Displays the relationships between numbers in a series • Column, bar, line • Displays the relationship of parts to a whole • pie • Try exercise now (discussion board)

  4. Excel Project Two • Produce summary of investments • Use web query and real-time data to update results • Basic tasks in excel: • Formatting • Spell checking • Display with formulas visible • Print

  5. Formulas for project two • Need to calculate: • Initial cost • Current value • Gain/loss • Percent gain/loss • Use excel syntax to enter formulas in cells

  6. Start Project two • Start excel and open a new worksheet • Enter titles and numbers (page EX 71) • Use ALT+ENTER to display column titles as multiple lines of text

  7. Excel and Formulas • = (equal) signals to excel you want to enter a formula • When you used autosum last week, equal sign was inserted for you by excel • Formulas often use arithmetic operators (Table 2-2)

  8. Order of Operations • Operations are carried out following order of operations from algebra • not always left to right, depends on what operations are performed • Table 2.2 describes the order of operations • You can use parentheses to override (change) this order • Table 2.3 gives examples • JavaScript also follows the same order of operations for formulas

  9. Built-in functions • Excel includes prewritten formulas called functions • Function takes a value or values, performs an operation, then returns result (answer) to the cell • Values are called arguments

  10. Format for Functions • All functions begin with equal sign (=) and include arguments in parentheses • Examples:=AVERAGE(D3:D10)=MAX(D3:D10)

  11. What functions are available? • Click function icon or • Click insert sub-menu, select insert function • Functions are organized by category

  12. Web queries • Existing web queries (included with Excel) connect to MSMoney to import stock prices • Use stock symbol to look up current price • Use second worksheet for Stock Quotes

  13. Summary of Project Two • Apply various formats to numbers (currency, comma, percent) • Change height and width of columns and rows • Enter formulas • Use built-in functions average, min, and max

  14. Summary cont. • View worksheet with formulas • Print and preview spreadsheet • Use a second worksheet • Import data from a Web source using a Web query • E-mailing a workbook

More Related