Computerised Accounting

Spreadsheet

Easy

Computerised Accounting

______ is the number 0 or 1 and indicates when payments are due.

Type

Nper

✅ Correct Option: 1

In financial functions (like PMT, PV, FV in spreadsheets), various parameters are used to calculate values related to time value of money.

Type is the parameter that takes only two possible values:

This parameter specifically indicates the timing of when payments are made or received during each period.

The other options represent different parameters:

Nper (Number of Periods) → Total number of payment periods, can be any positive number

Fv (Future Value) → The value of investment at the end of the term, expressed as a monetary amount

Pv (Present Value) → The current value of future cash flows, expressed as a monetary amount

Since the question specifically asks for the parameter that is "0 or 1" and relates to payment timing, Type is the correct answer.

2025: 30 May Shift 1

How do you add the Data Form button to Excel's Quick Access Toolbar? Click Quick Access Toolbar arrow

(A) Add

(B) All Commands

(D) More Commands

2026: 12 May Shift 1

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

2025: 14 May Shift 1

Which of the following is not a types of graphs and charts

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:

2026: 24 May Shift 1

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:

2026: 24 May Shift 1

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.

(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:

Solution