CUET Accountancy MCQs Unit IV Accounting Applications of Electronic Spreadsheet

Question. The chart that displays data in rings is called ____________.
a) Series chart
b) doughnut chart
c) Pie Chart
d) Scatter Chart

Answer : B

Question. Which function will be used for calculating interest included in installment of a loan ?
a) PPMT
b) IPMT
c) FAPM
d) None of above

Answer : B

Question. Which step completes an entry and moves the pointer to the cell to the right?
a) Pressing [Enter]
b) Pressing [Tab]
c) pressing [Shift] + [Tab]
d) pressing [Shift] + [ENTER]

Answer : B

Question. Configuration of and ____________ makes a spreadsheet.
a) Values, Vectors
b) alphabets, numbers
c) ribbon, functions
d) rows, columns

Answer : D

Question. The key stroke for reaching the top of worksheet (Cell A1) is
a) CTRL + End
b) CTRL + Home
c) Home Key
d) Up Arrow Key

Answer : B

Question. The addition of numbers using a condition is through
a) SUMIF
b) AUTOSUM
c) AVERAGE
d) COUNT IF

Answer : A

Question. What is the formula for adding the value of cell A1, A2 and A3 ?
a) SUM = (A1 + A2 + A3)
b) SUM (A1,A2, A3)
c) = SUM (A1 : A3)
d) None of above

Answer : C

Question. The function that joins two or more text strings into one is
a) AUTOSUM
b) CONCATENATE
c) AND
d) JOIN

Answer : B

Question. Certain types of data, like dates, can be filled in consecutive cells in Excel by using
a) AUTOSUM
b) Fill handle
c) Highlight
d) Percentages

Answer : B

Question. Which of the following is not a financial function?
a) ACCRINT
b) CUMIPMT
C) NPV
d) ROUNDUP

Answer : D

Question. Components of Excel Workbook are :
a) Workbook
b) Worksheet
c) Chart
d) Worksheet and Chart

Answer : D

Question. the parameter not required for running the function PMT is
a) Rate
b) Nper
c) PV
d) DB

Answer : D

Question. The best way to get started in Excel is to click the ________.
a) view the toolbar
b) home tab
c) Microsoft Office Button
d) None of the above

Answer : C

Question. Which command is used to make the title Rows and Column static in case we wish to scroll the spreadsheet ?
a) Freeze and Pan command
b) Unfreez Pan command
c) Hold title command
d) Merge command

Answer : A

Question. Where is the address of the active cell displayed?
a) Row heading
b) Status bar
c) Name Box
d) Formula bar

Answer : C

Question. Which command allows you to reverse an undo command?
a) Redo
b) Repeat
c) Reset
d) Reverse

Answer : A

Question. Which mathematical operation is represented by an asterisk (*)?
a) Exponentiation
b) Addition
c) Subtraction
d) Multiplication

Answer : D

Question. Where the values and Formulae are typed in window in Excel ?
a) Title Bar
b) Short Screen menu command
c) Formula Bar
d) Standard Bar

Answer : C

Question. Which of the following arguments in a financial function represents the total number of payments?
a) FV
b) PV
c) Nper
d) Rate

Answer : C

Question. Which of these is not an argument of the IF function?
a) Logical_test
b) Value_if_false
c) Value_When_false
d) value_if_true

Answer : C

Question. In Excel, the chart tools provides three different options , and __ for formatting.
a) Layout, Format, Data Marker
b) Design, Layout, Format
c) Chart Layouts, chart Style, Label
d) Format, Layout, Label

Answer : B

Question. Data and Formulae are copied through :
a) Cut, Copy ,Paste in edit menu
b) Sort, screen, menu command
c) Standard tool bar
d) All of above

Answer : D

Question. The 2D graph use , _ axes and in 3D graph _ axis is also used.
a) Category, value, vertical
b) Horizontal, Vertical, depth
c) Category, value, series
d) 2) and 3) both

Answer : C

Question. Which of these purposes do not pertain to charts?
a) Identifying trends
b) Selecting values
c) Recognising patterns
d) Making comparisons

Answer : B

Question. Which of the following purposes is not served by a spreadsheet?
a) Security of data
b) Calculate data
c) Record data
d) Compare data

Answer : A

Question. Which formula is incorrect?
a) = (10 +15)
b) = (B7 * B1)
c) (B7 + 14)
d) 14 +15

Answer : D

Question. ‘What-if’ Scenarios are also called ___________.
a) Labels
b) Data entry
c) Nested conditional operations
d) References

Answer : C

Question. ROUNDDOWN (-7.13169, 1) WILL yield the following result:
a) 7.13
b) 7.1
c) -7.1
d) -7

Answer : C

Question. Where can you find the option to enable fill handle?
a) ‘Editing options’ under ‘Advanced’
b) ‘Copy’ under ‘Notepad’
c) ‘Cell Styles’ under ‘Styles’ group
d) ‘Print Area’ under ‘page Setup’ group

Answer : A

Question. Which function is used to calculate depreciation?
a) SLN
b) PRF
c) DVD
d) LTF

Answer : A

Question. When does a #DIV/01 Error Occur?
a) When dividend computed is equal to Zero
b) When a number is divided by Zero
c) When zero is divided by a number
d) When a number is multiplied by Zero

Answer : B

Question. Which key combination collapses the ribbon?
a) [Ctrl]+[F1]
b) [Ctrl]+[F3]
c) [Ctrl]+[F5]
d) [Ctrl]+[F7]

Answer : A

Question. What is the syntax for calculating depreciation on written down value method ?
a) = DB ( Cost,Salvage,life,1)
b) = FB (Cost,25,1)
c) = PFB (Cost,Salvage,life)
d) None of above

Answer : A

Question. When navigating in a workbook, which command is used to move to the beginning of the current row?
a) [Ctrl]+[Home]
b) [Page Up]
c) [Home]
d) [Ctrl]+[backspace]

Answer : C

Question. Which function automatically totals a column or row of values?
a) TOTAL
b) ADD
c) SUM
d) AVG

Answer : C

Question. What category of functions is used in this formula: = PMT (C10/12, C8, C9,1)?
a) Logical
b) Financial
c) payment
d) Statistical

Answer : B

Question. Function for calculating principal amount in installment will be :
a) RPT
b) PMT
c) PPMT
d) IPMT

Answer : C

Question. To change the location of a chart, right-click the chart and select
a) Chart Type
b) Source Data
c) Chart Options
d) Move here

Answer : D

Question. Doughnut Charts
a) contains more than one data series
b) Are comparable with Pie chart
c) Both 1) and 2)
d) None of the above

Answer : C

Question. Which group on the Chart Tools Format tab shows the name of the selected element?
a) Arrange Objects
b) Chart Objects
c) Choose Selection
d) Current Selection

Answer : D

Question. In the formula “Compound Interest = Maturity Value – Principle Amount”, Maturity Value is the __ Value.
a) Basic
b) Formula
c) Derived
d) Cell

Answer : A

Question. The ‘Now’ function in Excel provides
a) Serial number of the current date
b) Current date and time
c) Current Time
d) Difference of two dates

Answer : B

Question. Certain types of data, like dates, can be filled in consecutive cells in Excel by using
a) AUTOSUM
b) Fill handle
c) Highlight
d) Percentages

Answer : C

Question. Which of the following can not be done by using the ‘shape’ Fill’ feature?
a) Change shape outline
b) change or remove colour
c) Fill the shape with a picture
d) Fill the shape with texture

Answer : A

Question. As you type a number in a cell, what mode appears in the status bar?
a) Enter Mode
b) Ready Mode
c) Edit Mode
d) Record Mode

Answer : A

Question. Which cell alignment is assigned to most values by default?
a) Right
b) Left
c) Centre
d) Decimal

Answer : B

Question. Which formula would result in TRUE if C4 is less than 10 and D4 is less than 100?
a) =AND(C4.10, D4>10)
b) =AND(C4>10, C4<100)
c) =AND(C4>10, D4<10)
d) =AND(C4<10, D4<100)

Answer : D

Question. Column Charts are useful for __________.
a) Showing data changes over a period of time
b) Illustrating comparisons among items
c) Both 1) and 20
d) None of the above

Answer : C

Question. What do you see if you move the mouse over a chart object?
a) KeyTip
b) ScreenTip
c) chartTip
d) ChartKey

Answer : C

Question. A cell reference that keeps either row or column constant when the formula is copied to another location is
a) Absolute reference
b) Relative reference
c) Mixed reference
d) Fixed reference

Answer : C

Question. Question. Which function searches and matches first the required value from the column of a range of cells, and then returns a value from any cell of the same row of the range?
a) CONCATENATE
b) VLOOKUP
c) HLOOKUP
d) COUNTA

Answer : B

Question. when does # N/A error occur?
a) when no value is available to a function
b) when Excel doesn’t recognise text in a formula
c) When a column is not wide enough
d) when a wrong letter has been written in a cell

Answer : A

Question. Which function results can be displayed in AutoCalculate?
a) SUM and Average
b) MAX and LOOK
c) LABEL and AVERAGE
d) MIN and BLANK

Answer : A

Question. In what cell is the Rate for PMT function where =PMT(C8, C9, C10, C11, C12)?
a) C8
b) C9
c) C10
d) C12

Answer : A

Question. Legend can be repositioned on the chart
a) anywhere
b) on right side only
c) on the bottom of X-axis
d) on the corner only

Answer : A

Question. Every Formula must start with
a) An = Sign
b) A + Sign
c) A label
d) A cell Reference

Answer : A

Question. The function CUMIPMT yields
a) Total number of payment periods in an annuity
b) Total interest accrued for a security
c) Interest rate per period of an annuity
d) Cumulative interest paid between two periods

Answer : D

Question. which view shows margins ad the rulers?
a) Normal
b) Page Layout
c) page Setup
d) Review

Answer : B

Question. Which of the following options in a financial function indicates the interest for a period?
a) FV
b) PV
c) Nper
d) Rate

Answer : B

Question. Pie charts don’t have more than ___________ categories.
a) Ten
b) Twenty Five
c) Seven
d) Three

Answer : C

Question. Which chart element details the data values and categories below the chart?
a) Data point
b) Data labels
c) Data marker
d) Data table

Answer : B

Question. Behind every computed number in an Excel-Sheet, Excel is hiding
a) Labels
b) Worksheet names
c) Rows and columns
d) Cell References

Answer : D

Question. The situation wherein warning messages are displayed when users type wrong data in a cell is due to which feature?
a) Data Entry
b) Pivot Table
c) Data validation
d) Mathematical Function

Answer : C

Question. Which command reverses the last action performed in the worksheet?
a) Cut
b) Undo
c) Redo
d) Paste

Answer : B

Question. How many blank worksheets are shown when a new workbook is created?
a) one
b) Two
c) Three
d) Four

Answer : C

Question. Excel automatically redraws the chart _______________.
a) if any change is made in data
b) if any change is made in the range data
c) Both 1) and 2)
d) None of the above

Answer : C

Question. Num-digits in the ROUND function’s syntax specifies
a) Number to round
b) Cells to evaluate
c) Cells to count
d) Number of digits to round the number to

Answer : D

Question. Which of the following charts can not be made on Excel 2007?
a) Pie
b) Area
c) Scatter
d) Visual Reality

Answer : D

Question. When Extend Selection is active, What is the keyboard shortcut for selecting all data up to end including the last row?
a) [Ctrl]+[Down Arrow]
b) [Ctrl]+[Home]
c) [Ctrl]+[Shift]
d) [Ctrl]+{Up Arrow]

Answer : C

Question. once we have created a chart we may change __________.
a) the formatting for text like titles and data labels
b) only by going back through the ribbon
c) everything about the chart
d) the data series patterns only

Answer : A

Question. Which function searches for a value in the firt row of a table array and returns the corresponding value in the same column from another row of the same table array?
a) VLOOKUP
b) CONCATENATE
c) HLOOKUP
d) COUNTIF

Answer : C

Question. Which key when pressed displays the access keys?
a) [Alt]
b) [Ctrl]
c) [Shift]
d) [Esc]

Answer : A

Question. The Ribbon allows us to
a) Create either an embedded chart or a chart sheet chart
b) Create only an embedded chart
c) Create only a chart Sheet chart
d) Change the data values used to create the chart

Answer : D

Question. Which of the following is used to present information with an enhanced layout, attractive and well-formatted report?
a) HLOOKUP
b) VLOOKUP
c) PIVOT TABLE
d) Two-variable data Table

Answer : C

Question. A sheet in which data and information is arranged in rows and columns is called
a) paper sheet
b) notebook
c) spreadsheet
d) All of the above

Answer : C

Question. In written down value method, the value of the asset
a) remain same
b) does not remain same
c) depending up on the type of the business
d) Either (a) or (b)

Answer : B

Question. Spreadsheets are also known as
a) worksheets
b) paper sheet
c) notebook
d) All of these

Answer : A

Question. What happens when there is a change in source data of an electronic spreadsheet?
a) The results needs to be recalculated manually
b) It can recalculate the result automatically
c) Either (a) or (b)
d) Neither (a) nor (b)

Answer : B

Question. In the given syntax, (rate, nper, pv, fv) pv stands for
a) post value
b) past value
c) present value 
d) pre volume

Answer : C

Question. Spreadsheets can also be used to
a) generate accounting information
b) video editing
c) electronic mail
d) All of the above

Answer : A

Question. The basic elements of an electronic spreadsheets include
a) workbook and worksheets
b) rows, columns and cells
c) Both (a) and (b)
d) None of the above

Answer : C

Question. Which of the following applications can be used to prepare various accounts and statements like balance sheet?
a) Adobe reader
b) Electronic spreadsheet
c) Microsoft word
d) None of the above

Answer : B

Question. Which of the following is a type of electronic spreadsheet?
a)Microsoft Excel
b) Google sheets
c) Lotus 123
d) All of the above

Answer : D

Question. What are the other areas in which an electronic spreadsheet can be used?
a) Payment tracking
b) Loan repayment schedules
c) Payroll
d) All of the above

Answer : D

Question. Different formulas can be used to calculate depreciation depending upon
a) system
b) humanware
c) method of depreciation
d) All of these

Answer : C

Question. In which method, the amount of depreciation remains fixed over the life of the asset?
a) Written down value method
b) Straight line method
c) Either (a) or (b)
d) Neither (a) nor (b)

Answer : B

Question. In which method, depreciation is charged on the diminishing balance of the asset?
a) Written down value method
b) Straight line method
c) Either (a) or (b)
d) Neither (a) nor (b)

Answer : A

Question. Mathematical formulas are provided in
a) electronic spreadsheets
b) paper sheets
c) notebooks
d) None of the above

Answer : A

Question. The schedule which lists the loss in the value of the asset over a period of time is known as ………… .
a) depreciation schedule
b) payment tracking schedule
c) loan requirement schedule
d) none of the above

Answer : A

Question. The syntax used to calculate the amount of depreciation using written down value method is
a) WDV
b) DBM
c) DEP
d) DB

Answer : D

Question. Which schedule helps in knowing the amount that needed to be paid back through a series of periodic payments?
a) Payment tracking
b) Payroll accounting
c) Depreciation schedule
d) None of these

Answer : D

Question. Which application can be used to find out the profit or loss of the business?
a) Adobe reader
b) Microsoft word
c) Electronic spreadsheet
d) None of the above

Answer : C

Question. The syntax used to calculate the amount of periodic payments is
a) PPA
b) PMT
c) PMA
d) PMO

Answer : B

Question. A ………… is a list of employees working in an organisation and receiving payments and other work related benefits.
a) payment tracking
b) payroll accounting
c) depreciation schedule
d) None of the above

Answer : B

Question. Which of the following are the features of electronic spreadsheets?
a) Easy to learn and does not require any special training
b) Data is not presented in tables
c) Information can be provided in the form of charts and graphs
d) Both (a) and (c)

Answer : D

Question. In the given syntax, (rate, nper, pv, fv) nper means
a) number of years
b) principal amount
c) interest rate
d) number of payment period for an investment

Answer : D

Question. The syntax used to calculate the amount of depreciation using straight line method is
a) OCM
b) SLN
c) SLMD
d) DEP

Answer : B

Question. Payroll is easy to maintain in ………… .
a) manually system
b) electronic form
c) virtually
d) All of the above

Answer : B