Computerised Accounting

Spreadsheet

Medium

In which cell is the rate for PMT function where = PMT (C8, C9, C10, C11, C12)

C 10

C 12

C 8

C 9

✅ Correct Option: 3

The syntax of the PMT function is PMT(rate, nper, pv, [fv], [type]). The first argument is the interest rate. In the given formula = PMT(C8, C9, C10, C11, C12), the cell reference C8 is in the position of the rate argument. Therefore, the rate is in cell C8.

2025: 27 May Shift 2

The LOOKUP function has two syntax forms:

2025: 3 June Shift 1

The error ##### occurs when?

(A) Column is not wide enough

(B) Negative date

(D) Row is not wide enough

Choose the correct answer from the options given below:

2025: 15 May Shift 1

Where is the address of the active cell displayed?

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

2025: 3 June Shift 2

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

2026: 21 May Shift 2

Match the LIST-I with LIST-II

LIST-I (Movement)		LIST-II (Key Stroke (Press key))
A.	Beginning of the Row	I. CTRL + D
B.	Moving consecutively to the first and the last filled cells of a cluster of filled cells in a column by pressing of	II. HOME key
C.	The cell at the intersection of the last row and last column containing data	III. CTRL + Down arrow key
D.	Short-cut key to drag down	IV. CTRL + END keys

Choose the correct answer from the options given below:

In which cell is the rate for PMT function where = PMT (C8, C9, C10, C11, C12)

Solution

Related questions:

Keyboard Shortcuts

CUET Accountancy Past Year Questions (Topic-Wise)