AfterBoards Logo
Skip to main contentSkip to solution

CUET Accountancy 2026 PYQs24 May Shift 1. Free, no login required.

Computerised Accounting

past year questions, CUET Accountancy 2026 24 May Shift 1

Spreadsheet

past year questions, Computerised Accounting, CUET Accountancy 2026 24 May Shift 1

Easy

Computerised Accounting

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:

Solution

✅ Correct Option: 3

Adding cells on a condition is SUMIF (III). Rounding to a set number of digits is ROUND (I). Counting numeric entries in a range is COUNT (IV). Joining text strings is CONCATENATE (II).

Related questions:

2023: 29 May Shift 2

How many blank worksheet(s) are shown, by default when a new workbook is created?

2025: 2 June Shift 2

Which function returns the cumulative interest paid between two periods?

2022: 15 July Shift 2

In which cell is the rate for PMT function where = PMT (C8, C9, C10, C11, C12)

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:

2023: 20 June Shift 2

In total how many "Rows" are there in a spreadsheet?

2025: 22 May Shift 1

Which combination is true in respect of using a graph/chart?

(A) Quicker and easier to create a chart immediately to see the possible relationship of variables to one another, rather than paging through raw data.

(B) Provide information in as little time as possible.

(C) Graphs do not have the ability to take large amounts of information and make them into exhibitions that are easily used to persuade

(D) A graph may be either a single line graph or a multi-line graph.

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)