AfterBoards Logo
Skip to main contentSkip to solution

CUET Accountancy 2026 PYQs13 May Shift 2. Free, no login required.

Computerised Accounting

past year questions, CUET Accountancy 2026 13 May Shift 2

Spreadsheet

past year questions, Computerised Accounting, CUET Accountancy 2026 13 May Shift 2

Medium

Computerised Accounting

Match List-I with List-II.

List-IList-II
(A) Depreciation using Straight Line Method(I) =PMT(Rate, Nper, Pv, Fv, Type)
(B) Depreciation using Written Down Value Method(II) =SLN(cost, salvage, life)
(C) Computation of Installment of Loan(III) Use Drop Down List
(D) Data Validation(IV) = DB(Cost, Salvage, Life, Period, Month)

Choose the correct answer from the options given below:

Solution

✅ Correct Option: 1

SLN stands for straight line and takes cost, salvage and life, so (A) matches (II). DB is the declining balance or written down value function, so (B) matches (IV). PMT computes the periodic loan instalment, so (C) matches (I). Data Validation is applied through a drop down list to restrict entries, so (D) matches (III).

Related questions:

2025: 31 May Shift 1

Provident Fund (PF) is calculated as a percentage of which component(s)?

2025: 3 June Shift 1

PV function returns the present value of an investment. The syntax of the function is PV (rate, nper, pmt, fv, type). What does NPER stands for?

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:

2025: 22 May Shift 1

Match List-I with List-II:

List-IList-II
MovementKeystroke (Press key)
(A) One cell down(I) Left arrow key
(B) One cell up(II) Right arrow key or Tab key
(C) One cell left(III) Down arrow key or Enter key
(D) One cell right(IV) Up arrow key

Choose the correct answer from the options given below:

2026: 6 June Shift 1

Which step completes an entry and moves the pointer to the cell to the right?

2026: 21 May Shift 2

Match the LIST-I with LIST-II

LIST-I (Movement)LIST-II (Key Stroke (Press key))
A.Beginning of the RowI. CTRL + D
B.Moving consecutively to the first and the last filled cells of a cluster of filled cells in a column by pressing ofII. HOME key
C.The cell at the intersection of the last row and last column containing dataIII. CTRL + Down arrow key
D.Short-cut key to drag downIV. CTRL + END keys

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)