CBSE Class 10 Computer Science Electronic Spreadsheet Advanced

Question. Can a new sheet be renamed in Calc?
a. While inserting a new sheet
b. After inserting a new sheet
c. Both a) and b)
d. None of the above
Answer : C

Question. How many sheets are present in a spreadsheet by default?
a. 2
b. 3
c. 4
d. 5
Answer : B

Question. What is the purpose of the Record Changes feature in Calc?
a. To record the screen.
b. To make changes permanent.
c. To allow authors and reviewers to know which cells were edited.
d. None of the above.
Answer : C

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

Question. Can we link a text in a spreadsheet to any web URL in Calc?
a. True
b. False
Answer : A

Question. Can multiple users access a shared workbook simultaneously?
a. True
b. False
Answer : A

Question. Once a spreadsheet is shared, can it be unshared?
a. True
b. False
Answer : B

Question. What is a saved sequence of commands or keystrokes in Calc called?
a. Solver
b. Macro
c. Autosum
d. Consolidate
Answer : B

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

Question. Which functions can you use in the Consolidate window in SpreadSheet?
a. Count
b. Max
c. Min
d. All of the above
Answer : D

Question. What option should be clicked to stop the macro recorder in Calc?
a. End Recording
b. Close Recording
c. Stop Recording
d. None of the above
Answer : C

Question. _________ allows you to gather data from different worksheets into a master worksheet.
a. Data Consolidation
b. Goal Seek
c. Solver
d. Total data
Answer : A

Question. Scenarios are a tool to test __________ questions.
a. if
b. what else
c. if else
d. what if
Answer : D

Question. Consolidate option is available under _________ menu.
a. View
b. Tool
c. Insert
d. Data
Answer : D

Question. If you select ________ then any values modified in the source range are automatically updated in the target range.
a. Link to source data
b. Link to sheet data
c. Link to original data
d. Link to source range
Answer : A

Question. Each scenario has a name.(T/F)
a. True
b. False
Answer : A

Question. SUBTOTALS _________ data arranged in an array (that is, a group of cells )
a. Add
b. Average
c. Find
d. Clear
Answer : A

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

Question. Which option is used to name a range of cells?
a. Range name
b. Cell Range
c. Define Range
d. Select Range
Answer : C

Question. Is it true or false that you can create only three scenarios for a given range of cells in SpreadSheet?
a. True
b. False
Answer : B

Question. By default ________________ sheets are present in Spreadsheet.
a. 1
b. 2
c. 3
d. 4
Answer : C

Question. Scenario option is available in ___________________ menu.
a. Data
b. Tools
c. Insert
d. Windows
Answer : B

Question. Define range option is available under ________ menu.
a. Insert
b. View
c. Developer
d. Data
Answer : D

Question. Subtotals is available in __________ menu.
a. Tools
b. Format
c. Insert
d. Data
Answer : D

Question. Identify the correct sequence
a. First open subtotals window and then select the data where we need to apply subtotals.
b. First Select data and then open subtotals window.
c. Both of the above are correct
d. None of the above
Answer : 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
Answer : D

Question. Scenarios are tool to test _________ questions.
a. if else
b. what else
c. what if
d. if
Answer : C

Question. Goal Seek Option available in __ menu.
a. Tools
b. Format
c. Data
d. Insert
Answer : A

Question. When we print a spreadsheet, only content of active scenario is printed.(T/F)
a. True
b. False
Answer : A

Question. We can shift from one scenario to another by _____________
a. Navigator
b. Find and Replace
c. Data Source
d. None of the above
Answer : A

Question. ____________ is more elaborate form of Goal Seek.
a. Scenario
b. Subtotal
c. Solver
d. All of the above
Answer : C

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

Question. We can create only 3 scenario for a given range of cells.(T/F)
a. True
b. False
Answer : B

Question. In which menu can you find the Define Range option in SpreadSheet?
a. Developer
b. View
c. Insert
d. Data
Answer : D

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

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

Question. The text in the row label or column label must be identical, otherwise, new row or column will be inserted.(T/F)
a. True
b. False
Answer : A

Question. Hyperlink option is available in ______ menu.
a. File
b. Edit
c. Format
d. Insert
Answer : D

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

Question. We can give different colors to different scenario?(T/F)
a. True
b. False
Answer : A

Question. By default sheets tab are present at the _____________ of the spreadsheet.
a. Top
b. Bottom
c. Both of the above
d. None of the above
Answer : B

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

Question. We can insert the new sheet in Calc by clicking on __ menu.
a. Format
b. Edit
c. Insert
d. Tool
Answer : C

Question. Default name of first scenario created in Sheet1 of Calc is ________
a. Sheet1_Scenario1
b. Sheet1_Scenario_1
c. Sheet_1_Scenario1
d. Sheet_1_Scenario_1
Answer : B

Question. Hyperlink icon is present on _________________
a. Format Toolbar
b. Standard Toolbar
c. Menu Bar
d. None of the Above
Answer : B

Question. We can rename a new sheet in Calc.
a. After inserting a new sheet
b. While inserting a new sheet
c. Both of the above
d. None of the above
Answer : C

Question. Comment in Create Scenario dialog box is Optional(T/F)
a. True
b. False
Answer : A

Question. Data can be consolidated from two sheets only.(T/F)
a. True
b. False
Answer : B

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

Question. Hyperlink in Calc can be either relative or absolute.(T/F)
a. True
b. False
Answer : A

Question. Hyperlink dialog box shows ___________ types of hyperlinks on left hand side.
a. 1
b. 2
c. 3
d. 4
Answer : D

Question. Absolute link will stop working only if the target is moved(T/F)
a. True
b. False
Answer : A

Question. Solver option is available under _________ menu
a. Tools
b. Format
c. Edit
d. Insert
Answer : A

Question. To select random multiple cell hold down ________ key as you click on each cell.
a. Alt
b. Shift
c. Ctrl
d. All of the above
Answer : C

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

Question. We can link one worksheet to another worksheet.(T/F)
a. True
b. False
Answer : A

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. not work
b. work
c. may work
d. None of the above
Answer : B

Question. Can we add/insert more sheets in a spreadsheet?
a. True
b. False
Answer : A

Q30. We can not add/insert more sheets in a spreadsheet.(T/F)
a. True
b. False
Answer : B

Q 42. A relative link will stop working only if the target is moved.(T/F)
a. True
b. False
Answer : B