1 / 14

Excel: Cell References

Excel: Cell References. Computer Information Technology Section 6-4. Some text and examples used with permission from: http://www.jegsworks.com Note: We are not endorsing or promoting religious doctrine, but simply taking advantage of this website for educational purposes. Objectives.

tavi
Download Presentation

Excel: Cell References

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. Excel: Cell References Computer Information Technology Section 6-4 Some text and examples used with permission from: • http://www.jegsworks.com • Note: We are not endorsing or promoting religious doctrine, but simply taking advantage of this website for educational purposes.

  2. Objectives • The student will • Understand references (names) for cells and ranges. • Be able to identify a cell or range given a reference • Know how to name a cell or range of cells • Know to go to a specific “name”

  3. Quick Review: Name the following cells Georgia B7 Vancouver C10 Computers Today A1 The Active Cell A4 Excel: Cell Names

  4. Excel: Cell Names • Cell references are defined by the column letter and the row number • The active cell is always shown in the formula toolbar

  5. Excel: Ranges of Cells • A range is a set of cells • Ranges of cells are referenced by: Starting Cell:Ending Cell For example A1:C5 is this highlighted range:

  6. Excel: Cell Ranges • Cell ranges do not have to be contiguous • Non-contiguous ranges are referenced by the parts separated by a comma

  7. Excel: Non-contiguous range • The reference for the highlighted areas is defined as: A1:C5,B7,C9:D11

  8. Excel: Ranges • Why are ranges important? • Ranges are used to defined a set of related values. • You can perform functions on ranges • Sum • Average • Etc.

  9. Excel: Ranges • What ranges might be useful in this excel file?

  10. Excel: Naming a Cell or Range • You can define a Name for a cell or range to make it easier to reference it in functions etc. • You control Names from the Defined Names group on the Formulas tab:

  11. Excel: Naming a Cell or Range • To name the range for the January expenses you would: • Select the cells you want to name. • Click on Define Name • Enter the name

  12. Excel: Naming a Cell or Range • Once you have given a cell or range a name you can access the name in the dropdown from the Names section on the Formula bar • Clicking on the name will select the cell or range

  13. Summary • Cell references are • ColumnRow • Range References are • Starting Cell:Ending Cell • Ranges do not have to be contiguous • Use Define Name to give a name to a cell or a range of cells

  14. Rest of today • If you did not finish the cell formatting exercise from yesterday, it is on the website. Do not print it! You must show it to me to get credit • Do the worksheet on cell references. If you do not finish this in class today, Take it home and finish it. You must turn it in tomorrow. • If you finish do at least 15 minutes of Mavis Beacon

More Related