CBSE Class 10 Computer Science Electronic Spreadsheet Advanced

Question. How many options are shown on the left-hand side of the Hyperlink dialog box in Calc?
a. New Document
b. Internet
c. Document
d. All of the above
Answer : D

Question. How can you consolidate data in SpreadSheet?
a. By Column Label
b. By Row Label
c. Both a) and b)
d. None of the above
Answer : C

Question. Can we link one worksheet to another worksheet?
a. True
b. False
Answer : A

Question. What color border appears around a cell where changes were made in a shared worksheet?
a. Green
b. Red
c. Blue
d. Yellow
Answer : B

Question. What is the formula to refer to cell A3 in sheet named S1?
a. =S1.A3
b. =”S1″.A3
c. =S1A3
d. None of the above
Answer : A

Question. Which of the following modifications is not recorded in a shared worksheet?
a. Changes to any text
b. Cell formatting
c. Changes to any number
d. None of the above
Answer : B

Question. How can Suman and her friends work together in a spreadsheet?
a. By linking workbooks
b. By sharing a workbook
c. Both a) and b)
d. None of the above
Answer : B

Question. How can Calc find the changes made to a shared worksheet?
a. Comparing worksheets
b. Duplicating worksheets
c. Checking worksheets
d. None of the above
Answer : A

Question. How can we register a data source in OpenOffice.org?
a. Choose View > Options > OpenOffice.org Base > Databases
b. Choose Format > Databases > Options > OpenOffice.org Base
c. Choose Tools > Options > OpenOffice.org Base > Databases
d. None of the above
Answer : C

Question. What is the name of the library automatically included in a Calc document when it is created and saved?
a. Macro Library
b. Standard
c. Module Library
d. None of the above
Answer : B

Question. How can an existing sheet be renamed in Calc?
a. Right click on existing sheet and then choose rename
b. Double click on one of the existing sheet
c. Both a) and b)
d. None of the above
Answer : C

Question. Is it true or false that when you print a spreadsheet, only the content of the active scenario is
printed?
a. True
b. False
Answer : A

Question. After sharing a worksheet, what word is displayed on the title bar after the worksheet’s title?
a. Shared
b. Sharing Sheet
c. Sharing
d. None of the above
Answer : A

Question. In which menu can you find the Scenarios option in SpreadSheet?
a. Windows
b. Data
c. Insert
d. Tools
Answer : D

Question. What is the correct sequence to apply Subtotals?
a. Choose the data first, then launch the Subtotals window.
b. Open the Subtotals window first, and then choose the data to which subtotals should be applied.
c. Both a) and b)
d. None of the above.
Answer : A

Question. Which menu is used to insert a new sheet in Calc?
a. Insert
b. Tool
c. Format
d. Edit
Answer : A

Question. Do each scenario in SpreadSheet have a name?
a. True
b. False
Answer : A

Question. In which menu is the Goal Seek option available?
a. Insert
b. Tools
c. Data
d. Format
Answer : B

Question. To compare an edited worksheet with the original worksheet, which option should be selected?
a. File –> Compare Document
b. View –> Compare Document
c. Tools –> Compare Document
d. Edit –> Compare Document
Answer : D

Question. Hyperlink option is available in which menu in Calc?
a. Insert
b. Edit
c. File
d. Format
Answer : A

Question. When a new spreadsheet is opened, what is the default name of the first sheet?
a. Sheet1
b. Sheet 1
c. Sheet_1
d. None of the above
Answer : A

Question. In which menu is the Solver option available?
a. Edit
b. Format
c. Insert
d. Tools
Answer : D

Question. In which menu is the “Share Document” option available?
a. Edit
b. File
c. Tools
d. View
Answer : C

Question. If you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative hyperlink will:
a. may work
b. not work
c. work
d. None of the above
Answer : C

Question. What elements are present in the “Insert Sheet” dialog box?
a. After Current Sheet
b. No. of Sheets
c. Before Current Sheet
d. All of the above
Answer : D

Question. Where should one go to edit a macro in Calc?
a. View > Macros > Edit Macros
b. Format > Macros > Edit Macros
c. Tools > Macros > Edit Macros
d. None of the above
Answer : C

Question. Where can you find the Consolidate option in SpreadSheet?
a. Insert
b. View
c. Data
d. Tool
Answer : C

Question. How can users activate the Record Changes feature in a shared worksheet?
a. Edit > Changes > Record from the menu bar.
b. View > Changes > Record from the menu bar.
c. File > Changes > Record from the menu bar.
d. Insert > Changes > Record from the menu bar.
Answer : A

Question. What kind of colored bar marks a deleted column or row in a shared worksheet?
a. Line
b. Solid
c. Light
d. Heavy
Answer : D

Question. Where are the sheet tabs located by default in a spreadsheet?
a. Top
b. Bottom
c. Middle
d. None of the above
Answer : B

Question. From which menu can worksheets be merged in Calc?
a. View
b. Tools
c. Edit
d. File
Answer : C

Question. To select multiple random cells, what key should you hold down as you click on each cell?
a. Alt
b. Ctrl
c. Shift
d. All of the above
Answer : B

Question. Can spreadsheet software allow users to share a workbook?
a. True
b. False
Answer : A

Question. Which option is appropriate to determine how different interest rates will affect an investment?
a. Scenario
b. Consolidate
c. Subtotal
d. None of the above
Answer : A

Question. Where is the Hyperlink icon present in Calc?
a. Standard Toolbar
b. Format Toolbar
c. Menu Bar
d. None of the above
Answer : A

Question. Subtotals refer to the process of _________ data arranged in an array (a group of cells).
a. finding
b. adding
c. clearing
d. averaging
Answer : B

Question. How can you shift from one scenario to another in SpreadSheet?
a. Navigator
b. Data Source
c. Find and Replace
d. None of the above
Answer : A. Navigator

Question. What option is used to give a name to a range of cells in SpreadSheet?
a. Define Range
b. Target name
c. Select Range
d. Cell Range
Answer : A

Question. What is the default name of the first scenario created in Sheet1 of Calc?
a. Sheet_1_Scenario_1
b. Sheet1_Scenario1
c. Sheet_1_Scenario1
d. Sheet1_Scenario_1
Answer : D

Question. Which option should be used to start the macro recorder in Calc?
a. Tools > Record > Record Macro
b. Tools > Macros > Record Macro
c. Data > Macros > Record
d. None of the above
Answer : B

Question. What is the main purpose of using macros in Calc?
a. To simplify a task
b. To complicate a task
c. To do a task
d. To repeat a task
Answer : D

Question. In which menu can you find the Subtotals option?
a. Data
b. Tools
c. Insert
d. Format
Answer : A. Data

Question. Which option is a more elaborate form of Goal Seek?
a. Subtotal
b. Solver
c. Scenario
d. All of the above
Answer : B. Solver

Question. If you select this option, any values modified in the source range are automatically updated in the target range in SpreadSheet.
a. Link to original data
b. Link to source data
c. Link to source range
d. Link to sheet data
Answer : B

Question. How many types of hyperlinks are shown on the left-hand side of the Hyperlink dialog box in
Calc?
a. 1
b. 2
c. 3
d. 4
Answer : D

Question. In Calc, where is the link to external data option present in the menu?
a. Insert
b. View
c. File
d. Edit
Answer : A

Question. Which option allows you to specify where you want the result to be displayed when consolidating data in SpreadSheet?
a. Source data range
b. Target result at
c. Copy results to
d. Delete range
Answer : C

Question. How can hyperlinks in Calc be used?
a. to jump from one sheet to a website
b. to jump from one section to another section of the same sheet
c. to jump from one sheet to another sheet
d. All of the above
Answer : D

Question. Is the Comment in the Create Scenario dialog box optional?
a. True
b. False
Answer : A

Question. A relative hyperlink will stop working only if the target is moved.
a. True
b. False
Answer : B

Question. Can hyperlinks in Calc be either relative or absolute?
a. True
b. False
Answer : A

Question. What feature allows you to collect data from different worksheets and combine it into a single master worksheet?
a. Solver
b. Goal Seek
c. Data Consolidation
d. Total data
Answer : C

Question. What feature in Calc allows users to view changes made in a shared worksheet?
a. Solver
b. Subtotal
c. Record Changes
d. None of the above
Answer : C

Question. How can users add a comment regarding any changes made in a shared worksheet?
a. File > Changes > Comments
b. View > Changes > Comments
c. Edit > Changes > Comments
d. None of the above
Answer : C

Question. Can we give different colors to different scenarios?
a. True
b. False
Answer : A

Question. Which of the following features are disabled in a shared spreadsheet?
a. Insert > Names
b. Insert > Comment
c. Edit > Changes, except for Merge Document
d. All of the above
Answer : D

Question. How many groups of arrays can you select in Subtotals?
a. 3
b. 4
c. 5
d. 6
Answer : A

Question. Are function names in Calc case sensitive?
a. True
b. False
Answer : B

Question. In Calc, which menu can open the “Share Document” dialog box?
a. Edit
b. View
c. File
d. Tools
Answer : D

Question. Is it true or false that you can only consolidate data from two sheets?
a. True
b. False
Answer : B