Quiz1_sol - SUM function or add the individual terms Be...

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

View Full Document Right Arrow Icon
Name: Section: A B C 1 2 3 2 4 3 5 4 24 The C4 cell contains the following formula : =$A$1 * SUM(C1:C3) Rewrite the equivalent formula to be placed in the C4 cell using the R1C1 notation. (You may use either the
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: SUM function or add the individual terms.) Be sure that absolute addresses and relative addresses remain absolute and relative when you convert to the R1C1 notation. Solution: = R1C1 * SUM( R[-3]C : R[-1]C )...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online