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: Jan 14, 2026
- 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
- =SUM(B2B3) will give an error while using a spreadsheet. Identify the error and state the steps to correct it.
- CBSE CLASS XII - 2025
- Accountancy
- Computerised Accounting
- State the steps to prepare a chart.
- CBSE CLASS XII - 2025
- Accountancy
- Computerised Accounting
- In an accounting software how many pre-defined account groups exist? State their further division with reference to number and type.
- CBSE CLASS XII - 2025
- Accountancy
- Computerised Accounting
- Explain the ways in which accounting software provides data security, safety, and confidentiality.
- CBSE CLASS XII - 2025
- Accountancy
- Computerised Accounting
- In a graph, the area bounded by different axes is known as:
- CBSE CLASS XII - 2025
- Accountancy
- Computerised Accounting
View More Questions
Questions Asked in CBSE CLASS XII exam
- Considering the case of magnetic field produced by air-filled current carrying solenoid, show that the magnetic energy density of a magnetic field \( B \) is \( \frac{B^2}{2\mu_0} \).
- CBSE CLASS XII - 2025
- Magnetic Field
- Three batteries E1, E2, and E3 of emfs and internal resistances (4 V, 2 \(\Omega\)), (2 V, 4 \(\Omega\)) and (6 V, 2 \(\Omega\)) respectively are connected as shown in the figure. Find the values of the currents passing through batteries E1, E2, and E3.
- CBSE CLASS XII - 2025
- Kirchhoff's Laws
- Two wires made of the same material have the same length \( l \) but different cross-sectional areas \( A_1 \) and \( A_2 \). They are connected together with a cell of voltage \( V \). Find the ratio of the drift velocities of free electrons in the two wires when they are joined in: (i) series, and (ii) parallel.
- CBSE CLASS XII - 2025
- Current electricity
- Suppose, the value of Average Propensity to Consume (APC) is 0.8 and National Income is ₹ 4,000 crores, the value of saving would be ₹ ____ crores. (Choose the correct option to fill up the blank)
- CBSE CLASS XII - 2025
- Income and Employment
- Surface area of a balloon (spherical), when air is blown into it, increases at a rate of 5 mm²/s. When the radius of the balloon is 8 mm, find the rate at which the volume of the balloon is increasing.
View More Questions