Home › CBSE Class 12 (Commerce) › Accountancy › Computerised Accounting System › Which cell reference stays fixed when a formula …
Which cell reference stays fixed when a formula is copied?
AC$4
B$C4
C$C$4
DC4
Answer & Solution
Correct answer: C. $C$4
Dollar signs before both column and row make the reference absolute, so it does not shift on copying.
Related questions
Excel 2007 chart tools are found on which ribbon tab?Data markers of the same colour in a chart form aA plot has at least two axes. The horizontal one is usually theWhich payroll deduction is a monthly share of the yearly income tax?Which payroll deduction is levied under state legislation in some states?In a salary bill, Dearness Allowance compensates employees forA clerk's basic pay earned is 25000 and house rent allowance is 8 percent of it. The allowWith basic pay earned of 18000 and a PF rate of 12 percent, the PF deduction is