Computerised Accounting

Spreadsheet

Easy

Computerised Accounting

In what cell is the Rate for PMT function where = PMT (C8, C9, C10, C11, C12)?

C10

C12

✅ Correct Option: 1

The syntax is PMT(rate, nper, pv, fv, type). Arguments are read in order, so the first cell reference, C8, supplies the rate; C9 is nper, C10 is pv, C11 is fv and C12 is type.

2026: 6 June Shift 1

Which step completes an entry and moves the pointer to the cell to the right?

2025: 27 May Shift 2

The LOOKUP function has two syntax forms:

2025: 4 June Shift 2

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

2025: 3 June Shift 2

What kind of data is best displayed with a bar chart?

2025: 27 May Shift 1

A cell reference identifies the location of a cell or group of cells in the spreadsheet also referred as a

2025: 13 May Shift 1

Using MS Excel, we can create a basic chart by the following steps.

(A) On clicking of Start symbol we will get Programs option

(B) Click on Insert tab to get tools for chart

(D) On selecting MS Excel 2007 program it will provide a blank workbook with a Ribbon displayed at the top.

Choose the correct answer from the options given below:

In what 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)