1 / 15

CSE1520I Erich Leung Fall 2009

Naming cells. Define a name to a cell or a range of cell help to enhance readability give a meaning name to the cells e.g. sum(salaries) Robustness Name is an abstraction representation of the value(s)

ericmwebb
Download Presentation

CSE1520I Erich Leung Fall 2009

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. Naming cells Define a name to a cell or a range of cell help to enhance • readability give a meaning name to the cells e.g. sum(salaries) • Robustness Name is an abstraction representation of the value(s) The abstraction remains the same if there are changes in or removal of some the its member values CSE1520I Erich Leung Fall 2009

  2. 2003 Naming cells Select the range of cells (usually the whole column, so include the column header) • Insert • Name • Define … Put the name here CSE1520I Erich Leung Fall 2009

  3. 2003 Naming cells Select the range of cells (usually the whole column, so include the column header) • Insert • Name • Define … Put the name here CSE1520I Erich Leung Fall 2009

  4. 2003 Naming cells Select the cells or range of cells • Insert • Name • Define … Range selector CSE1520I Erich Leung Fall 2009

  5. 2007 Naming cells Define name for cells • Formulas • Define Name • Also you can get function from this ribbon, e.g. now(). CSE1520I Erich Leung Fall 2009

  6. 2007 Series Enter th value • Home • Click the drop down button CSE1520I Erich Leung Fall 2009

  7. 2003 Series Enter the value to the first cell • Edit • Fill • Pick the type of series • In the box, specify the details CSE1520I Erich Leung Fall 2009

  8. Formulae Formulas/functions are calls for computation (operation on data Apply formula to a cell • Enter the formula manually =now() • Point and Click Use the tool bar to specify the function Apply formula to a range of cells • Specify the formula in one cell • Copy the formula to other cells CSE1520I Erich Leung Fall 2009

  9. 2007 Formulae In Excel, Formula/ functions are group into libraries, Depending on the kind of computation they perform CSE1520I Erich Leung Fall 2009

  10. 2007 Formulae If you do not know which group the function belongs to CSE1520I Erich Leung Fall 2009

  11. 2003 Formulae Select the cells or range of cells • Insert • Function Or • ∑ button • More functions… CSE1520I Erich Leung Fall 2009

  12. 2007 Chart • Insert • Chart area • Select the type . CSE1520I Erich Leung Fall 2009

  13. 2007 Chart • Insert • Chart area • Select the type . CSE1520I Erich Leung Fall 2009

  14. 2007 Chart • Insert • Chart area • Select the type CSE1520I Erich Leung Fall 2009

  15. 2003 Chart • The data are ready for visualization • Select the cells or range of cells • Insert • Chart • Select the type in the chart wizard Or • Chart wizard button CSE1520I Erich Leung Fall 2009

More Related