Question: #9 # 10 # 11 The correct way to enter a cell address (for cell D3) in Excel when you want the row to

#9 # 10 # 11 The correct way to enter a cell address (for cell D3) in Excel when you want the row to always stay the same, but you want the column to change when you copy to the right or left is: Answer format: Text Submit You run a school in Florida. Fixed monthly cost is $5,233.00 for rent and utilities, $6,043.00 is spent in salaries and $1,790.00 in insurance. Also every student adds up to $103.00 per month in stationary, food etc. You charge $735.00 per month from every student now. You are considering moving the school to another neighborhood where the rent and utilities will increase to $10,453.00, salaries to $6,600.00 and insurance to $2,475.00 per month. Variable cost per student will increase up to $158.00 per month. However you can charge $1,162.00 per student. How much do you currently charge per student? Submit Answer format: Number: Round to: 0 decimal places. Answer format: Text If you are referencing cell (C2)in Excel and want to be able to copy the formula and update the column and keep the row fixed, how do you reference the cell? Submit
Step by Step Solution
3.41 Rating (151 Votes )
There are 3 Steps involved in it
9 Step 12 We shall add the sign before the row alphabet to make it constant Step 22 10 How much do ... View full answer
Get step-by-step solutions from verified subject matter experts
