Computerised Accounting

Spreadsheet

Easy

Computerised Accounting

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

Nper

Rate

✅ Correct Option: 3

In spreadsheet financial functions, Nper stands for number of periods, that is the total count of payment periods in the annuity.

Rate is the interest rate per period, PV is the present value or principal at the start, and FV is the future value or balance remaining at the end.

2025: 4 June Shift 2

What is the correct formula for calculating total depreciation on an asset?

2025: 13 May Shift 1

Order of mathematical operations in solving data in electronic spreadsheet

(A) * Multiplication

(B) + Addition

(D) / Division

Choose the correct answer from the options given below:

2025: 27 May Shift 1

__________ are numbered numerically from top to bottom while __________ are referred by alpha characters from left to right.

2026: 29 May Shift 2

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

2025: 3 June Shift 2

Which Excel function is used to calculate depreciation under Straight Line Method (SLM)?

2022: 30 Aug Shift 2

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

Solution