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

Share your love

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 – IList – II
A. Rows in SpreadsheetI. Vertical Vectors
B. Columns in SpreadsheetII. A file in Excel
C. Ribbon in SpreadsheetIII. Horizontal Vectors
D. WorkbookIV. 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 – IList – II
A. Active worksheetI. Cell Reference
B. Location of a cell in spreadsheetII. Formula
C. Intersection of a row and a columnIII. Cell
D. Arithmetic expressionsIV. 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 – IList – II
A. Function used to examine cause and effect relationshipI. Count
B. Function used to add the series of cellsII. What_if Scenario
C. Function used to add cells as per criteriaIII. Autosum
D. Function that gets the number of entries in a number fieldIV. 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 – IList – II
A. Accrued interest calculating functionI. ACCRINT
B. Periodic payment calculating functionII. RATE
C. Interest Cumulatively paid between two periods calculated throughIII. PMT
D. Function computing the interest rate per periodIV. 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 – IList – II
A. Zip CodesI. Text formatting
B. PercentagesII. Special Format Category
C. Alignment of cellsIII. Number formatting
D. Analysis of dataIV. 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 – IList – II
A. Function for computing monthly installments of loan repaymentI. SLM
B. Function to compute depreciation by written Down Value MethodII NPER
C. Function to calculate depreciation through straight-line methodIII. DB
D. Total number of payments for loanIV 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

Share your love
Anurag Pathak
Anurag Pathak

Anurag Pathak is an academic teacher. He has been teaching Accountancy and Economics for CBSE students for the last 18 years. In his guidance, thousands of students have secured good marks in their board exams and legacy is still going on. You can subscribe his youtube channel and can download the Android & ios app for free lectures.

Articles: 3490

Leave a Reply

Your email address will not be published. Required fields are marked *

close

Ad Blocker Detected!

Our Website is made possible by displaying online advertisements to our visitors. Please consider supporting us and remove the AD - Blocker to read this article.

Refresh

error: Content is protected !!