Relative vs. Absolute Addressing in a Spreadsheet

Table of Contents

Relative vs. Absolute Addressing in a Spreadsheet

Relative Address

Example of Copying a Formula with Relative Addressing

Example of Copying a Formula with Relative Addressing

Relative address (reference)

Do Problem 1 on Handout

Answer

Absolute Addressing

Example of Copying Formula with Absolute Addressing

Example of Copying Formula with Absolute Addressing

Do Problem 4 on Handout

Answer

Additional Problems

Additional Problem Answers

Handout

Questions

Email: dmz@cs.bsu.edu

Home Page: http://www.cs.bsu.edu/homepages/dmz/cs104/lecture/