Class 10 – IT 402 Electronic Spreadsheet (Advanced) / OpenOffice Calc – MCQs

by

Class 10 – Part A – Unit 2 – Electronic Spreadsheet (Advanced) / OpenOffice Calc – MCQs

Find Exam oriented Multiple Choice Questions for Class 10 IT (Code 402) from Electronic Spreadsheet (Advanced) and OpenOffice Calc Unit NCERT- Based MCQs: Practice makes perfect! Here, we’ve curated a set of Solved NCERT-based multiple-choice questions to test your understanding of the Self Managemtn Skills Unit of Class 10 – Information Technology (Code 402) session and chapter-wise. These MCQs are designed to help you gauge your knowledge and identify areas for improvement for CBSE examination.

Electronic Spreadsheet (Advanced) and OpenOffice Calc Class 10 MCQs

Topic – Electronic Spreadsheet (Advanced) and OpenOffice Calc Class 10 MCQs

MCQ 1: A colored border, with ____, appears around a cell where changes are made in a shared worksheet. [CBSE 2023]
a) a dot in the upper left-hand corner
b) a dot in the lower left-hand corner
c) a cross in the upper left-hand corner
d) a cross in the upper right-hand corner

MCQ 2: ____ feature adds data arranged in a group of cells in Calc with labels for columns and/or rows. [CBSE 2023]
a) Average
b) Subtotal
c) Goal Seek
d) Solver

MCQ 3: A ____ refers to a cell or range of cells on a worksheet whose data values can be used in a formula. [CBSE 2023]
a) sheet
b) cell
c) cell reference
d) cell data

MCQ 4: ____ feature of Calc is used to test ‘what-if’ questions. [CBSE 2023]
a) Solver
b) Goal Seek
c) Scenario
d) Styles

MCQ 5: Macros are especially useful to ____ the same way over and over again. [CBSE 2023]
a) repeat a task
b) reject a task
c) report a task
d) comment a task

MCQ 6: ____ feature of Calc helps to track what data was changed, when the change was made, who made the change and in which cell the change occured. [CBSE 2023]
a) Record Changes
b) Edit Record
c) Change Record
d) Macro

MCQ 7: Which of the following type of package does Calc refer to?
a) Spreadsheet
b) Multi sheet
c) Double sheet
d) Cannot be determined

MCQ 8: Which of the following applications is not suitable for Calc?
a) Balance sheet preparation
b) Result analysis
c) Presenting an idea about a product
d) All of the above

MCQ 9: Which of the following is the extension of a worksheet created in Calc?
a) .ods (open document spreadsheet)
b) .odd
c) .xls
d) .obj

MCQ 10: Which of the following will be inserted in a worksheet if =starcalcteam() is inserted in a Calc Cell?
a) Stars
b) Photograph of Calc developer team
c) Calc license information
d) Calc version information

Find exam-oriented chapter or unit-wise multiple-choice questions (MCQs) based on MS Office and OpenOffice for CBSE Class 10 to help you prepare for examinations

MCQ 11: How can one calculate total of values entered in a worksheet in a Calc document?
a) By manual entry
b) By AutoSum
c) By formula
d) All of these

MCQ 12: If we move a cell containing a formula having reference to another cell in the worksheet, what will happen to the cell numbers used in formula?
a) The cell row and columns are changed at destination
b) The cell row numbers are changed at destination
c) The cell column numbers are changed at destination
d) Nothing will be changed

MCQ 13: Which option is used to open Calc program?
a) Applications > Office > OpenOffice.org spreadsheet
b) Applications > OpenOffice > OpenOffice.org spreadsheet
c) Start > Office > > OpenOffice.org spreadsheet
d) Start > OpenOffice > OpenOffice.org spreadsheet

MCQ 14: Which type of package is Calc?
a) Word processor
b) Spreadsheet
c) Database
d) Presentation

MCQ 15: In Calc, how many spreadsheets are there by default?
a) 2
b) 3
c) 4
d) 5

MCQ 16: How many worksheets are available in spreadsheet document?
a) 24
b) 64
c) 256
d) 65536

MCQ 17: How many menu are available in Calc?
a) 6
b) 7
c) 8
d) 9

MCQ 18: Which sign is available on bottom right side of the active cell?
a) +
b) #
c) -
d) *

MCQ 19: How many rows are there in Calc?
a) 65516
b) 65526
c) 1 to 65536
d) 65546

MCQ 20: How many columns are there in Calc?
a) 226
b) 236
c) 246
d) 256

Find exam-oriented chapter or unit-wise multiple-choice questions (MCQs) based on MS Office and OpenOffice for CBSE Class 10 to help you prepare for examinations

MCQ 21: Which is the basic element of a spreadsheet?
a) Cell
b) Worksheet
c) Workbook
d) Row and column

MCQ 22: In which form scrollbar is seen in Calc?
a) Horizontal
b) Vertical
c) Both a) and b)
d) One of these

MCQ 23: Which background does current worksheet tab name have?
a) Black
b) White
c) Red
d) Green

MCQ 24: To add or remove toolbar, which option is used?
a) File > toolbars
b) Insert > toolbars
c) View > toolbars
d) Format > toolbars

MCQ 25: Which menu option is used to rename a worksheet?
a) Format > sheet > rename
b) Format > sheet > modify
c) Edit > sheet > rename
d) Edit > sheet > modify

MCQ 26: Which Menu option is used in Calc to add new worksheet?
a) File > sheet
b) View > sheet
c) Insert > sheet
d) Tools > sheet

MCQ 27: Which menu option is used to save worksheet in Calc?
a) File > save
b) File > store
c) File > add
d) File > set

MCQ 28: Which symbol is used for multiplication in Calc?
a) &
b) *
c) #
d) @

MCQ 29: Which symbol is necessary to write at the starting of formula?
a) =
b) #
c) @
d) *

MCQ 30: Which key is pressed to see the result after entering formula in Calc?
a) Insert key
b) Ctrl key
c) Enter key
d) Shift key

Find exam-oriented chapter or unit-wise multiple-choice questions (MCQs) based on MS Office and OpenOffice for CBSE Class 10 to help you prepare for examinations

MCQ 31: To show cell range in Calc, which symbol is used to separate the first cell address and the last cell address?
a) .
b) ,
c): (colon)
d) ;

MCQ 32: Which of the following option is used to add the values between cell A1 to A5 in Calc?
a) = A1 + A2 + A3 + A4 + A5
b) =Sum(A1:A5)
c) Σ button
d) All of these

Leave a Comment