CUET Accountancy - Computerised Accounting - Spreadsheet | Free Questions

Q1:

2026: 6 June Shift 1

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

When Extend Selection is active, what is the keyboard shortcut for selecting all data up to and including the last row?

[Ctrl]+[Down Arrow]

[Ctrl]+[Home]

[Ctrl]+[Shift]

[Ctrl]+[Up Arrow]

Correct Answer

Option 3

Correct Answer

Explanation

Q2:

2026: 6 June Shift 1

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

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

Pressing [Enter]

Pressing [Tab]

Pressing [Shift]+[Tab]

Pressing [Shift]+[Enter]

Correct Answer

Option 2

Correct Answer

Explanation

Q3:

2026: 6 June Shift 1

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

Match List-I with List-II

List-I	List-II
(A) Interest rate per period for the loan	(I) Type
(B) Total number of payments for the loan. Its unit (e.g. year) should match with the unit of the interest rate	(II) Rate
(C) Whether payment is made at the beginning (value=1) or at the end (value=0) of the period	(III) FV
(D) Future value, which is taken as 0, is the balance at the end of the loan period	(IV) Nper

Choose the correct answer from the options given below:

(A) - (I), (B) - (III), (C) - (II), (D) - (IV)

(A) - (II), (B) - (IV), (C) - (I), (D) - (III)

(A) - (IV), (B) - (II), (C) - (III), (D) - (I)

(A) - (IV), (B) - (II), (C) - (I), (D) - (III)

Correct Answer

Option 2

Correct Answer

Explanation

Q4:

2026: 31 May Shift 1

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

Which formula would result in TRUE if C4 is less than 10 and D4 is less than 100?

=AND(C4>10, D4>10).

=AND(C4>10, C4<100).

=AND(C4>10, D4<10).

=AND(C4<10, D4<100).

Correct Answer

Option 4

Correct Answer

Explanation

Q5:

2026: 29 May Shift 2

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

Which function results can be displayed in AutoCalculate?

SUM and AVERAGE

MAX and LOOK

LABEL and AVERAGE

MIN and BLANK

Correct Answer

Option 1

Correct Answer

Explanation

Q6:

2026: 29 May Shift 2

Computerised Accounting

>

Spreadsheet

Medium

Computerised Accounting

Match the LIST-I with LIST-II

LIST-I		LIST-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.	Drop Down List
D.	Data Validation	IV.	= DB(cost, salvage, life, period, [month])

Choose the correct answer from the options given below:

A-IV, B-II, C-I, D-III

A-II, B-IV, C-I, D-III

A-IV, B-II, C-III, D-I

A-III, B-IV, C-I, D-II

Correct Answer

Option 2

Correct Answer

Explanation

Q7:

2026: 29 May Shift 2

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

Which category of functions is used in the formula of PMT?

Financial

Statistical

Logical

Payment

Correct Answer

Option 1

Correct Answer

Explanation

Q8:

2026: 29 May Shift 1

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

In order to set the print area using Print Area Option, arrange the following in a correct sequence.

(A) OPTIONAL: To add more data to the print area select a range of cells.

(B) Select the Page Layout command tab

(C) Select the range of cells to print

(D) In the Page Setup group, click Print Area» select Set Print Area. The print area is set

Choose the correct answer from the options given below:

(C), (B), (D), (A)

(D), (A), (B), (C)

(A), (D), (B), (C)

(C), (B), (A), (D)

Correct Answer

Option 1

Correct Answer

Explanation

Q9:

2026: 24 May Shift 1

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

Match List-I with List-II

List-I	List-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:

(A) - (II), (B) - (I), (C) - (III), (D) - (IV)

(A) - (I), (B) - (II), (C) - (III), (D) - (IV)

(A) - (III), (B) - (I), (C) - (IV), (D) - (II)

(A) - (III), (B) - (IV), (C) - (I), (D) - (II)

Correct Answer

Option 3

Correct Answer

Explanation

Q10:

2026: 24 May Shift 1

Computerised Accounting

>

Spreadsheet

Medium

Computerised Accounting

In order to Correct a #DIV/0! Error, the following steps are used. Arrange them in proper order.

(A) Enter a value other than zero in the cell used as a divisor.

(B) Prevent the error value from displaying by using the IF worksheet function.

(C) Change the cell reference to another cell.

(D) Enter the value #N/A into the cell referenced as the divisor, which changes the result of the formula to #N/A from #DIV/0!

Choose the correct answer from the options given below:

(A), (B), (C), (D)

(C), (A), (D), (B)

(B), (A), (D), (C)

(C), (B), (D), (A)

Correct Answer

Option 2

Correct Answer

Explanation

Q11:

2026: 23 May Shift 2

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

Which function results can be displayed in Auto Calculate?

SUM and AVERAGE

MAX and LOOK

LABEL and AVERAGE

MIN and BLANK

Correct Answer

Option 1

Correct Answer

Explanation

Q12:

2026: 23 May Shift 2

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

Which key, when pressed, display the access keys in MS Excel ?

[Esc]

[Ctrl]

[Shift]

[Alt]

Correct Answer

Option 4

Correct Answer

Explanation

Q13:

2026: 23 May Shift 2

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

Match the LIST-I with LIST-II

LIST-I		LIST-II
A.	Top of Worksheet	I. HOME key
B.	One cell down	II. CTRL + HOME
C.	Beginning of the Row	III. Enter key
D.	One cell right	IV. Tab key

Choose the correct answer from the options given below:

A-III, B-II, C-I, D-IV

A-II, B-III, C-I, D-IV

A-IV, B-II, C-I, D-III

A-III, B-IV, C-II, D-I

Correct Answer

Option 2

Correct Answer

Explanation

Q14:

2026: 21 May Shift 2

Computerised Accounting

>

Spreadsheet

Medium

Computerised Accounting

Match the LIST-I with LIST-II

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

Choose the correct answer from the options given below:

A-I, B-II, C-III, D-IV

A-I, B-III, C-II, D-IV

A-I, B-II, C-IV, D-III

A-II, B-III, C-IV, D-I

Correct Answer

Option 4

Correct Answer

Explanation

Q15:

2026: 21 May Shift 1

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

Match List-I and List-II.

List-I	List-II
(A) This function calculates the periodic payment for an annuity, assuming equal payments and a constant rate of interest.	(I) IRR function
(B) It is the total number of payment periods in an annuity.	(II) PMT
(C) It is the number 0 or 1 and indicates when payments are due.	(III) Nper
(D) NPV is also related to the	(IV) Type

Choose the correct answer from the options given below.

(A) - (IV), (B) - (II), (C) - (III), (D) - (I)

(A) - (I), (B) - (II), (C) - (III), (D) - (IV)

(A) - (II), (B) - (III), (C) - (IV), (D) - (I)

(A) - (III), (B) - (IV), (C) - (I), (D) - (II)

Correct Answer

Option 3

Correct Answer

Explanation

Q16:

2026: 21 May Shift 1

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

Arrange the following in sequence while calculating depreciation using straight line method.

(A) Life of Asset

(B) Salvage Value of Asset

(C) Cost of Asset

Choose the correct answer from the options given below:

(A), (B), (C)

(C), (B), (A)

(B), (A), (C)

(B), (C), (A)

Correct Answer

Option 2

Correct Answer

Explanation

Q17:

2026: 20 May Shift 1

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

Which of the following arguments in a financial function represents the total number of payments?

FV

PV

Nper

Rate

Correct Answer

Option 3

Correct Answer

Explanation

Q18:

2026: 20 May Shift 1

Computerised Accounting

>

Spreadsheet

Medium

Computerised Accounting

Match List-I with List-II

List-I	List-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:

(A) - (I), (B) - (II), (C) - (III), (D) - (IV)

(A) - (IV), (B) - (I), (C) - (II), (D) - (III)

(A) - (I), (B) - (II), (C) - (IV), (D) - (III)

(A) - (III), (B) - (IV), (C) - (I), (D) - (II)

Correct Answer

Option 2

Correct Answer

Explanation

Q19:

2026: 20 May Shift 1

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

Arrange the following steps related to freezing the formula using paste special command in logical sequence

(A) Click on Home Tab and select Copy symbol

(B) In the Paste Special box, under paste select the radio button next to Values and click OK

(C) Select the cell (s) that contains the formula

(D) Click on Paste tab and select Paste Special

Choose the correct sequence from the options given below:

(C), (A), (D), (B)

(B), (A), (C), (D)

(A), (D), (C), (B)

(D), (B), (C), (A)

Correct Answer

Option 1

Correct Answer

Explanation

Q20:

2026: 19 May Shift 1

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

Match List-I with List-II

List-I	List-II
(A) Provident Fund (PF)	(I) Net Salary
(B) Compensation for erosion in the purchasing power of wage earner due to price rise	(II) Statutory Deductions
(C) Total Earnings (TE) – Total Deductions (TD)	(III) DA
(D) Spreadsheet application to calculate pay	(IV) Payroll Accounting

Choose the correct answer from the options given below:

(A) - (I), (B) - (II), (C) - (III), (D) - (IV)

(A) - (II), (B) - (III), (C) - (I), (D) - (IV)

(A) - (II), (B) - (I), (C) - (IV), (D) - (III)

(A) - (III), (B) - (IV), (C) - (I), (D) - (II)

Correct Answer

Option 2

Correct Answer

Explanation

Q21:

2026: 19 May Shift 1

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

Which cell reference is used when we want a cell reference to stay fixed on a specific cell, which means that when a formula or function is copied and pasted to other cells, it does not change?

Cell relatives

Multiply reference

Ranges

Absolute cell reference

Correct Answer

Option 4

Correct Answer

Explanation

Q22:

2026: 13 May Shift 2

Computerised Accounting

>

Spreadsheet

Medium

Computerised Accounting

Match List-I with List-II.

List-I	List-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:

(A) - (II), (B) - (IV), (C) - (I), (D) - (III)

(A) - (III), (B) - (II), (C) - (I), (D) - (IV)

(A) - (IV), (B) - (II), (C) - (III), (D) - (I)

(A) - (III), (B) - (IV), (C) - (I), (D) - (II)

Correct Answer

Option 1

Correct Answer

Explanation

Q23:

2026: 13 May Shift 2

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

Which of these is not an argument of the IF function?

Logical_test

Value_if_false

Value_when_false

Value_if_true

Correct Answer

Option 3

Correct Answer

Explanation

Q24:

2026: 13 May Shift 1

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

While typing a numeric value into a cell of a EXCEL spread sheet, the status bar shows the :-

Ready Mode

Enter Mode

Text to edit.

Record Mode

Correct Answer

Option 2

Correct Answer

Explanation

Q25:

2026: 12 May Shift 1

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

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:

(A), (B), (C), (D)

(A), (D), (B), (C)

(B), (A), (D), (C)

(C), (B), (D), (A)

Correct Answer

Option 2

Correct Answer

Explanation

Q26:

2026: 12 May Shift 1

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

By default how many worksheets are available in "workbook" (Excel)?

5

6

3

4

Correct Answer

Option 3

Correct Answer

Explanation

Q27:

2026: 12 May Shift 1

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

In what cell is the Rate for PMT function where = PMT (C8, C9, C10, C11, C12)?

C8

C9

C10

C12

Correct Answer

Option 1

Correct Answer

Explanation

Q28:

2026: 11 May Shift 2

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

Which key combination collapses the ribbon?

[Ctrl]+[F1]

[Ctrl]+[F3]

[Ctrl]+[F5]

[Ctrl]+[F7]

Correct Answer

Option 1

Correct Answer

Explanation

Q29:

2026: 11 May Shift 1

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

On the ribbon of MS Excel, the formula tab contains which of the following categorised functions?

Lookup and Reference Function

View Function

Developer Function

Page layout Function

Correct Answer

Option 1

Correct Answer

Explanation

Q30:

2025: 4 June Shift 2

Computerised Accounting

>

Spreadsheet

Easy

Computerised Accounting

Which Excel function is commonly used to calculate loan repayment instalments?

DB

SLN

PV

PMT

Correct Answer

Option 4

Correct Answer

Explanation

CUET Accountancy: Computerised AccountingSpreadsheet. Free, no login required.

Q1:

Q2:

Q3:

Q4:

Q5:

Q6:

Q7:

Q8:

Q9:

Q10:

Q11:

Q12:

Q13:

Q14:

Q15:

Q16:

Q17:

Q18:

Q19:

Q20:

Q21:

Q22:

Q23:

Q24:

Q25:

Q26:

Q27:

Q28:

Q29:

Q30:

CUET Accountancy Past Year Questions (Topic-Wise)