CHEM140 Lecture Notes - Lecture 2: Dialog Box

129 views2 pages
24 Jan 2016
Department
Course
Professor

Document Summary

A reference identifies a cell or a group of cells on a worksheet o. References allows you to use data contained in different parts of a worksheet. Tells excel which cells to look in to find values you want to use. Cell references are based on column and row heading. Tells excel how to find another cell starting from the cell containing the. Used if you always want to refer to cells relative to the cell containing formula (c4, f8, etc) the formula, even if you copy or move the formula. Tells excel how to find a cell based on exact location of the cell in the. Used when you want to refer to the same cell regardless of where the o. A formula + will always add values of cells in b1 and b2. whereas worksheet (, , etc) formula is located on the worksheet. B1+b2 will change if it is copied to a different location.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related textbook solutions

Related Documents

Related Questions