MCQs For NCERT Class 10 Information Technology Chapter 2 Electronic Spreadsheets Advanced

Please refer to the MCQ Questions for Class 10 Information Technology Chapter 2 Electronic Spreadsheets Advanced with Answers. The following Electronic Spreadsheets Advanced Class 10 Information Technology MCQ Questions have been designed based on the current academic year syllabus and examination guidelines for Class 10. Our faculty has designed MCQ Questions for Class 10 Information Technology with Answers for all chapters as per your NCERT Class 10 Information Technology book.

Electronic Spreadsheets Advanced Class 10 MCQ Questions with Answers

Please see below Electronic Spreadsheets Advanced Class 10 Information Technology MCQ Questions, solve the questions and compare your answers with the solutions provided below.

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

Question. When we print a spreadsheet, only content of active scenario is printe(d)
(a) True
(b) False

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

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

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

Question. Hyperlink icon is present on _________________.
(a) Format Toolbar
(b) Standard Toolbar
(c) Menu Bar
(d) None of these

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

Question. ___________allows you to gather data from different worksheets into a master worksheet. 
(a) Data Consolidation
(b) Goal Seek
(c) Solver
(d) Total data

Question. We can not add/insert more sheets in a spreadsheet.
(a) True
(b) False

Question. We can consolidate data by _________.
(a) Row Label
(b) Column Label
(c) Both a and b
(d) None of these

Question. Subtotals is available in __________ menu.
(a) Tools
(b) Format
(c) Insert
(d) Data

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

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

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

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

Question. Each scenario has a name.
(a) True
(b) False

Question. Scenario option is available in ___________________ menu.
(a) Data
(b) Tools
(c) Insert
(d) Windows

Question. We can create only 3 scenario for a given range of cells.
(a) True
(b) False

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

Question. The text in the row label or column label must be identical, otherwise, new row or column will be inserte(d)
(a) True
(b) False

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

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

Question. Which of the following changes are not recorded in shared worksheet?
(a) Changes any number
(b) Changes any text
(c) Cell Formatting
(d) None of the above

Question. Comment in Create Scenario dialog box is Optional.
(a) True
(b) False

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

Question. The text in the row label or column label must be identical, otherwise, new row or column will be inserte(d)
(a) True
(b) False

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

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

Question. Solver option is available under _________ menu.
(a) Tools
(b) Format
(c) Edit
(d) Insert

Question. To activate the record changes feature in shared worksheet ___________
(a) Select File > Changes > Record from the menu bar.
(b) Select Edit > Changes > Record from the menu bar.
(c) Select View > Changes > Record from the menu bar.
(d) Select Insert > Changes > Record from the menu bar.

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