# 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

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

A

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

B

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

A

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

C

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

A

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

B

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

C

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

A

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

C

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

A

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

B

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

A

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

D

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

D

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

D

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

D

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

B

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

B

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

D

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

A

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

C

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

A

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

B

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

A

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

A

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

C

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

B

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

C

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

D

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

B

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

A

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

D

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

A

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

A

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

B

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

A

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

D

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

D

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