Question
1. Enter a formula in cell C8 that divides the sum of cells C5 through C7 by cell C4. Write the formula so that when
1. Enter a formula in cell C8 that divides the sum of cells C5 through C7 by cell C4. Write the formula so that when you copy it to cells D8:F8, Excel adjusts all the cell references according to the destination cells.
2. Enter a formula in cell C9 that divides the sum of cells C5 through C7 by cell C4. Write the formula using an absolute cell refence so that when you copy the formula to cells D9:F9, cell C4 remains absolute.
3. Enter a formula in cell H5 that divides the sum of cells C5:F5 by cell B5. Write the formula using a mixed cell reference so that when you copy the formula to cells H6 and H7, row 5 remains absolute.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Transactions On Large Scale Data And Knowledge Centered Systems X Special Issue On Database And Expert Systems Applications Lncs 8220
Authors: Abdelkader Hameurlain ,Josef Kung ,Roland Wagner ,Stephen W. Liddle ,Klaus-Dieter Schewe ,Xiaofang Zhou
2013th Edition
