Page 1 :
Class 10 IT – 402, Unit 2: Electronic Spreadsheet (Advanced), , Top 50 MCQ Question Answer, 1. A numeric data analysis tool that allows us to create a, computerized ledger., A. Mathematical package, B. Graphics package, C. Spreadsheet package, D. Word processing package, 2. In a computer spreadsheet, tool used to construct formulas is, called, A. Formula bar, B. Filter, C. Auditing toolbar, D. Format printer, 3. When you open a new spreadsheet, by default it has sheet, named _________., A. Sheet1, B. Sheet_1, C. Sheet 1, D. Worksheet

Page 2 :
4. By default sheets tab are present at the _______ of the, spreadsheet., A. Top, B. Bottom, C. Left side, D. Right side, 5. By default _________ sheets are present in Spreadsheet., A. 1, B. 2, C. 3, D. 4, 6. Which of the following elements are present in ‘Insert Sheet’, dialogue box?, A. Before Current Sheet, B. After Current sheet, C. No. of Sheets, D. All of the above, 7. Computer spreadsheet cell that is highlighted with a heavy, border is a, A. Active cell, B. Cell containing a formula, C. Locked cell, D. Normal cell

Page 3 :
8. Formula to refer a cell A3 in sheet named S1 is, A. =S1A3, B. =S1.A3, C. =‘S1’.A3, D. Any of the above, 9. It refers to a cell or a range of cells on a worksheet and can, be used to find the values that you want formula to calculate., A. Row, B. Column, C. Autosum, D. Cell Reference, 10. In a spreadsheet, letters are used to represent ______, A. Columns, B. Blocks, C. Rows, D. Cells, 11. In a spreadsheet Numerical Value of cell denotes, A. Column, B. Block, C. Rows, D. Cell

Page 4 :
12. Hyperlink option is available in ________ menu., A. File, B. Edit, C. Format, D. Insert, 13. Hyperlink icon is present on __________, A. Format Toolbar, B. Standard Toolbar, C. Menu bar, D. None of the above, 14. Hyperlink dialogue box shows ________ types of, hyperlinks on left hand side., A. 1, B. 2, C. 3, D. 4, 15. Which link contains a full address including the protocol, and domain name for URLs for documents?, A. Absolute Hyperlink, B. Relative Hyperlink, C. Text Hyperlink, D. Bookmark Hyperlink

Page 5 :
16. Which hyperlink contains a partial address?, A. Local Hyperlink, B. Absolute Hyperlink, C. Relative Hyperlink, D. Internal Hyperlink, 17. __________ allows you to gather data from different, worksheets into a master worksheet., A. Data Consolidation, B. Goal Seek, C. Solver, D. Total data, 18. Consolidate option is available under _________ menu, A. View, B. Tool, C. Insert, D. Data, 19. We can consolidate data by _______, A. Column label, B. Row label, C. Both (A) and (B), D. None of these

Page 6 :
20. Which of the following functions are available in, consolidate window?, A. Max, B. Min, C. Count, D. All of the above, 21. Which option is used to name a range of cells?, A. Range name, B. Cell Range, C. Define Range, D. Select Range, 22. Define range option is available under ______ menu., A. Insert, B. View, C. Developer, D. Data, 23. Scenarios are tool to test _________ questions., A. If else, B. What else, C. What if, D. If

Page 7 :
24. Scenario option is available in _______ menu., A. Data, B. Tools, C. Insert, D. Windows, 25. We can shift from one scenario to another by, A. Navigator, B. Find and Replace, C. Data Source, D. None of the above, 26. Which option is suitable to calculate the effect of different, interest rates on an investment, A. Subtotal, B. Consolidate, C. Scenario, D. None of the above, 27. To select random multiple cells hold down ________ key, as you click on each cell., A. Alt, B. Shift, C. Ctrl, D. All of the above

Page 8 :
28. Goal Seek Option available in _______ menu., A. Tools, B. Format, C. Data, D. Insert, 29. _________ is more elaborate form of Goal Seek., A. Scenario, B. Subtotal, C. Solver, D. All of the above, 30. Solver option is available under _______ menu, A. Tools, B. Format, C. Edit, D. Insert, 31. Suman and her friends want to work together in a, spreadsheet. They can do so by, A. Sharing Workbook, B. Linking Workbook, C. Both of the above, D. None of the above

Page 9 :
32. Share document option available in _______ menu, A. View, B. Edit, C. Tools, D. File, 33. 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 above, 34. 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, 35. A _______ colored border appears around a cell where, changes were made in shared worksheet., A. Blue, B. Yellow, C. Red, D. Green

Page 10 :
36. A deleted column or row in shared worksheet is marked by, a _______ colored bar, A. Light, B. Line, C. Solid, D. Heavy, 37. Which of the following changes are not recorded in shared, worksheet?, A. Changes any number, B. Changes any text, C. Cell formatting, D. All of the above, 38. Worksheets can be merged from _______ menu., A. File, B. Edit, C. View, D. Tools, 39. A ________ is a saved sequence of commands or, keystrokes that are stored for later use, A. Solver, B. Autosum, C. Macro, D. Consolidate

Page 11 :
40. Use _________ Macro to start the macro recorder., A. Tools > Macros > Record, B. Tools > Record > Record Macro, C. Data > Macros > Record, D. None of the above, 41. Click __________ to stop the macro recorder, A. Close Recording, B. End Recording, C. Stop Recording, D. All of the above, 42. Which of the following options are not visible in tools menu, options, A. Goal Seek, B. Solver, C. Consolidate, D. Scenarios, 43. SUBTOTAL is a function listed under the _______, category when you use the Function Wizard, A. Accounting, B. Mathematical, C. Statistical, D. Numerical

Page 12 :
44. Subtotals is available in _________ menu., A. Tools, B. Format, C. Insert, D. Data, 45. In Subtotals, we can select upto _______ group of arrays., A. 3, B. 2, C. 4, D. Infinite, 46. Which function cannot be performed through Subtotal in a, spreadsheet?, A. Sum, B. Product, C. Average, D. Percentage, 47. The function that you want to use to calculate the subtotals,, can be selected under the ________ box., A. Group By, B. Calculate Subtotals, C. Use Function, D. None of these

Page 13 :
48. In computer spreadsheet, a workbook is a group of, A. Many rows, B. Many columns, C. Worksheet, D. All of the above, 49. Title bar in MS-Excel displays name of the, A. Worksheet, B. Workbook, C. Formula, D. Location, 50. In a computer spreadsheet, SUM, AVERAGE, MIN and, MAX are examples of, A. Functions, B. Calculations, C. Formulas, D. Relative addressing