Class 10 IT 402 Electronic Spreadsheet Advanced MCQs with solution are designed to help students master advanced spreadsheet concepts like formulas, functions, charts, data analysis, and formatting. MCQs from electronic spreadsheet chapters are an important part of the CBSE Class 10 IT examination, making regular practice necessary for scoring high marks. These objective questions help students develop problem-solving skills and understand spreadsheet operations effectively.
Teachers can use these Electronic Spreadsheet Advanced MCQs to conduct quizzes, assignments, and practice tests in classrooms or online learning platforms. Students searching for Class 10 IT 402 spreadsheet MCQs with answers, CBSE IT electronic spreadsheet practice questions, and Advanced spreadsheet MCQs for Class 10 board exam will find this resource extremely helpful. Regular practice ensures better conceptual clarity and boosts overall exam performance.
Electronic Spreadsheet (Advanced) and OpenOffice Calc - Class 10 Information Technology Code 402 MCQs with Solution
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 (answer can be considered)
b) Goal Seek (answer can be considered)
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
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 menus 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
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
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