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