CBSE Class 10 Information Technology Electronic Spreadsheets Advanced MCQs

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 the options

Answer: B

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

Answer: D

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

Answer: B

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

Answer: B

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 options

Answer: A

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

Answer: B

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

Answer: C

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 the options

Answer: A

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

Answer: B

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

Answer: B

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

Answer: A

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

Answer: C

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

Answer: 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

Answer: A

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

Answer: D

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

Answer: D

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

Answer: A

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

Answer: C

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

Answer: 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 the options

Answer: D

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

Answer: 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 the options

Answer: C

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

Answer: C

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

Answer: D

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 options

Answer: B

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

Answer: A

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

Answer: D

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

Answer: A

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 the options

Answer: 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 options

Answer: B

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

Answer: D

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

Answer: D

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

Answer: A

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

Answer: 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 options

Answer: A

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

Answer: A

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

Answer: C

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

Answer: A

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 options

Answer: D

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 options

Answer: A