How is an absolute cell reference indicated in spreadsheet software formulas?(A) With a # sign before the cell(B) With a sign before the column and/or - Accountancy MCQ CUET Accountancy 2025 30 May Shift 1 2026 | ExamTest.live

easyMCQCUET Accountancy 2025 30 May Shift 12026Accountancy

1 mark

How is an absolute cell reference indicated in spreadsheet software formulas?(A) With a # sign before the cell(B) With a s i g nb e f ore t h eco l u mnan d / orro w (C) Wi t h p a re n t h eses a ro u n d t h ece ll (D) Wi t ha sign before the column and/or rowChoose the correct answer from the options given below:

Solution & Step-by-step Explanation

Absolute cell references lock a specific cell reference so it remains constant when a formula is copied. They are explicitly denoted by inserting a dollar sign character () d i rec tl y in f ro n t o f t h eco l u mn l e tt er an d / orro w n u mb er (e . g ., A 1) . Opt i o n s (B) an d (D) s t a t e t hi sr u l e i d e n t i c a ll y . T h ere f ore, t h es t a t e m e n t co n d i t i o ni se x c l u s i v e l y f u l f i ll e d b y t hi s description choice.

Try it yourself before checking the explanation above.

How is an absolute cell reference indicated in spreadsheet software formulas?(A) With a # sign before the cell(B) With a s i g nb e f ore t h eco l u mnan d / orro w (C) Wi t h p a re n t h eses a ro u n d t h ece ll (D) Wi t ha sign before the column and/or rowChoose the correct answer from the options given below:

(B) only

(A), (B) and (D) only

(C) only

(C) and (D) only

Practice with timed mock tests and track your performance across Accountancy.