Chapter_18_Cell_Referencing_Tutorial

Chapter_18_Cell_Referencing_Tutorial - Name: This is what...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 18: Excel Tutorial (Cell Referencing) After completing the tutorial, you will be able to create and edit cell references within Excel. Cell referencing is used to change the labeling of an individual cell. This procedure below will show you how to change a cell labeled B1 into “Name of Cell”. This name will then appear in the formula. This feature comes in handy when you are editing huge formulas, or complex calculations tied to various sheets. Creating and Editing Using Names— the following steps can be used to create and edit names given to individual cells or ranges. 1. Open the workbook labeled “Template.” 2. We will now label the Cash & Equivalents account for the current period. Select the cell in B3. Now go to the Formulas ribbon, and select Define Name . 3. A box will now appear, fill in the information as shown below:
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Name: This is what you would like to refer to this cell as. Scope: This refers to how far the label will be used, Workbook within this Workbook, or within one specific sheet. Comment: Details associated with this name. Refers to: The cell or range that will be replaced by this name. 4. Once the box above is filled click, enter. 5. You can now repeat the step above for the following cells: C3 Cash_Prior, B7 CurrentAssets_Current, C7_CurrentAssets_Prior, B16 CurrentLiab_Current, C17 CurrentLiab_Prior 6. Now within cell C21 enter the Changes in Working Capital formula. (Current Liabilities_Current (Current Assets_Current Cash_Current)) (Current Liabilities_Prior (Current Assets_Prior Cash_Prior))...
View Full Document

Ask a homework question - tutors are online