CUET Accountancy Computerised Accounting > Spreadsheet PYQs

Filter & Analyse PYQs (Topic-Wise) →

No login required. No pop-ups. We have all previous-year questions with solutions for free!

CUET Accountancy

Q1:

4 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q1:

SLN

PMT

Correct Answer

Option 4

Correct Answer

Explanation →

Q2:

4 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q2:

By inserting formulas

By resizing the plot area

By selecting primary or secondary axes display

By deleting chart elements

Correct Answer

Option 3

Correct Answer

Explanation →

Q3:

4 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q3:

Cell values

Gridlines

Data types

Legends

Correct Answer

Option 2

Correct Answer

Explanation →

Q4:

4 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q4:

Format tab

Resize or move option

Data validation

Freeze panes

Correct Answer

Option 2

Correct Answer

Explanation →

Q5:

3 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q5:

DDB

SLN

VLOOKUP

Correct Answer

Option 3

Correct Answer

Explanation →

Q6:

3 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q6:

Continuous data

Absolute value of data

Proportions

Random textual data

Correct Answer

Option 2

Correct Answer

Explanation →

Q7:

3 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q7:

TODAY() returns current Time while NOW() returns current day

TODAY() returns today's day while NOW() returns current time only

TODAY() returns current month while NOW() returns current date

TODAY() returns today's date while NOW() returns current date and time

Correct Answer

Option 4

Correct Answer

Explanation →

Q8:

3 June Shift 1

Computerised Accounting

Easy

Computerised accounting

Q8:

=IF(A1>=40%,"PASS","FAIL")

=IF(A1<40,"PASS","FAIL")

=IF(A1>=40,"FAIL","PASS")

=IF(A1+40,"PASS","FAIL")

Correct Answer

Option 1

Correct Answer

Explanation →

Q9:

3 June Shift 1

Computerised Accounting

Easy

Computerised accounting

Q9:

Square Brackets [ ]

Braces { }

Inverted Commas ' '

Double Inverted Commas " "

Correct Answer

Option 2

Correct Answer

Explanation →

Q10:

3 June Shift 1

Computerised Accounting

Easy

Computerised accounting

Q10:

Number of payment periods in an annuity

Interest rate per period

Payment amount made each period

First period in the calculation

Correct Answer

Option 1

Correct Answer

Explanation →

Q11:

3 June Shift 1

Computerised Accounting

Easy

Computerised accounting

Q11:

(A), (B) and (C) only

(A), and (C) only

(B), (C) and (D) only

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

Correct Answer

Option 1

Correct Answer

Explanation →

Q12:

2 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q12:

CUMIPMT

PMT

ACCRINT

NPV

Correct Answer

Option 1

Correct Answer

Explanation →

Q13:

2 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q13:

DUPLICATE

REMOVE

DELETE

TRIM

Correct Answer

Option 4

Correct Answer

Explanation →

Q14:

2 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q14:

Tab

Cell

Worksheet

Ribbon

Correct Answer

Option 2

Correct Answer

Explanation →

Q15:

31 May Shift 1

Computerised Accounting

Medium

Computerised accounting

Q15:

=TRIM(A1)=A1

=LEN(A1)>10

=ISNUMBER(A1)

=WEEKDAY(A1)<>1

Correct Answer

Option 1

Correct Answer

Explanation →

Q16:

31 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q16:

Plot Area

Data Area

Chart Area

Axis Area

Correct Answer

Option 3

Correct Answer

Explanation →

Q17:

31 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q17:

File Name

Specific Values in Datasets

Format Styles

Chart Types

Correct Answer

Option 2

Correct Answer

Explanation →

Q18:

30 May Shift 2

Computerised Accounting

Easy

Computerised accounting

Q18:

Pivot Table

Data Table

Data Cells

Print Area

Correct Answer

Option 1

Correct Answer

Explanation →

Q19:

30 May Shift 2

Computerised Accounting

Hard

Computerised accounting

Q19:

Correct Answer

Option 3

Correct Answer

Explanation →

Q20:

30 May Shift 2

Computerised Accounting

Medium

Computerised accounting

Q20:

(A) only

(D) only

(A) and (B) only

(A), (B) and (C) only

Correct Answer

Option 3

Correct Answer

Explanation →

Q21:

30 May Shift 2

Computerised Accounting

Easy

Computerised accounting

Q21:

It stops invalid data from being entered

It displays a warning but allows invalid data entry

It ignores invalid data entry silently

It deletes the invalid data entered

Correct Answer

Option 2

Correct Answer

Explanation →

Q22:

30 May Shift 2

Computerised Accounting

Easy

Computerised accounting

Q22:

Data Validation

Data Table

Cell Address

Cell Area

Correct Answer

Option 2

Correct Answer

Explanation →

Q23:

30 May Shift 1

Computerised Accounting

Medium

Computerised accounting

Q23:

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

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

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

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

Correct Answer

Option 4

Correct Answer

Explanation →

Q24:

30 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q24:

Circle

Small black square

Triangle

Cross

Correct Answer

Option 2

Correct Answer

Explanation →

Q25:

30 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q25:

(B) only

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

Correct Answer

Option 1

Correct Answer

Explanation →

Q26:

30 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q26:

Typing a list of values separated by commas

Selecting a range of cells containing list values

Using a Named Range to refer to list values

Creating a pivot table

Correct Answer

Option 4

Correct Answer

Explanation →

Q27:

30 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q27:

The row number followed by the column letter

The column letter followed by the row number

The sheet name only

The file path

Correct Answer

Option 2

Correct Answer

Explanation →

Q28:

27 May Shift 2

Computerised Accounting

Easy

Computerised accounting

Q28:

Vector and Array

AND and OR

TRUE and FALSE

IF and BLANK

Correct Answer

Option 1

Correct Answer

Explanation →

Q29:

27 May Shift 2

Computerised Accounting

Easy

Computerised accounting

Q29:

Type

Nper

Correct Answer

Option 1

Correct Answer

Explanation →

Q30:

27 May Shift 2

Computerised Accounting

Easy

Computerised accounting

Q30:

RoundUp

Count

Sum IF

Correct Answer

Option 3

Correct Answer

Explanation →

Q31:

27 May Shift 2

Computerised Accounting

Easy

Computerised accounting

Q31:

pmt

ppmt

nper

rate

Correct Answer

Option 3

Correct Answer

Explanation →

Q32:

27 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q32:

Fixed

Mixed

Relative

Absolute

Correct Answer

Option 2

Correct Answer

Explanation →

Q33:

27 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q33:

Columns, Rows

Cells, Rows

Rows, Columns

Rows, Cells

Correct Answer

Option 3

Correct Answer

Explanation →

Q34:

27 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q34:

WHATIF

COUNTIF

SUMIF

Correct Answer

Option 4

Correct Answer

Explanation →

Q35:

27 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q35:

Cell Location

Cell Address

Column Number

Row Number

Correct Answer

Option 2

Correct Answer

Explanation →

Q36:

27 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q36:

Mixed

Relative

Absolute

Fixed

Correct Answer

Option 2

Correct Answer

Explanation →

Q37:

22 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q37:

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

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

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

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

Correct Answer

Option 4

Correct Answer

Explanation →

Q38:

22 May Shift 1

Computerised Accounting

Medium

Computerised accounting

Q38:

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

(A), (B) and (C) only

(A), (C) and (D) only

(B), (C) and (D) only

Correct Answer

Option 1

Correct Answer

Explanation →

Q39:

22 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q39:

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

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

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

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

Correct Answer

Option 4

Correct Answer

Explanation →

Q40:

15 May Shift 2

Computerised Accounting

Easy

Q40:

One

Two

Three

Four

Correct Answer

Option 3

Correct Answer

Explanation →

Q41:

15 May Shift 1

Computerised Accounting

Easy

Q41:

Row heading

Status bar

Name Box

Formula bar

Correct Answer

Option 3

Correct Answer

Explanation →

Q42:

14 May Shift 2

Computerised Accounting

Easy

Q42:

Correct Answer

Option 2

Correct Answer

Explanation →

Q43:

14 May Shift 2

Computerised Accounting

Easy

Q43:

Normal

Page Layout

Page Setup

Review

Correct Answer

Option 2

Correct Answer

Explanation →

Q44:

14 May Shift 1

Computerised Accounting

Easy

Q44:

Area chart

Pie chart

Bar chart

Pictorial chart

Correct Answer

Option 4

Correct Answer

Explanation →

Q45:

14 May Shift 1

Computerised Accounting

Easy

Q45:

View toolbar.

Home tab.

Microsoft Office Button

Status bar

Correct Answer

Option 3

Correct Answer

Explanation →

Q46:

13 May Shift 2

Computerised Accounting

Easy

Q46:

The plot area

The data points

The legend

Rows and Column

Correct Answer

Option 4

Correct Answer

Explanation →

Q47:

13 May Shift 1

Computerised Accounting

Easy

Q47:

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

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

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

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

Correct Answer

Option 4

Correct Answer

Explanation →

Q48:

13 May Shift 1

Computerised Accounting

Easy

Q48:

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

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

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

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

Correct Answer

Option 2

Correct Answer

Explanation →

CUET Accountancy Computerised Accounting > Spreadsheet PYQs

Filter & Analyse PYQs (Topic-Wise) →

No login required. No pop-ups. We have all previous-year questions with solutions for free!

CUET Accountancy

Q1:

4 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q1:

SLN

PMT

Correct Answer

Option 4

Correct Answer

Explanation →

Q2:

4 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q2:

By inserting formulas

By resizing the plot area

By selecting primary or secondary axes display

By deleting chart elements

Correct Answer

Option 3

Correct Answer

Explanation →

Q3:

4 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q3:

Cell values

Gridlines

Data types

Legends

Correct Answer

Option 2

Correct Answer

Explanation →

Q4:

4 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q4:

Format tab

Resize or move option

Data validation

Freeze panes

Correct Answer

Option 2

Correct Answer

Explanation →

Q5:

3 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q5:

DDB

SLN

VLOOKUP

Correct Answer

Option 3

Correct Answer

Explanation →

Q6:

3 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q6:

Continuous data

Absolute value of data

Proportions

Random textual data

Correct Answer

Option 2

Correct Answer

Explanation →

Q7:

3 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q7:

TODAY() returns current Time while NOW() returns current day

TODAY() returns today's day while NOW() returns current time only

TODAY() returns current month while NOW() returns current date

TODAY() returns today's date while NOW() returns current date and time

Correct Answer

Option 4

Correct Answer

Explanation →

Q8:

3 June Shift 1

Computerised Accounting

Easy

Computerised accounting

Q8:

=IF(A1>=40%,"PASS","FAIL")

=IF(A1<40,"PASS","FAIL")

=IF(A1>=40,"FAIL","PASS")

=IF(A1+40,"PASS","FAIL")

Correct Answer

Option 1

Correct Answer

Explanation →

Q9:

3 June Shift 1

Computerised Accounting

Easy

Computerised accounting

Q9:

Square Brackets [ ]

Braces { }

Inverted Commas ' '

Double Inverted Commas " "

Correct Answer

Option 2

Correct Answer

Explanation →

Q10:

3 June Shift 1

Computerised Accounting

Easy

Computerised accounting

Q10:

Number of payment periods in an annuity

Interest rate per period

Payment amount made each period

First period in the calculation

Correct Answer

Option 1

Correct Answer

Explanation →

Q11:

3 June Shift 1

Computerised Accounting

Easy

Computerised accounting

Q11:

(A), (B) and (C) only

(A), and (C) only

(B), (C) and (D) only

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

Correct Answer

Option 1

Correct Answer

Explanation →

Q12:

2 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q12:

CUMIPMT

PMT

ACCRINT

NPV

Correct Answer

Option 1

Correct Answer

Explanation →

Q13:

2 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q13:

DUPLICATE

REMOVE

DELETE

TRIM

Correct Answer

Option 4

Correct Answer

Explanation →

Q14:

2 June Shift 2

Computerised Accounting

Easy

Computerised accounting

Q14:

Tab

Cell

Worksheet

Ribbon

Correct Answer

Option 2

Correct Answer

Explanation →

Q15:

31 May Shift 1

Computerised Accounting

Medium

Computerised accounting

Q15:

=TRIM(A1)=A1

=LEN(A1)>10

=ISNUMBER(A1)

=WEEKDAY(A1)<>1

Correct Answer

Option 1

Correct Answer

Explanation →

Q16:

31 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q16:

Plot Area

Data Area

Chart Area

Axis Area

Correct Answer

Option 3

Correct Answer

Explanation →

Q17:

31 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q17:

File Name

Specific Values in Datasets

Format Styles

Chart Types

Correct Answer

Option 2

Correct Answer

Explanation →

Q18:

30 May Shift 2

Computerised Accounting

Easy

Computerised accounting

Q18:

Pivot Table

Data Table

Data Cells

Print Area

Correct Answer

Option 1

Correct Answer

Explanation →

Q19:

30 May Shift 2

Computerised Accounting

Hard

Computerised accounting

Q19:

Correct Answer

Option 3

Correct Answer

Explanation →

Q20:

30 May Shift 2

Computerised Accounting

Medium

Computerised accounting

Q20:

(A) only

(D) only

(A) and (B) only

(A), (B) and (C) only

Correct Answer

Option 3

Correct Answer

Explanation →

Q21:

30 May Shift 2

Computerised Accounting

Easy

Computerised accounting

Q21:

It stops invalid data from being entered

It displays a warning but allows invalid data entry

It ignores invalid data entry silently

It deletes the invalid data entered

Correct Answer

Option 2

Correct Answer

Explanation →

Q22:

30 May Shift 2

Computerised Accounting

Easy

Computerised accounting

Q22:

Data Validation

Data Table

Cell Address

Cell Area

Correct Answer

Option 2

Correct Answer

Explanation →

Q23:

30 May Shift 1

Computerised Accounting

Medium

Computerised accounting

Q23:

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

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

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

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

Correct Answer

Option 4

Correct Answer

Explanation →

Q24:

30 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q24:

Circle

Small black square

Triangle

Cross

Correct Answer

Option 2

Correct Answer

Explanation →

Q25:

30 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q25:

(B) only

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

Correct Answer

Option 1

Correct Answer

Explanation →

Q26:

30 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q26:

Typing a list of values separated by commas

Selecting a range of cells containing list values

Using a Named Range to refer to list values

Creating a pivot table

Correct Answer

Option 4

Correct Answer

Explanation →

Q27:

30 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q27:

The row number followed by the column letter

The column letter followed by the row number

The sheet name only

The file path

Correct Answer

Option 2

Correct Answer

Explanation →

Q28:

27 May Shift 2

Computerised Accounting

Easy

Computerised accounting

Q28:

Vector and Array

AND and OR

TRUE and FALSE

IF and BLANK

Correct Answer

Option 1

Correct Answer

Explanation →

Q29:

27 May Shift 2

Computerised Accounting

Easy

Computerised accounting

Q29:

Type

Nper

Correct Answer

Option 1

Correct Answer

Explanation →

Q30:

27 May Shift 2

Computerised Accounting

Easy

Computerised accounting

Q30:

RoundUp

Count

Sum IF

Correct Answer

Option 3

Correct Answer

Explanation →

Q31:

27 May Shift 2

Computerised Accounting

Easy

Computerised accounting

Q31:

pmt

ppmt

nper

rate

Correct Answer

Option 3

Correct Answer

Explanation →

Q32:

27 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q32:

Fixed

Mixed

Relative

Absolute

Correct Answer

Option 2

Correct Answer

Explanation →

Q33:

27 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q33:

Columns, Rows

Cells, Rows

Rows, Columns

Rows, Cells

Correct Answer

Option 3

Correct Answer

Explanation →

Q34:

27 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q34:

WHATIF

COUNTIF

SUMIF

Correct Answer

Option 4

Correct Answer

Explanation →

Q35:

27 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q35:

Cell Location

Cell Address

Column Number

Row Number

Correct Answer

Option 2

Correct Answer

Explanation →

Q36:

27 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q36:

Mixed

Relative

Absolute

Fixed

Correct Answer

Option 2

Correct Answer

Explanation →

Q37:

22 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q37:

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

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

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

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

Correct Answer

Option 4

Correct Answer

Explanation →

Q38:

22 May Shift 1

Computerised Accounting

Medium

Computerised accounting

Q38:

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

(A), (B) and (C) only

(A), (C) and (D) only

(B), (C) and (D) only

Correct Answer

Option 1

Correct Answer

Explanation →

Q39:

22 May Shift 1

Computerised Accounting

Easy

Computerised accounting

Q39:

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

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

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

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

Correct Answer

Option 4

Correct Answer

Explanation →

Q40:

15 May Shift 2

Computerised Accounting

Easy

Q40:

One

Two

Three

Four

Correct Answer

Option 3

Correct Answer

Explanation →

Q41:

15 May Shift 1

Computerised Accounting

Easy

Q41:

Row heading

Status bar

Name Box

Formula bar

Correct Answer

Option 3

Correct Answer

Explanation →

Q42:

14 May Shift 2

Computerised Accounting

Easy

Q42:

Correct Answer

Option 2

Correct Answer

Explanation →

Q43:

14 May Shift 2

Computerised Accounting

Easy

Q43:

Normal

Page Layout

Page Setup

Review

Correct Answer

Option 2

Correct Answer

Explanation →

Q44:

14 May Shift 1

Computerised Accounting

Easy

Q44:

Area chart

Pie chart

Bar chart

Pictorial chart

Correct Answer

Option 4

Correct Answer

Explanation →

Q45:

14 May Shift 1

Computerised Accounting

Easy

Q45:

View toolbar.

Home tab.

Microsoft Office Button

Status bar

Correct Answer

Option 3

Correct Answer

Explanation →

Q46:

13 May Shift 2

Computerised Accounting

Easy

Q46:

The plot area

The data points

The legend

Rows and Column

Correct Answer

Option 4

Correct Answer

Explanation →

Q47:

13 May Shift 1

Computerised Accounting

Easy

Q47:

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

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

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

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

Correct Answer

Option 4

Correct Answer

Explanation →

Q48:

13 May Shift 1

Computerised Accounting

Easy

Q48:

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

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

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

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

Correct Answer

Option 2

Correct Answer

Explanation →