CBSE CBSE Class 10 IT (402) Class 10 Multiple Choice Questions Facebook Twitter Telegram WhatsApp MCQs of Electronic Spreadsheet (Advanced) Set 1 MCQs of Electronic Spreadsheet (Advanced)MCQs of Electronic Spreadsheet (Advanced) 1 / 35SUBTOTALS ...................... data arranged in a group of cells. Add Average Find Clear 2 / 35Click ....................... to stop the macro recorder. Close Recording End Recording Stop Recording None of these 3 / 35Raman and his friends wants to work together on a spreadsheet. They can do so by Sharing Workbook Linking Workbook Both a and b None of these 4 / 35Scenarios are tools to test ...................................... questions. if else what else what if if 5 / 35Seema is the author of shared worksheet so she has the right to accept or reject changes made by the reviewers. True False 6 / 35Which option is suitable to calculate the effect of different interest rates on an investment? Scenario Subtotal Consolidate None of these 7 / 35A ..................... coloured border, appears around a cell where changes were made in shared worksheet. Blue Yellow Green Red 8 / 35Define range option is available under ...................................... menu. Insert View Developer Data 9 / 35We can shift from one scenario to another by ............................ . Navigator Find and Replace Data Source None of these 10 / 35Macros are especially useful to ........................ a task. do repeat simplify complicate 11 / 35..................... is more elaborate form of Goal Seek. Scenario Subtotal Solver All of these 12 / 35Function names in Calc are not case sensitive. True False 13 / 35We can give different colours to different scenarios? True False 14 / 35We can consolidate data by ...................................... . Row Label Column Label Both a and b None of these 15 / 35In Subtotals we can select up to ...................................... groups of arrays. 2 3 4 Infinite 16 / 35The text in the row label or column label must be identical, otherwise, new row or column will be inserted. True False 17 / 35Which of the following buttons are present on "Resolve Conflict" dialog box which appear during saving shared worksheet. Keep Mine Keep Other Keep All Mine All of these 18 / 35Goal Seek Option available in .......................... menu. Data Format Tools Insert 19 / 35Share document option is available in .......................... menu. Tools View Edit File 20 / 35Formula to refer a cell A3 in sheet named S1 is: =S1A3 =S1.A3 ='S1'.A3 None of these 21 / 35Edited worksheet can be compared with the original worksheet by selecting. File → Compare Document Edit → Compare Document View → Compare Document Tools → Compare Document 22 / 35In which option do we have to specify the target range? Source data range Copy results to Need result at target range 23 / 35After sharing a worksheet, ......................... is seen in the title bar after the worksheet’s title. Sharing Shared Sharing Sheet None of these 24 / 35Scenario option is available in ............................. menu. Data Tools Insert Windows 25 / 35Consolidate option is available under ...................................... menu. View Tool Insert Data 26 / 35Hyperlink icon is present on ...................... . Format Toolbar Standard Toolbar Menu Bar None of these 27 / 35Worksheets can be merged from ........................... menu. Edit File View Tools 28 / 35A deleted column or row in shared worksheet is marked by a .................... coloured bar. Light Line Solid Heavy 29 / 35...................... allows you to gather data from different worksheets into a master worksheet. Data Consolidation Goal Seek Solver Total data 30 / 35Which option is used to name a range of cells? Range name Cell Range Define Range Select Range 31 / 35When you open a new spreadsheet, by default it has sheet named ........................ . Sheet1 Sheet_1 Sheet 1 None of these 32 / 35Use ..................... Macro to start the macro recorder. Tools > Macros > Record Tools > Record > Record Macro Data > Macros > Record None of these 33 / 35A ......................... link will stop working only if the start and target locations change relative to each other. Relative Absolute Both a and b None of these 34 / 35We can create only 3 scenarios for a given range of cells. True False 35 / 35When a document is created and saved, it automatically contains a library named ....................... Module Library Macro Library Standard None of these Your score isThe average score is 0% 0% Restart quiz
NCERT Solutions Chapter 1 Development May 18, 2024May 19, 2024 CBSE CBSE Class 10 Economics CBSE Class 10 Social Science Class 10 Intext Questions NCERT Solution
MCQs for Class 12 Geography Book 1 Chapter 5 Secondary Activities August 12, 2024May 30, 2025 Book I - Fundamentals of Human Geography CBSE CBSE Class 12 Geography Class 12 Multiple Choice Questions
NCERT Solution for Class 11 History Chapter 4 The Three Orders August 5, 2024August 5, 2024 CBSE Class 11 History : Themes in World History NCERT Solution