AfterBoards Logo
Skip to main contentSkip to solution

CUET Accountancy 2025 PYQs27 May Shift 2. Free, no login required.

Computerised Accounting

past year questions, CUET Accountancy 2025 27 May Shift 2

Spreadsheet

past year questions, Computerised Accounting, CUET Accountancy 2025 27 May Shift 2

Easy

Computerised Accounting

______ is the total number of payment periods in an annuity in financial function.

Solution

✅ Correct Option: 3

In financial functions, nper represents the total number of payment periods in an annuity.

The term "nper" stands for "Number of Periods" and is a standard argument used in various financial functions like PMT, PV, FV, etc.

To understand why the other options are incorrect:

pmt → Represents the payment amount made each period (constant throughout the annuity)

ppmt → Calculates the principal portion of a payment for a specific period

rate → Represents the interest rate per period

For example, in a loan of ₹5,00,000 to be repaid over 5 years with monthly payments, the nper would be 60 (5 years × 12 months). This value tells the financial function how many times payments will be made over the life of the annuity.

Related questions:

2025: 22 May Shift 1

Following are the steps related to preparation of charts, arrange them in a correct sequence.

(A) Save a chart.

(B) Create a basic chart using the pattern from the panel available on top of the worksheet in 'Chart groups' option.

(C) Change the layout or style of chart

(D) Enter data on a worksheet with proper column and row titles.

Choose the correct answer from the options given below:

2026: 11 May Shift 1

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

2025: 4 June Shift 2

What allows you to reposition or change the size of a chart on the worksheet?

2022: 20 Aug Shift 2

The data that is entered in a cell may be either:

A. Numeric

B. Alpha-Numeric

C. Date

D. Label

Choose the correct answer from the options given below:

2022: 30 Aug Shift 2

How many blank worksheets are shown when a new workbook is created.

2025: 30 May Shift 1

How is an absolute cell reference indicated?

(A) With a # sign before the cell

(B) With a $ sign before the column and/or row

(C) With parentheses around the cell

(D) With a $ sign before the column and/or row

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)