[CUET] Matching Type MCQs of Accounting Applications of Electronic Spreadsheet

Are you looking for the CUET matching type MCQs with answers of Accounting Applications of Electronic Spreadsheet for B.com entrance exam.

We have curated a list of important MCQs of the computerised accounting topic from the syllabus of cuet.

Matching Type Multiple choice Questions of Accounting Applications of Electronic Spreadsheet with answers

Let’s Practice

Match List I with List II.

List – I	List – II
A. Rows in Spreadsheet	I. Vertical Vectors
B. Columns in Spreadsheet	II. A file in Excel
C. Ribbon in Spreadsheet	III. Horizontal Vectors
D. Workbook	IV. Series of Horizontal Tabs

Choose the correct option:

1. A – III, B – I, C – IV and D – II
2. A – I, B – III, C – IV and D – II
3. A – IV, B – III, C – I and D – II
4. A – III, B – I, C – II and D – IV

Ans – 1)

Match List I with List II.

List – I	List – II
A. Active worksheet	I. Cell Reference
B. Location of a cell in spreadsheet	II. Formula
C. Intersection of a row and a column	III. Cell
D. Arithmetic expressions	IV. Only one at a time

Choose the correct option:

1. A – IV, B – III, C – I and D – II
2. A – II, B – I, C – III and D – IV
3. A – III, B – II, C – I and D – IV
4. A – IV, B – I, C – III and D – II

Ans – 4

Match List I with List II

List – I	List – II
A. Function used to examine cause and effect relationship	I. Count
B. Function used to add the series of cells	II. What_if Scenario
C. Function used to add cells as per criteria	III. Autosum
D. Function that gets the number of entries in a number field	IV. SumIF

Choose the correct option:

1. A – IV, B – III, C – II and D – I
2. A – II, B – III, C – IV and D – I
3. A – II, B – IV, C – III and D – I
4. A – IV, B – II, C – I and D – II

Ans – b)

Match List I with List II.

List – I	List – II
A. Accrued interest calculating function	I. ACCRINT
B. Periodic payment calculating function	II. RATE
C. Interest Cumulatively paid between two periods calculated through	III. PMT
D. Function computing the interest rate per period	IV. CUMIPMT

Choose the correct options:

1. A – I, B – IV, C – III and D – II
2. A – II, B – IV, C – III and D – I
3. A – I, B – III, C – IV and D – II
4. A – II, B – III, C – IV and D – I

Ans – c)

Match List I with List II.

List – I	List – II
A. Zip Codes	I. Text formatting
B. Percentages	II. Special Format Category
C. Alignment of cells	III. Number formatting
D. Analysis of data	IV. Conditional formatting

Choose the correct option:

1. A – IV, B – II, C – I and D – III
2. A – II, B – III, C – I and D – IV
3. A – III, B – II, C – I, D – IV
4. A – I, B – III, C – IV, D – II

Ans – b)

Match List I with List II.

List – I	List – II
A. Function for computing monthly installments of loan repayment	I. SLM
B. Function to compute depreciation by written Down Value Method	II NPER
C. Function to calculate depreciation through straight-line method	III. DB
D. Total number of payments for loan	IV PMT

Choose the correct option:

1. A – II, B – I, C – III, D – IV
2. A – IV, B – I, C – III, D – II
3. A – IV, B – III, C – I and D – II
4. A – II, B – III, C – I and D – IV

Ans – 3