CIS101 Introduction to Computing

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