AfterBoards Logo
Skip to main contentSkip to solution

CUET Accountancy 2025 PYQs27 May Shift 1. Free, no login required.

Computerised Accounting

past year questions, CUET Accountancy 2025 27 May Shift 1

Spreadsheet

past year questions, Computerised Accounting, CUET Accountancy 2025 27 May Shift 1

Easy

Computerised Accounting

$C4 or C$4 is an example of __________ reference.

Solution

✅ Correct Option: 2

In spreadsheet applications, cell references are classified based on how they behave when copied to other cells.

The notation $C4 means:

  • Column C is fixed (indicated by $ before C)
  • Row 4 is relative (no $ before 4)

The notation C$4 means:

  • Column C is relative (no $ before C)
  • Row 4 is fixed (indicated by $ before 4)

When only one component (either column or row) is fixed while the other remains relative, it is called a Mixed Reference.

For comparison:

  • Relative Reference: C4 (both can change)
  • Absolute Reference: CC4 (both are fixed)
  • Mixed Reference: C4orCC4 or C4 (one fixed, one relative)

Answer: Option 2 - Mixed

Related questions:

2025: 4 June Shift 2

What element can you show or hide to improve clarity in the background of the chart?

2026: 24 May Shift 1

Match List-I with List-II

List-IList-II
(A) It is the function which adds the cells as per given specified criteria(I) ROUND
(B) It is the function to rounds a number to specified number of digits.(II) CONCATENATE
(C) It is used to get the number of the entries in a number field (including date also) i.e. in a range or array of numbers.(III) SUMIF
(D) This function joins two or more text strings into one text string(IV) COUNT

Choose the correct answer from the options given below:

2026: 12 May Shift 1

The arithmetic operations which we perform by using spreadsheets follow what order of mathematical (expression) operations rules?

(A) Brackets

(B) Division or multiplication

(C) Addition and subtraction

(D) Exponents

Choose the correct answer from the options given below:

2022: 20 July Shift 1

The best way to get started in Excel 2007 was to click the :

2025: 27 May Shift 1

A cell reference identifies the location of a cell or group of cells in the spreadsheet also referred as a

2026: 20 May Shift 1

Match List-I with List-II

List-IList-II
(A) Ranges(I) Holds either row or column constant when the formula or function is copied to another location
(B) Mixed reference(II) Used when we want a cell reference to stay fixed on specific cell
(C) Absolute reference(III) As a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the new location
(D) Default reference(IV) Identified by cell references of the cells from the upper left to lower right

Choose the correct answer from the options given below:

Keyboard Shortcuts

  • Left arrow: Previous question
  • Right arrow: Next question
  • S key: Jump to solution
  • Q key: Jump to question

CUET Accountancy Past Year Questions (Topic-Wise)