CUET Preparation Today
Why is an absolute address used in spreadsheet formulas? |
To speed up calculations To allow the cell reference to change when copying To keep the cell reference fixed when copying formulas To apply conditional formatting |
To keep the cell reference fixed when copying formulas |
The correct answer is option 3- To keep the cell reference fixed when copying formulas. The absolute address is used for those cells whose reference should not change while the formula is to be copied into other cells. |
