MCQ Questions For Class 10 Information Technology Chapter 2 Electronic Spreadsheets Advanced

Students can refer to the following Electronic Spreadsheets Advanced MCQ Questions for Class 10 with Answers provided below based on the latest curriculum and examination pattern issued by CBSE and NCERT. Our teachers have provided here a collection of multiple choice questions for Electronic Spreadsheets Advanced Class 10 covering all topics in your textbook so that students can assess themselves on all important topics and thoroughly prepare for their exams

Electronic Spreadsheets Advanced MCQ Questions for Class 10 Information Technology with Answers

We have provided below Electronic Spreadsheets Advanced MCQ Questions for Class 10 with answers which will help the students to go through the entire syllabus and practice multiple choice questions provided here with solutions. As Electronic Spreadsheets Advanced MCQs for Class 10 Information Technology pdf download can be really scoring for students, you should go through all problems provided below so that you are able to get more marks in your exams.

Question. When you open a new spreadsheet, by default it has sheet named ______________.
(a) Sheet1
(b) Sheet_1
(c) Sheet 1
(d) None of the above

Question. In Subtotals we can select up to _______ groups of arrays.
(a) 2
(b) 3
(c) 4
(d) Infinite

Question. Absolute link will stop working only if the target is move(d)
(a) True
(b) False

Question. Scenarios are tools to test _________ questions.
(a) if else
(b) what else
(c) what if
(d) if

Question. Which option is suitable to calculate the effect of different interest rates on an investment.
(a) Scenario
(b) Subtotal
(c) Consolidate
(d) None of these

Question. After sharing the worksheet, the word ___________ is then shown on the title bar after the worksheet’s title
(a) Sharing
(b) Shared
(c) Sharing Sheet
(d) None of the above

Question. Click _____________ to stop the macro recorder
(a) Close Recording
(b) End Recording
(c) Stop Recording
(d) None of the above

Question. We can give different colours to different scenarios?
(a) True
(b) False

Question. ____________ is more elaborate form of Goal Seek.
(a) Scenario
(b) Subtotal
(c) Solver
(d) All of these

Question. Raman and his friends wants to work together in a spreadsheet. They can do so by
(a) Sharing Workbook
(b) Linking Workbook
(c) Both a and b
(d) None of these

Question. After sharing a worksheet, ___________ is seen in the title bar after the worksheet’s title.
(a) Sharing
(b) Shared
(c) Sharing Sheet
(d) None of these

Question. Share document option available in _________ menu.
(a) Tools
(b) View
(c) Edit
(d) File

Question. Which of the following buttons are present on “Resolve Conflict” dialog box which appear during saving shared worksheet.
(a) Keep Mine
(b) Keep Other
(c) Keep All Mine
(d) All of these

Question. A __________ coloured border, appears around a cell where changes were made in shared worksheet.
(a) Blue
(b) Yellow
(c) Green
(d) Red

Question. Define range option is available under ________ menu.
(a) Insert
(b) View
(c) Developer
(d) Data

Question. A deleted column or row in shared worksheet is marked by a ______________ coloured bar.
(a) Light
(b) Line (c) Solid
(d) Heavy

Question. Edited worksheet can be compared with the original worksheet by selecting.
(a) File –> Compare Document
(b) Edit –> Compare Document
(c) View –> Compare Document
(d) Tools –> Compare Document

Question. Macros are especially useful to ___________ a task.
(a) do
(b) repeat
(c) simplify
(d) complicate

Question. Hyperlink in Calc can be used
(a) to jump from one sheet to another sheet.
(b) to jump from one sheet to website
(c) to jump from one section to another section of same sheet
(d) All of the above

Question. We can give different colors to different scenario?
(a) True
(b) False

Question. When a document is created and saved, it automatically contains a library named ___
(a) Module Library
(b) Macro Library
(c) Standard
(d) None of these

Question. To edit macro, go to
(a) Tools –> Macros — > Edit Macros
(b) Edit –> Macros — > Edit Macros
(c) View –> Macros — > Edit Macros
(d) None of the above

Question. Function names in Calc are not case sensitive.
(a) True
(b) False

Question. Use ___________ Macro to start the macro recorder.
(a) Tools > Macros > Record
(b) Tools > Record > Record Macro
(c) Data > Macros > Record
(d) None of these

Question. Share document option available in _____ menu.
(a) Tools
(b) View
(c) Edit
(d) File

Question. Goal Seek Option available in _____________menu.
(a) Data
(b) Format
(c) Tools
(d) Insert

Question. Data can be consolidated from two sheets only.
(a) True
(b) False

Question. We can consolidate data by ________
(a) Row Label
(b) Column Label
(c) Both of the above
(d) None of the above

Question. Which of the following functions are available in consolidate window?
(a) Max
(b) Min
(c) Count
(d) All of the above

Question. In which option we have to specify the target range(Where we want the result to be displaye(d)
(a) Source data range
(b) Copy results to
(c) Need result at
(d) target range

Question. Which feature of Calc help to see the changes made in the shared worksheet?
(a) Record Changes
(b) Solver
(c) Subtotal
(d) None of the above

Question. A deleted column or row in shared worksheet is marked by a ______________ colored bar.
(a) Light
(b) Line
(c) Solid
(d) Heavy

Question. After adding comment to a changed cell of shared worksheet, we can see it by hovering the mouse pointer over the cell
(a) True
(b) False

Question. Worksheets can be merged from ____________________ menu.
(a) Edit
(b) File
(c) View
(d) Tools

Question. When sharing worksheets authors may forget to record the changes they make. Calc can find the changes by __________ worksheets
(a) duplicating
(b) comparing
(c) checking
(d) None of the above

Question. We can link a text in spreadsheet to any Web URL.
(a) True
(b) False

Question. Consolidate option is available under _________ menu.
(a) View
(b) Tool
(c) Insert
(d) Data

Question. Hyperlink dialog box in Calc shows ________ options on left hand side.
(a) Internet
(b) Document
(c) New Document
(d) All of the above

Question. A _____________ is a saved sequence of commands or keystrokes that are stored for later use
(a) Solver
(b) Autosum
(c) Consolidate
(d) Macro

Question. Anil is the author of shared worksheet so he has the right to accept or reject changes made by the reviewers.
(a) True
(b) False