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

Q1:

SLN

PMT

Correct Answer

Option 4

Correct Answer

Explanation →

Q2:

4 June Shift 2

Computerised Accounting

Easy

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

Q3:

Cell values

Gridlines

Data types

Legends

Correct Answer

Option 2

Correct Answer

Explanation →

Q4:

4 June Shift 2

Computerised Accounting

Easy

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

Q5:

DDB

SLN

VLOOKUP

Correct Answer

Option 3

Correct Answer

Explanation →

Q6:

3 June Shift 2

Computerised Accounting

Easy

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

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

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

Q9:

Square Brackets [ ]

Braces { }

Inverted Commas ' '

Double Inverted Commas " "

Correct Answer

Option 2

Correct Answer

Explanation →

Q10:

3 June Shift 1

Computerised Accounting

Easy

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

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

Q12:

CUMIPMT

PMT

ACCRINT

NPV

Correct Answer

Option 1

Correct Answer

Explanation →

Q13:

2 June Shift 2

Computerised Accounting

Easy

Q13:

DUPLICATE

REMOVE

DELETE

TRIM

Correct Answer

Option 4

Correct Answer

Explanation →

Q14:

2 June Shift 2

Computerised Accounting

Easy

Q14:

Tab

Cell

Worksheet

Ribbon

Correct Answer

Option 2

Correct Answer

Explanation →

Q15:

31 May Shift 1

Computerised Accounting

Medium

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

Q16:

Plot Area

Data Area

Chart Area

Axis Area

Correct Answer

Option 3

Correct Answer

Explanation →

Q17:

31 May Shift 1

Computerised Accounting

Easy

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

Q18:

Pivot Table

Data Table

Data Cells

Print Area

Correct Answer

Option 1

Correct Answer

Explanation →

Q19:

30 May Shift 2

Computerised Accounting

Hard

Q19:

Correct Answer

Option 3

Correct Answer

Explanation →

Q20:

30 May Shift 2

Computerised Accounting

Medium

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

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

Q22:

Data Validation

Data Table

Cell Address

Cell Area

Correct Answer

Option 2

Correct Answer

Explanation →

Q23:

30 May Shift 1

Computerised Accounting

Medium

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

Q24:

Circle

Small black square

Triangle

Cross

Correct Answer

Option 2

Correct Answer

Explanation →

Q25:

30 May Shift 1

Computerised Accounting

Easy

Q25:

(B) only

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

Correct Answer

Option 1

Correct Answer

Explanation →

Q26:

30 May Shift 1

Computerised Accounting

Easy

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

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

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

Q29:

Type

Nper

Correct Answer

Option 1

Correct Answer

Explanation →

Q30:

27 May Shift 2

Computerised Accounting

Easy

Q30:

RoundUp

Count

Sum IF

Correct Answer

Option 3

Correct Answer

Explanation →

Q31:

27 May Shift 2

Computerised Accounting

Easy

Q31:

pmt

ppmt

nper

rate

Correct Answer

Option 3

Correct Answer

Explanation →

Q32:

27 May Shift 1

Computerised Accounting

Easy

Q32:

Fixed

Mixed

Relative

Absolute

Correct Answer

Option 2

Correct Answer

Explanation →

Q33:

27 May Shift 1

Computerised Accounting

Easy

Q33:

Columns, Rows

Cells, Rows

Rows, Columns

Rows, Cells

Correct Answer

Option 3

Correct Answer

Explanation →

Q34:

27 May Shift 1

Computerised Accounting

Easy

Q34:

WHATIF

COUNTIF

SUMIF

Correct Answer

Option 4

Correct Answer

Explanation →

Q35:

27 May Shift 1

Computerised Accounting

Easy

Q35:

Cell Location

Cell Address

Column Number

Row Number

Correct Answer

Option 2

Correct Answer

Explanation →

Q36:

27 May Shift 1

Computerised Accounting

Easy

Q36:

Mixed

Relative

Absolute

Fixed

Correct Answer

Option 2

Correct Answer

Explanation →

Q37:

22 May Shift 1

Computerised Accounting

Easy

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

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

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

Q1:

SLN

PMT

Correct Answer

Option 4

Correct Answer

Explanation →

Q2:

4 June Shift 2

Computerised Accounting

Easy

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

Q3:

Cell values

Gridlines

Data types

Legends

Correct Answer

Option 2

Correct Answer

Explanation →

Q4:

4 June Shift 2

Computerised Accounting

Easy

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

Q5:

DDB

SLN

VLOOKUP

Correct Answer

Option 3

Correct Answer

Explanation →

Q6:

3 June Shift 2

Computerised Accounting

Easy

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

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

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

Q9:

Square Brackets [ ]

Braces { }

Inverted Commas ' '

Double Inverted Commas " "

Correct Answer

Option 2

Correct Answer

Explanation →

Q10:

3 June Shift 1

Computerised Accounting

Easy

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

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

Q12:

CUMIPMT

PMT

ACCRINT

NPV

Correct Answer

Option 1

Correct Answer

Explanation →

Q13:

2 June Shift 2

Computerised Accounting

Easy

Q13:

DUPLICATE

REMOVE

DELETE

TRIM

Correct Answer

Option 4

Correct Answer

Explanation →

Q14:

2 June Shift 2

Computerised Accounting

Easy

Q14:

Tab

Cell

Worksheet

Ribbon

Correct Answer

Option 2

Correct Answer

Explanation →

Q15:

31 May Shift 1

Computerised Accounting

Medium

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

Q16:

Plot Area

Data Area

Chart Area

Axis Area

Correct Answer

Option 3

Correct Answer

Explanation →

Q17:

31 May Shift 1

Computerised Accounting

Easy

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

Q18:

Pivot Table

Data Table

Data Cells

Print Area

Correct Answer

Option 1

Correct Answer

Explanation →

Q19:

30 May Shift 2

Computerised Accounting

Hard

Q19:

Correct Answer

Option 3

Correct Answer

Explanation →

Q20:

30 May Shift 2

Computerised Accounting

Medium

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

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

Q22:

Data Validation

Data Table

Cell Address

Cell Area

Correct Answer

Option 2

Correct Answer

Explanation →

Q23:

30 May Shift 1

Computerised Accounting

Medium

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

Q24:

Circle

Small black square

Triangle

Cross

Correct Answer

Option 2

Correct Answer

Explanation →

Q25:

30 May Shift 1

Computerised Accounting

Easy

Q25:

(B) only

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

Correct Answer

Option 1

Correct Answer

Explanation →

Q26:

30 May Shift 1

Computerised Accounting

Easy

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

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

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

Q29:

Type

Nper

Correct Answer

Option 1

Correct Answer

Explanation →

Q30:

27 May Shift 2

Computerised Accounting

Easy

Q30:

RoundUp

Count

Sum IF

Correct Answer

Option 3

Correct Answer

Explanation →

Q31:

27 May Shift 2

Computerised Accounting

Easy

Q31:

pmt

ppmt

nper

rate

Correct Answer

Option 3

Correct Answer

Explanation →

Q32:

27 May Shift 1

Computerised Accounting

Easy

Q32:

Fixed

Mixed

Relative

Absolute

Correct Answer

Option 2

Correct Answer

Explanation →

Q33:

27 May Shift 1

Computerised Accounting

Easy

Q33:

Columns, Rows

Cells, Rows

Rows, Columns

Rows, Cells

Correct Answer

Option 3

Correct Answer

Explanation →

Q34:

27 May Shift 1

Computerised Accounting

Easy

Q34:

WHATIF

COUNTIF

SUMIF

Correct Answer

Option 4

Correct Answer

Explanation →

Q35:

27 May Shift 1

Computerised Accounting

Easy

Q35:

Cell Location

Cell Address

Column Number

Row Number

Correct Answer

Option 2

Correct Answer

Explanation →

Q36:

27 May Shift 1

Computerised Accounting

Easy

Q36:

Mixed

Relative

Absolute

Fixed

Correct Answer

Option 2

Correct Answer

Explanation →

Q37:

22 May Shift 1

Computerised Accounting

Easy

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

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

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 →