MODULE 2 HOMEWORK ASSIGNMENT
(45 points)
You will be providing answers to the following questions using cell references from the indicated
worksheet image provided. Questions 1 uses the first worksheet image, questions 2 and 3 do not use
any image, and questions 4 through 7 use the second worksheet image. Note that the first question has
four parts to it (a through d). You will type your answers in this document. There is no Excel file
provided for this assignment. Remember to start all formulas with an equal (=) sign.
1. (0-10 pts) What new formula will result if the formula in each case is copied from cell B3 to D6?
Explain what changed and what stayed the same. Why? Use the spreadsheet below for (a) –
(d). Each is worth up to 2.5 points.
(a) = A1+A2
=C5+C6, The row and colom changed because both factors are relative.
(b) = $A$1+A2
=$A$1+C6, A and 1 are both absolut values and froze in palce. A2 is a realtive value and changes
with the new cell address.
(c) = $A1+A2
=$A5+C6, The cell rows have changed. The first colum stayed the same since it has the $ sign
and it is absolute.
(d) = A$1+A2
=C$1+C6, The coloms and all the rows changed except for row 1 in the formula since it is absolut
and frozen in place.
2. (0-5 pts) What formula would result if you copied the formula =A1+A2 from cell E7 to cell D9?
Page 1 of 3
A B
1 2
2 4
3 6
