Question:
A cell reference that either holds row or column constant when the formula or function is copied to another location is known as:
A cell reference that either holds row or column constant when the formula or function is copied to another location is known as:
Show Hint
Use mixed references for flexibility in copying formulas across rows or columns.
Updated On: Jul 8, 2025
- Mixed cell reference
- Relative cell reference
- Ranges
- Absolute cell reference
Hide Solution
Verified By Collegedunia
The Correct Option is A
Solution and Explanation
Mixed cell reference locks either the row or column (but not both) when copying a formula. For example, in \$A1 or A\$1, the column or row respectively is fixed, useful for partial reference control.
% Quick tip
Was this answer helpful?
0
0
Top Questions on Computerised Accounting
- Name the error which occurs when the column is not wide enough or a negative date or time is used. How can it be corrected if:
(i) Error is due to the width of the column, and
(ii) Date or time is negative?- CBSE CLASS XII - 2025
- Accountancy
- Computerised Accounting
- Develop a code for Nisha, Roll No. 23 who took admission in Section A, Class XI in the year 2024 in School No. 10 run by the ‘Education For All Trust’. Section A is a science stream section and its code is 1.
- CBSE CLASS XII - 2025
- Accountancy
- Computerised Accounting
- Explain number formatting
- CBSE CLASS XII - 2025
- Accountancy
- Computerised Accounting
- Which chart element provides additional information about a data marker to identify the details of data in data series?
- CBSE CLASS XII - 2025
- Accountancy
- Computerised Accounting
- How are ranges identified within Excel?
- CBSE CLASS XII - 2025
- Accountancy
- Computerised Accounting
View More Questions
Questions Asked in CBSE CLASS XII exam
- Pass necessary journal entries for the following transactions on dissolution of the firm of Rajesh, Somesh and Yogesh after various assets (other than cash) and third party liabilities have been transferred to Realisation Account :
(i) Rajesh took over stock of Rs 4,00,000 at a discount of 20\%.
(ii) Somesh agreed to take over the firm's furniture, not recorded in the books of the firm at Rs 80,000.
(iii) Land and Building of the book value of Rs 60,00,000 was sold for Rs 90,00,000 through a broker who charged 10\% commission.
(iv) Ashish, an old customer, whose account for Rs 70,000 was written off as bad in the previous year, paid 60\% of the amount.
(v) Sundry Creditors of Rs 3,00,000 were settled at a discount of 10\%.
(vi) Realisation expenses amounting to Rs 21,000 were paid by Yogesh.- CBSE CLASS XII - 2025
- Partnership Accounts
- Explain the financial function which is used to calculate interest rate per period of an annuity.
- CBSE CLASS XII - 2025
- Financial Analysis
Prepare a Common Size Balance Sheet of ZXT Ltd. from the following information:
- CBSE CLASS XII - 2025
- Financial Analysis
- "In the recent times through various schemes and policies, the Government of India has taken vital initiatives to generate employment directly/indirectly." Justify the statement giving valid arguments.
- CBSE CLASS XII - 2025
- Income and Employment
- Pass necessary journal entries for the issue of debentures in the books of ZX Ltd. for the following transactions:
Issued 4,000, 8% Debentures of ₹ 100 each at a discount of 10%, redeemable at par after 5 years.
Issued 1,000, 8% Debentures of ₹ 100 each at a premium of 10%, redeemable at premium of 5% after 5 years.
- CBSE CLASS XII - 2025
- Accounting
View More Questions