{"id":1409,"date":"2021-07-02T12:53:18","date_gmt":"2021-07-02T07:23:18","guid":{"rendered":"https:\/\/cbsepython.in\/?p=1409"},"modified":"2023-12-28T10:01:18","modified_gmt":"2023-12-28T04:31:18","slug":"electronic-spreadsheet-mcq-class-10","status":"publish","type":"post","link":"https:\/\/cbsepython.in\/electronic-spreadsheet-mcq-class-10\/","title":{"rendered":"Advanced Electronic Spreadsheet MCQ Class 10"},"content":{"rendered":"<h1><span style=\"color: #000000;\">Electronic Spreadsheet MCQ Class 10\u00a0<\/span><\/h1>\n<p><span style=\"color: #000000;\">In this section we will cover unit 2 Electronic Spreadsheet MCQ Class 10 Information Technology (402).\u00a0\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>1. Computer spreadsheet cell that is highlighted with heavy border is :<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Active cell<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Passive cell<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Locked cell<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Formatted cell<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d86874d07ab3062833228' value='69d86874d07ab3062833228'><input type='hidden' id='bg-show-more-text-69d86874d07ab3062833228' value='See Answer'><input type='hidden' id='bg-show-less-text-69d86874d07ab3062833228' value='Hide Answer'><button id='bg-showmore-action-69d86874d07ab3062833228' class='bg-showmore-plg-button bg-orange-button bg-eye '   style=\" color:#4a4949;\">See Answer<\/button><div id='bg-showmore-hidden-69d86874d07ab3062833228' ><\/span><\/p>\n<p><strong><span style=\"color: #000000\">a) Active cell<\/span><\/strong><\/p>\n<p><span style=\"color: #000000\"><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>2. Rohan selected the 4th row and 3rd column in a spreadsheet. Then what is the cell address?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) 3C<\/span><\/p>\n<p><span style=\"color: #000000;\">b) C3<\/span><\/p>\n<p><span style=\"color: #000000;\">c) 4C<\/span><\/p>\n<p><span style=\"color: #000000;\">d) C4\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d86874d092c2015678735' value='69d86874d092c2015678735'><input type='hidden' id='bg-show-more-text-69d86874d092c2015678735' value='See Answer'><input type='hidden' id='bg-show-less-text-69d86874d092c2015678735' value='Hide Answer'><button id='bg-showmore-action-69d86874d092c2015678735' class='bg-showmore-plg-button bg-orange-button bg-eye '   style=\" color:#4a4949;\">See Answer<\/button><div id='bg-showmore-hidden-69d86874d092c2015678735' ><\/span><\/p>\n<p><strong><span style=\"color: #000000\">d) C4\u00a0<\/span><\/strong><\/p>\n<p><span style=\"color: #000000\"><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>3. Data available in other sheets in a workbook , can be consolidate by :<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Row label<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Column Label<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Both a &amp; b\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of the mentioned<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d86874d09d56045311849' value='69d86874d09d56045311849'><input type='hidden' id='bg-show-more-text-69d86874d09d56045311849' value='See Answer'><input type='hidden' id='bg-show-less-text-69d86874d09d56045311849' value='Hide Answer'><button id='bg-showmore-action-69d86874d09d56045311849' class='bg-showmore-plg-button bg-orange-button bg-eye '   style=\" color:#4a4949;\">See Answer<\/button><div id='bg-showmore-hidden-69d86874d09d56045311849' ><\/span><\/p>\n<p><strong><span style=\"color: #000000\">c) Both a &amp; b\u00a0<\/span><\/strong><\/p>\n<p><span style=\"color: #000000\"><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>4. Macros must be saved with extension in MS Excel:<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) .xls<\/span><\/p>\n<p><span style=\"color: #000000;\">b) .xlsm\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) .vba<\/span><\/p>\n<p><span style=\"color: #000000;\">d) .xlsx<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d86874d0a905014327845' value='69d86874d0a905014327845'><input type='hidden' id='bg-show-more-text-69d86874d0a905014327845' value='See Answer'><input type='hidden' id='bg-show-less-text-69d86874d0a905014327845' value='Hide Answer'><button id='bg-showmore-action-69d86874d0a905014327845' class='bg-showmore-plg-button bg-orange-button bg-eye '   style=\" color:#4a4949;\">See Answer<\/button><div id='bg-showmore-hidden-69d86874d0a905014327845' ><\/span><\/p>\n<p><strong><span style=\"color: #000000\">b) .xlsm\u00a0<\/span><\/strong><\/p>\n<p><span style=\"color: #000000\"><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>5. Which programming language does VBA is based on :<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Visual Basic\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Visual studio<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Visual Base<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Visual .Net<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d86874d0b4e9073633229' value='69d86874d0b4e9073633229'><input type='hidden' id='bg-show-more-text-69d86874d0b4e9073633229' value='See Answer'><input type='hidden' id='bg-show-less-text-69d86874d0b4e9073633229' value='Hide Answer'><button id='bg-showmore-action-69d86874d0b4e9073633229' class='bg-showmore-plg-button bg-orange-button bg-eye '   style=\" color:#4a4949;\">See Answer<\/button><div id='bg-showmore-hidden-69d86874d0b4e9073633229' ><\/span><\/p>\n<p><strong><span style=\"color: #000000\">a) Visual Basic\u00a0<\/span><\/strong><\/p>\n<p><span style=\"color: #000000\"><\/div><\/span><\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">Electronic Spreadsheet MCQ Class 10<\/span><\/h3>\n<p><span style=\"color: #000000;\"><strong>6. Which of the following is not a type of referencing in a spreadsheet?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Absolute<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Physical\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Relative<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Mixed<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d86874d0bef5019481216' value='69d86874d0bef5019481216'><input type='hidden' id='bg-show-more-text-69d86874d0bef5019481216' value='&#8221;See'><input type='hidden' id='bg-show-less-text-69d86874d0bef5019481216' value='&#8221;Hide'><div id='bg-showmore-hidden-69d86874d0bef5019481216' ><\/strong><\/span><\/p>\n<p><strong><span style=\"color: #000000\">b) Physical\u00a0<\/span><\/strong><\/p>\n<p><span style=\"color: #000000\"><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>7. Shortcut to open the list of recorded Macros in MS Excel are<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Alt+F8\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Alt+F5<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Alt+F4<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Alt+F7<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d86874d0cbc0026720218' value='69d86874d0cbc0026720218'><input type='hidden' id='bg-show-more-text-69d86874d0cbc0026720218' value='See Answer'><input type='hidden' id='bg-show-less-text-69d86874d0cbc0026720218' value='Hide Answer'><button id='bg-showmore-action-69d86874d0cbc0026720218' class='bg-showmore-plg-button bg-orange-button bg-eye '   style=\" color:#4a4949;\">See Answer<\/button><div id='bg-showmore-hidden-69d86874d0cbc0026720218' ><\/span><\/p>\n<p><strong><span style=\"color: #000000\">a) Alt+F8\u00a0<\/span><\/strong><\/p>\n<p><span style=\"color: #000000\"><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>8. Macros options is available in Openoffice (Oo) Calc in which tab:<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Insert<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Tools\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Data<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Format<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d86874d0d530004954726' value='69d86874d0d530004954726'><input type='hidden' id='bg-show-more-text-69d86874d0d530004954726' value='See Answer'><input type='hidden' id='bg-show-less-text-69d86874d0d530004954726' value='Hide Answer'><button id='bg-showmore-action-69d86874d0d530004954726' class='bg-showmore-plg-button bg-orange-button bg-eye '   style=\" color:#4a4949;\">See Answer<\/button><div id='bg-showmore-hidden-69d86874d0d530004954726' ><\/span><\/p>\n<p><strong><span style=\"color: #000000\">b) Tools<\/span><\/strong><\/p>\n<p><span style=\"color: #000000\"><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>9. In Data consolidate what are the operations we can perform___<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Sum<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Average<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Max<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All of the above\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d86874d0de89025199842' value='69d86874d0de89025199842'><input type='hidden' id='bg-show-more-text-69d86874d0de89025199842' value='See Answer'><input type='hidden' id='bg-show-less-text-69d86874d0de89025199842' value='Hide Answer'><button id='bg-showmore-action-69d86874d0de89025199842' class='bg-showmore-plg-button bg-orange-button bg-eye '   style=\" color:#4a4949;\">See Answer<\/button><div id='bg-showmore-hidden-69d86874d0de89025199842' ><\/span><\/p>\n<p><strong><span style=\"color: #000000\">d) All of the above<\/span><\/strong><\/p>\n<p><span style=\"color: #000000\"><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>10. In a Subtotal function what are the functions can be performed on the group of cells:<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Sum<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Count<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Average<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All of the above\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d86874d0e790081302252' value='69d86874d0e790081302252'><input type='hidden' id='bg-show-more-text-69d86874d0e790081302252' value='See Answer'><input type='hidden' id='bg-show-less-text-69d86874d0e790081302252' value='Hide Answer'><button id='bg-showmore-action-69d86874d0e790081302252' class='bg-showmore-plg-button bg-orange-button bg-eye '   style=\" color:#4a4949;\">See Answer<\/button><div id='bg-showmore-hidden-69d86874d0e790081302252' ><\/span><\/p>\n<p><strong><span style=\"color: #000000\">d) All of the above<\/span><\/strong><\/p>\n<p><span style=\"color: #000000\"><\/div><\/span><\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<p><span style=\"color: #000000;\"><strong>11. To edit a Scenario, right click the name in the Navigator and select________.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Properties<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Scenario\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Window<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Edit<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d86874d0f269003891048' value='69d86874d0f269003891048'><input type='hidden' id='bg-show-more-text-69d86874d0f269003891048' value='See Answer'><input type='hidden' id='bg-show-less-text-69d86874d0f269003891048' value='Hide Answer'><button id='bg-showmore-action-69d86874d0f269003891048' class='bg-showmore-plg-button bg-orange-button bg-eye '   style=\" color:#4a4949;\">See Answer<\/button><div id='bg-showmore-hidden-69d86874d0f269003891048' ><\/span><\/p>\n<p><span style=\"color: #000000\"><strong><em>b) Scenario\u00a0<\/em><\/strong><\/span><\/p>\n<p><span style=\"color: #000000\"><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>12. A_________ is a What if Analysis tool that allows you to substitute set of values automatically in a worksheet.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Navigator<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Scenario\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Subtotal<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Goal Seek<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d86874d0fcf8052319850' value='69d86874d0fcf8052319850'><input type='hidden' id='bg-show-more-text-69d86874d0fcf8052319850' value='See Answer'><input type='hidden' id='bg-show-less-text-69d86874d0fcf8052319850' value='Hide Answer'><button id='bg-showmore-action-69d86874d0fcf8052319850' class='bg-showmore-plg-button bg-orange-button bg-eye '   style=\" color:#4a4949;\">See Answer<\/button><div id='bg-showmore-hidden-69d86874d0fcf8052319850' ><\/span><\/p>\n<p><span style=\"color: #000000\"><strong><em>b) Scenario<\/em><\/strong><\/span><\/p>\n<p><span style=\"color: #000000\"><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>13. Goal Seek command is found in_________<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">\u00a0a) Data<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Tools\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Format<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Edit<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d86874d106c6061396720' value='69d86874d106c6061396720'><input type='hidden' id='bg-show-more-text-69d86874d106c6061396720' value='See Answer'><input type='hidden' id='bg-show-less-text-69d86874d106c6061396720' value='Hide Answer'><button id='bg-showmore-action-69d86874d106c6061396720' class='bg-showmore-plg-button bg-orange-button bg-eye '   style=\" color:#4a4949;\">See Answer<\/button><div id='bg-showmore-hidden-69d86874d106c6061396720' ><\/span><\/p>\n<p><span style=\"color: #000000\"><strong>b) Tools\u00a0<\/strong><\/span><\/p>\n<p><span style=\"color: #000000\"><\/div><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>14. Shortcut to Navigator is ______<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) F10<\/span><\/p>\n<p><span style=\"color: #000000;\">b) F8<\/span><\/p>\n<p><span style=\"color: #000000;\">c) F6<\/span><\/p>\n<p><span style=\"color: #000000;\">d) F5\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\"><input type='hidden' bg_collapse_expand='69d86874d10fd2066028443' value='69d86874d10fd2066028443'><input type='hidden' id='bg-show-more-text-69d86874d10fd2066028443' value='See Answer'><input type='hidden' id='bg-show-less-text-69d86874d10fd2066028443' value='Hide Answer'><button id='bg-showmore-action-69d86874d10fd2066028443' class='bg-showmore-plg-button bg-orange-button bg-eye '   style=\" color:#4a4949;\">See Answer<\/button><div id='bg-showmore-hidden-69d86874d10fd2066028443' ><\/span><\/p>\n<p><span style=\"color: #000000\"><strong>d) F5\u00a0<\/strong><\/span><\/p>\n<p><span style=\"color: #000000\"><\/div><\/span><\/p>\n<h3 style=\"text-align: center;\"><\/h3>\n<p><span style=\"color: #000000;\"><strong>15. Rename option is present under Sheet option of____ menu.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Insert<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Data<\/span><\/p>\n<p><span style=\"color: #000000;\"><strong><em>c) Format \u2713<\/em><\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) Edit<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<p><span style=\"color: #000000;\"><strong>16. To refer a cell from another worksheet, use worksheet number followed by___________ sign and cell address.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\"><strong><em>a) period (.) \u2713<\/em><\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) equal (=)<\/span><\/p>\n<p><span style=\"color: #000000;\">c) colon (:)<\/span><\/p>\n<p><span style=\"color: #000000;\">d) semi colon (;)<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>17. To create a hyperlink to a webpage, FTP server of Telnet connection, click on________icon.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Internet Explorer<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Document<\/span><\/p>\n<p><span style=\"color: #000000;\"><strong><em>c) Internet \u2713<\/em><\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) New Document<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>18. Hyperlink icon is present in ____toolbar.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Formattin<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Hyperlink<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Drawing<\/span><\/p>\n<p><span style=\"color: #000000;\"><strong><em>d) Standard \u2713<\/em><\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>19. To remove a hyperlink, right- click on the hyperlink and select<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Data Formatting<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Absolute formatting<\/span><\/p>\n<p><span style=\"color: #000000;\"><strong><em>c) Default Formatting \u2713<\/em><\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of these<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>20. The Share Document option is present under _____menu.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Data<br \/>\n<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Tools <strong>\u2713<\/strong><br \/>\n<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Format<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Insert<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<table style=\"width: 99.0228%; border-collapse: collapse; border-style: none; height: 79px;\">\n<tbody>\n<tr style=\"height: 28px;\">\n<td style=\"width: 25.1118%; background-color: #000000; border-style: none; height: 28px;\"><strong><span style=\"font-size: 14pt; color: #ffff00;\">#<\/span><span style=\"color: #ffffff; font-size: 12pt;\">TRENDING<\/span><\/strong><\/td>\n<td style=\"width: 74.8882%; border-style: none; height: 28px;\"><\/td>\n<\/tr>\n<tr style=\"height: 51px;\">\n<td style=\"width: 100%; background-color: #00a2f5; border-style: none; height: 51px;\" colspan=\"2\">\n<h3><a href=\"https:\/\/cbsepython.in\/mcq-on-digital-documentation-class-10\/\"><strong><span style=\"color: #ffffff;\">Important MCQ on Digital Documentation Class 10 IT<\/span><\/strong><\/a><\/h3>\n<h3><a href=\"https:\/\/cbsepython.in\/database-management-system-mcq-class-10\/\"><strong><span style=\"color: #ffffff;\">Imp0rtant MCQ on Database Management System Class 10 IT<\/span><\/strong><\/a><\/h3>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>21. To ______ the comment, hover the mouse pointer over the cell that has comment.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) edit<\/span><\/p>\n<p><span style=\"color: #000000;\">b) view <strong>\u2713<\/strong><br \/>\n<\/span><\/p>\n<p><span style=\"color: #000000;\">c) hide<\/span><\/p>\n<p><span style=\"color: #000000;\">d) none of these<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>22. To password protect a worksheet, click on Edit \u2192 Changes \u2192______<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Password<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Protect Records<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Password Protect <strong>\u2713<\/strong><br \/>\n<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Password<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>23. Comment option is present under______ menu.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Edit<\/span><\/p>\n<p><span style=\"color: #000000;\">b) File<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Insert <strong>\u2713<\/strong><br \/>\n<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Tools<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>24. Compare Document option is present under ________menu.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) File <strong>\u2713<\/strong><br \/>\n<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Data<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Insert<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Edit<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>25. The Record Macro option is present under _____menu.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Tools <strong>\u2713<\/strong><br \/>\n<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Data<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Format<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Insert<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<p><span style=\"color: #000000;\"><strong>26. You can save time by_____ a series of action to create macro.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Joining<\/span><\/p>\n<p><span style=\"color: #000000;\">b) grouping<\/span><\/p>\n<p><span style=\"color: #000000;\">c) creating <strong>\u2713<\/strong><br \/>\n<\/span><\/p>\n<p><span style=\"color: #000000;\">d) none of these<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>27. Sort option is present under<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Data menu <strong>\u2713<\/strong><br \/>\n<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Insert menu<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Edit menu<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Format menu<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>28. To delete a Scenario, right click the name in the ________ window and select Delete.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a)Properties<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Scenario<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Navigator <strong>\u2713<\/strong><br \/>\n<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of these<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>29. Name the menu which is used to create scenarios.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) File<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Edit<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Tools<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Data <strong>\u2713<\/strong><br \/>\n<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>30. _________ hyperlink contains a full URL..<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Absolute<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Relative <strong>\u2713<\/strong><br \/>\n<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Both (a) and (b)<\/span><\/p>\n<p><span style=\"color: #000000;\">d) none of these<\/span><\/p>\n<p>&nbsp;<\/p>\n<table style=\"width: 99.0228%; border-collapse: collapse; border-style: none; height: 97px;\">\n<tbody>\n<tr style=\"height: 28px;\">\n<td style=\"width: 25.1118%; background-color: #000000; border-style: none; height: 28px;\"><strong><span style=\"font-size: 14pt; color: #ffff00;\">#<\/span><span style=\"color: #ffffff; font-size: 12pt;\">TRENDING<\/span><\/strong><\/td>\n<td style=\"width: 74.8882%; border-style: none; height: 28px;\"><\/td>\n<\/tr>\n<tr style=\"height: 51px;\">\n<td style=\"width: 100%; background-color: #00a2f5; border-style: none; height: 51px;\" colspan=\"2\">\n<h3><a href=\"https:\/\/cbsepython.in\/it-402-sample-paper-2021-22-class-10-term-1\/\"><strong><span style=\"color: #ffffff;\">Solved Sample Paper Class 10 IT(402) Set-1\u00a0<\/span><\/strong><\/a><\/h3>\n<h3><a href=\"https:\/\/cbsepython.in\/information-technology-402-term-1-sample-paper-for-class-10\/\"><strong><span style=\"color: #ffffff;\">Solved Sample Paper Class 10 IT(402) Set-2<\/span><\/strong><\/a><\/h3>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<p><span style=\"color: #000000;\"><strong>31. __________ tab in the Accept or Reject changes dialog box is used to specify the filter criteria.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a)Tools<\/span><\/p>\n<p><span style=\"color: #000000;\">b)Data<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Filter <strong>\u2713<\/strong><br \/>\n<\/span><\/p>\n<p><span style=\"color: #000000;\">d)Criteria<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>32. Which of the following option tells a summary of a macro in the macro dialog box?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Macro Name<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Description <strong>\u2713<\/strong><br \/>\n<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Buttons<\/span><\/p>\n<p><span style=\"color: #000000;\">d) List of macros<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>33. Spreadsheet software can find the changes by________ sheets.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) adding<\/span><\/p>\n<p><span style=\"color: #000000;\">b)changing<\/span><\/p>\n<p><span style=\"color: #000000;\">c) differentiate<\/span><\/p>\n<p><span style=\"color: #000000;\">d) comparing <strong>\u2713<\/strong><br \/>\n<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>34. Which tool you can use in Calc to make an estimate of output values for different input values?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">i)Multiple Operations<\/span><\/p>\n<p><span style=\"color: #000000;\">ii)Macros<\/span><\/p>\n<p><span style=\"color: #000000;\">iii) Scenarios<\/span><\/p>\n<p><span style=\"color: #000000;\">iv) Goal Seek<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">a) Only (i) and (iii)<\/span><\/p>\n<p><span style=\"color: #000000;\">b) only (ii) and (iv)<\/span><\/p>\n<p><span style=\"color: #000000;\">c) (i), (iii) and (iv)<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All of the above <strong>\u2713<\/strong><br \/>\n<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>35. In spreadsheet, to apply Goal Seek your cell pointer must be in<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) The Changing cell whose value you need to find.<\/span><\/p>\n<p><span style=\"color: #000000;\">b) The Result Cell where formula is entered <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) The cell where your targeted value is entered<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of above<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<p><span style=\"color: #000000;\"><strong>36.Which of the following tools deals with multiple unknown values?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Goal Seek<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Scenario<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Solver <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) Data Table<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>37. In Oo Calc , Which options should be used to accept\/reject the changes in the shared sheet.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Edit-&gt;Accept<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Edit-&gt;Changes-&gt;Record<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Edit-&gt;Changes-&gt;show<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Edit-&gt;Changes-Accept\/Reject <strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>38. What are the operation we can do on the shared documents<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) View the changes<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Accept\/Reject Changes<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Edit the sheet<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All of the above <strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>39.\u00a0 ____is the default extension of Openoffice calc.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) .ode<\/span><\/p>\n<p><span style=\"color: #000000;\">b) .ods <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) .odh<\/span><\/p>\n<p><span style=\"color: #000000;\">d) .odg<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>40. In a spreadsheet,absolute reference will be referred to..<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) $A$4 <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) $A4<\/span><\/p>\n<p><span style=\"color: #000000;\">c) A$4<\/span><\/p>\n<p><span style=\"color: #000000;\">d) A4<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<table style=\"width: 99.0228%; border-collapse: collapse; border-style: none; height: 97px;\">\n<tbody>\n<tr style=\"height: 28px;\">\n<td style=\"width: 25.1118%; background-color: #000000; border-style: none; height: 28px;\"><strong><span style=\"font-size: 14pt; color: #ffff00;\">#<\/span><span style=\"color: #ffffff; font-size: 12pt;\">TRENDING<\/span><\/strong><\/td>\n<td style=\"width: 74.8882%; border-style: none; height: 28px;\"><\/td>\n<\/tr>\n<tr style=\"height: 51px;\">\n<td style=\"width: 100%; background-color: #00a2f5; border-style: none; height: 51px;\" colspan=\"2\">\n<h3><a href=\"https:\/\/cbsepython.in\/it-402-sample-paper-2021-22-class-10-term-1\/\"><strong><span style=\"color: #ffffff;\">Solved Sample Paper Class 10 IT(402) Set-1\u00a0<\/span><\/strong><\/a><\/h3>\n<h3><a href=\"https:\/\/cbsepython.in\/information-technology-402-term-1-sample-paper-for-class-10\/\"><strong><span style=\"color: #ffffff;\">Solved Sample Paper Class 10 IT(402) Set-2<\/span><\/strong><\/a><\/h3>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<h3><span style=\"color: #000000;\">CASE STUDY QUESTIONS<\/span><\/h3>\n<p><span style=\"color: #000000;\"><strong>41. Ramesh wants to solve one variable problem, Suggest him which of the data analysis tools is best suited for him.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Solver<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Goal Seek <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) Scenario<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Data table<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>42. Shovit wants to combine and find the sum\/average of marks obtained by the students in the previous three periodic tests. The data is stored in various sheets of a workbook. Which of the following tools is best suited for him?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Data Range<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Data Consolidation <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) Data Review<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Data Merge.<\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>43. Rakesh wants to apply a formula in the entire column of the spreadsheet,with respect to only one cell. What referencing he will use to get the correct result.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Relative Referencing<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Absolute Referencing <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) Mixed Referencing<\/span><\/p>\n<p><span style=\"color: #000000;\">d) HyperLink<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>44. Sravan wants to do the same set of tasks to be done repeatedly like formatting or applying a similar formula in a similar range of data.Suggest him a suitable tool for that.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Goal Seek<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Solver<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Scenario<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Macros <strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">45. What is the shortcut key for row hide?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Ctrl + 9 <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) Ctrl + F9<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Shift + F9<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Ctrl + shift + 9<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<p><strong><span style=\"color: #000000;\">45. What will do by filter?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Displays the records that meet the criteria <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) Displays only one record to delete<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Modify all the records at once \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All of the above<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">46. How many sheets are there in excel?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) 3<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Many <strong>\u2713<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) 2<\/span><\/p>\n<p><span style=\"color: #000000;\">d) 1<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">47. What happen when selecting record pressing delete key?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Row will be deleted \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Content will be deleted <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) Row moves one step up<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of the above<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">48. What is the name of Excel File?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Workbook <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) Worksheet<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Spread Sheet<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Spread Book<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">49. What is the function of workspace?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Contain multiple workbooks <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) Contain multiple worksheets<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Spread Sheet \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Spread Book<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">50. What is there in Record?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Collection of Fields <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) Collection of Number<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Collection of Rows<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<p><strong><span style=\"color: #000000;\">51. What happen when you cut in excel<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) The content of cell will be removed after paste<strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) The value of cell will be remained after paste<\/span><\/p>\n<p><span style=\"color: #000000;\">c) The content of cell will not be removing<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of the above<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">52. You can create only a horizontal page break by first selecting<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) A row below the row where you want the page break to occur<strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) A cell in Row 1<\/span><\/p>\n<p><span style=\"color: #000000;\">c) A cell in Column A<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Both a. and b.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">53. How many sheets will open when excel is loaded?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) 3 <strong>\u2713<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) 5<\/span><\/p>\n<p><span style=\"color: #000000;\">c) 7<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Unlimited<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">54. While typing, number in cell margin is<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Right align<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Justify<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Left align <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) Center align<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">55. Workspace is a<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) collection of workbook<\/span><\/p>\n<p><span style=\"color: #000000;\">b) collection of sheet<\/span><\/p>\n<p><span style=\"color: #000000;\">c) collection of documents<\/span><\/p>\n<p><span style=\"color: #000000;\">d) all<strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<p><strong><span style=\"color: #000000;\">56. Which character fixes row or column?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) &amp;<\/span><\/p>\n<p><span style=\"color: #000000;\">b) $ <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) = \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">d) @<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">57. What is integer value of 3\/2+5*0.5+A1 where A1=0.75<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) 7.5 <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) 5<\/span><\/p>\n<p><span style=\"color: #000000;\">c) =<\/span><\/p>\n<p><span style=\"color: #000000;\">d) 6<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">58. What would be content of A8 if A4 has count (A1:A7) and if A1=1, A2=2, A3=4, A11=12, A6=Blank, A7=Text<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) 7 <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) 5 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) 17<\/span><\/p>\n<p><span style=\"color: #000000;\">d) 29<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">59. To delete cell contents<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Ctrl + d <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) Alt + d<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Delete<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Esc<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">60. Where is Merge Cell Tab allocated?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Alignment <strong>\u2713<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Font<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Border<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Number<\/span><\/p>\n<p>&nbsp;<\/p>\n<table style=\"width: 99.0228%; border-collapse: collapse; border-style: none; height: 79px;\">\n<tbody>\n<tr style=\"height: 28px;\">\n<td style=\"width: 25.1118%; background-color: #000000; border-style: none; height: 28px;\"><strong><span style=\"font-size: 14pt; color: #ffff00;\">#<\/span><span style=\"color: #ffffff; font-size: 12pt;\">TRENDING<\/span><\/strong><\/td>\n<td style=\"width: 74.8882%; border-style: none; height: 28px;\"><\/td>\n<\/tr>\n<tr style=\"height: 51px;\">\n<td style=\"width: 100%; background-color: #00a2f5; border-style: none; height: 51px;\" colspan=\"2\">\n<h3><a href=\"https:\/\/cbsepython.in\/mcq-on-digital-documentation-class-10\/\"><strong><span style=\"color: #ffffff;\">Important MCQ on Digital Documentation Class 10 IT<\/span><\/strong><\/a><\/h3>\n<h3><a href=\"https:\/\/cbsepython.in\/database-management-system-mcq-class-10\/\"><strong><span style=\"color: #ffffff;\">Imp0rtant MCQ on Database Management System Class 10 IT<\/span><\/strong><\/a><\/h3>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<p><strong><span style=\"color: #000000;\">61. The box which is appear right side of chart is called<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Legend <strong>\u2713<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Label\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Series<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Data marker<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">62. When you insert a column in excel when does the previous column moves?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Left side<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Left most side<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Right side <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) Right most side<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">63. Filter is available on<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Tools menu<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Record menu<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Edit menu <strong>\u2713<\/strong> \u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">d) View menu<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">64. Table is<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Row &amp; Column<strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) Field\/Column<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Row &amp; Chart<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of above<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">65. The information of cell gives on<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Formula bar<strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) Name bar<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Name box<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Formatting bar<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<p><strong><span style=\"color: #000000;\">66. Charts holds all the information except<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Legend<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Data table <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) Axis<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Data label<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">67. Merge is the process of<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Combing <strong>\u2713<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Splitting<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Sending<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Receiving<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">68. Which formula returns multiple calculations to a single formula?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Smart formula<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Standard formula<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Array formula <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) Complex formula<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">69. Types of filter are<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Auto filter<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Advanced filter<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Standard filter<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Both a and b<strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">70. Function of Goal Seek<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Method of finding input value <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) Method of finding input value to meet target<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Method of accumulating data<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All of the above<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<p><strong><span style=\"color: #000000;\">71. To arrange Name list in sequential order is<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Format<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Sorting <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) Order<\/span><\/p>\n<p><span style=\"color: #000000;\">d) List<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">72. The cell level F5 levels to<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Function key F5<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Row F Column 5 <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) Column 5 Rows 5<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Function available in cell<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">73. Which is an example of a formula in Ms-Excel?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) =Sum(A1:A2)<strong> \u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) =A1+A2 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) A1+A2<\/span><\/p>\n<p><span style=\"color: #000000;\">d) =add(A1:A2)<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">74. How do you display current date and time in Ms Excel?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Time ()<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Date ()<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Today ()<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Now ()<strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">75. In Ms-Excel B7:B9 indicates<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Cell B8 only \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Cell B7 and B9 only<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Cell B7 through B9 <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) None<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<p><strong><span style=\"color: #000000;\">76. Which of the following is a popular DOS based spreadsheet package?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Lotus 1-2-3 <strong>\u2713<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Word \u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Smart Cell<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Excel<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">77. The intersection of row and column is called<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) An equation \u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Data<\/span><\/p>\n<p><span style=\"color: #000000;\">c) A field<\/span><\/p>\n<p><span style=\"color: #000000;\">d) A cell<strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">78. In MS Excel, what happens when dollar sign ($) are entered in a cell address? (ex $B$2: $B$10)<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) The status bar does not display the cell address<\/span><\/p>\n<p><span style=\"color: #000000;\">b) An absolute cell address in created <strong>\u2713<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) The Sheet tab is changed<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Cell address will change when it is copied to another cell<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">79. Which operator will combine text from two cells into one cell?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Space<\/span><\/p>\n<p><span style=\"color: #000000;\">b) &amp; (ampersand) <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) = (equal)<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of the above<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">80. An excel workbook is a collection of<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Worksheets and charts <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) Workbook<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Worksheets<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Charts<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<p><strong><span style=\"color: #000000;\">81. The default header for a worksheet is<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) The sheet tab name<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Your name<\/span><\/p>\n<p><span style=\"color: #000000;\">c) The date and time<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of these<strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">82. Which of the following is an absolute cell reference?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) A1<\/span><\/p>\n<p><span style=\"color: #000000;\">b) !A!1<\/span><\/p>\n<p><span style=\"color: #000000;\">c) $A$1 <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) #a#1<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">83. Which symbol must all formula begin with<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) @<\/span><\/p>\n<p><span style=\"color: #000000;\">b) = <strong>\u2713<\/strong>\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) +<\/span><\/p>\n<p><span style=\"color: #000000;\">d) (<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">84. To add two cells (A1 and A2) together you use the following formula<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) A1 plus A2<\/span><\/p>\n<p><span style=\"color: #000000;\">b) =A1+A2 <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) =add (A1+A2)<\/span><\/p>\n<p><span style=\"color: #000000;\">d) =together (A1:A2)<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">85. In an excel sheet the active cell is indicated by<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) A blinking border<\/span><\/p>\n<p><span style=\"color: #000000;\">b) A dark wide border<\/span><\/p>\n<p><span style=\"color: #000000;\">c) A dotted border <strong>\u2713<\/strong> \u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<p><strong><span style=\"color: #000000;\">86. You can create hyperlinks from the Excel workbook to<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) A webpage on company internet<\/span><\/p>\n<p><span style=\"color: #000000;\">b) A webpage on the internet<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Other office 97 application documents<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All of above <strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">87. The advantage of using a spreadsheet is<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Calculations can be done automatically<\/span><\/p>\n<p><span style=\"color: #000000;\">b) More flexibility<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Changing data automatically updates calculations<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All of the above<strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">88. There as three types of data found in a spreadsheet<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Numbers, formulas, labels <strong>\u2713<\/strong>\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Data, words, numbers<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Equations, data, numbers<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Words, numbers, labels<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">89. To merge the cells which tab do you use from the format, cells menu?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Merge tab <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) Number tab \u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Alignment tab<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Font tab<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">90. How do you rearrange the data in ascending or descending order?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Data, subtotals<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Data, sort <strong>\u2713<\/strong>\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Data, form<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Data, table<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<p><strong><span style=\"color: #000000;\">91. The default row height in a MS Excel worksheet is _________ points<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) 75 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) 75 <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) 75 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">d) 75<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">92. Which of following formula is true in MS Excel?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) B6+C6<\/span><\/p>\n<p><span style=\"color: #000000;\">b) =B6+C6 <strong>\u2713<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) A6+B6<\/span><\/p>\n<p><span style=\"color: #000000;\">d) A6+C6=<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">93. Which of the following is not a valid data type in Ms Excel?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Number<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Character<strong>\u2713<\/strong> \u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Label \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Date\/time<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">94. In MS Excel, comments put in cells are called<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Smart tip<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Cell tip<strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) Web tip<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Soft tip<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">95. Shortcut key to bring format cells dialog box is<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Ctrl + F \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Ctrl + E<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Ctrl + 1<strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) Ctrl + D<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<p><strong><span style=\"color: #000000;\">96. The cell reference $A$5 is<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Relative cell reference<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Absolute cell reference<strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) Mixed cell reference<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">97. &#8216;OR&#8217; operator shows &#8216;True&#8217; value when<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) all conditions are false<\/span><\/p>\n<p><span style=\"color: #000000;\">b) any one condition is true<\/span><\/p>\n<p><span style=\"color: #000000;\">c) both conditions are true<\/span><\/p>\n<p><span style=\"color: #000000;\">d) both b &amp; c<strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">98. Which of the following keystrokes lets you recalculate the formula?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) F9 <strong>\u2713<\/strong> \u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) F2<\/span><\/p>\n<p><span style=\"color: #000000;\">c) F7<\/span><\/p>\n<p><span style=\"color: #000000;\">d) F3<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">99. To return the remainder after a number is divided by a divisor in Excel we use the function<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) DIV ( )<\/span><\/p>\n<p><span style=\"color: #000000;\">b) ROUND ( )<\/span><\/p>\n<p><span style=\"color: #000000;\">c) FACT ( )<\/span><\/p>\n<p><span style=\"color: #000000;\">d) MOD ( )<strong> \u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">100. Excel displays the current cell address in the<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Title bar<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Formula bar<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Status bar<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Name box<strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Electronic Spreadsheet MCQ Class 10<\/span><\/span><\/h3>\n<p><strong><span style=\"color: #000000;\">101. Which language is used to crate macros in excel?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Java<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Visual Basic<strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) Access<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Visual C++<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">102. You can delete text by<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Selecting the text and pressing the Ext key<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Selecting the text and pressing the Ctrl key<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Selecting the text and pressing the Delete key<strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) Selecting the text and pressing the Alt + Page up key<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">103. Getting data from a cell located in a different sheet is called<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Functioning<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Accessing<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Referencing <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) Updating<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">104. A numeric value can be treated as a label value if it precedes with<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Ampersand (&amp;)<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Apostrophe (&#8216;) <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) Exclamation (!)<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Hash<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>105. Each excel file is a workbook that contains different sheets. Which of the following cannot be sheet in a workbook?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">a) Work Sheet \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Chart Sheet \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Module Sheet<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Data Sheet<strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">106. You can auto fit the width of column by<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Double clicking on the column name on column header<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Double click on the cell pointer in worksheet<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Double clicking on column right border on column header<strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) Double clicking on the column left border of column header<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">107. What is the shortcut key to replace a data with another in sheet?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Ctrl + R<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Ctrl + Shift + R<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Ctrl + H <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) Ctrl + F<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">108. Formatting a cell in number format you can&#8217;t set<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Decimal places<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Use 1000 separator<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Negative numbers<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Currency symbol<strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">109. Which of the following is invalid regarding the protection in Excel?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Protect Sheet<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Protect Workbook<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Protect Workspace <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) All of above<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">110. Which shortcut key is used to insert chart?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) F10<\/span><\/p>\n<p><span style=\"color: #000000;\">b) F11 <strong>\u2713<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) F2<\/span><\/p>\n<p><span style=\"color: #000000;\">d) F8<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">111. Which is the correct cell address<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) 1A<\/span><\/p>\n<p><span style=\"color: #000000;\">b) $A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) 1#A<\/span><\/p>\n<p><span style=\"color: #000000;\">d) A1<strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">112. Which of the following is\/are available in consolidate dialog box?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Max\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Min<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Count<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All of the above<strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">113. How can you format the cell?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Cell command \u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Font command<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Alignment command <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) Conditional formatting command<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">114. To paste range names into worksheet, choose<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Insert, Name, Paste<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Insert, Name, Define<strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) Edit, Name, Paste<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Edit, Name, Define<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">115. What is the function of [\u2211] tool in Excel Sheet?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) AutoFormat<\/span><\/p>\n<p><span style=\"color: #000000;\">b) AutoText<\/span><\/p>\n<p><span style=\"color: #000000;\">c) AutoSum <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) AutoCorrect<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">116. To round a number down to a nearest integer, choose<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) ABS function<\/span><\/p>\n<p><span style=\"color: #000000;\">b) INT function <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) ABC function<\/span><\/p>\n<p><span style=\"color: #000000;\">d) INTEGER function<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">117. Which of the following is relative cell reference?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) $C7 <strong>\u2713<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) C7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) C$7<\/span><\/p>\n<p><span style=\"color: #000000;\">d) $C$7<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">118. To filter the records, choose<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Data, auto filter, filter<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Tools, auto filter, filter<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Data, filter, auto filter <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) Tools, filter, auto filter<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">119. Which of the following functions is a string function?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) IF function<\/span><\/p>\n<p><span style=\"color: #000000;\">b) MAX function<\/span><\/p>\n<p><span style=\"color: #000000;\">c) DATE function<\/span><\/p>\n<p><span style=\"color: #000000;\">d) MID function<strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">120. What is the short cut key to insert current date in a cell?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Ctrl + *<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Ctrl +:<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Ctrl +; <strong>\u2713<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Ctrl + Shift +;<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">121. Which of the following tabs is not available in Format Cells Dialog box in Excel?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Shading <strong>\u2713<\/strong>\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Border<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Fonts<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Protection<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">122. Function to get sum of the contents of the cells A1, A2, B1, and B2 is<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) =SUM (A1+A2+B1+B2) <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) =SUM (A1:B2)<\/span><\/p>\n<p><span style=\"color: #000000;\">c) =TOTAL (A1..B2)<\/span><\/p>\n<p><span style=\"color: #000000;\">d) =SUM (A1, B2)<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">123. Graphical representation of worksheet data<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Pivot table<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Goal seek\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Graph <strong>\u2713<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Scenario<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">124. What is the shortcut key to select entire row in Excel sheet?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Ctrl + Spacebar<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Alt + Spacebar<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Shift + Spacebar<strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) Ctrl + Shift + Spacebar<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">125. In Excel worksheet the Name box<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Appears to the right of the menu bar<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Appears to the bottom of the menu bar<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Appears to the left of the formula bar <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) Appears with status bar<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">126. You can add a hyperlink to your worksheet by pressing<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Alt + K<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Ctrl + H<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Ctrl + K<strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) Ctrl + Shift + K<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">127. Which command will you choose to convert a column of data into row?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Cut and Paste<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Edit&gt;&gt;Paste Special&gt;&gt;Transpose <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) Both<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">128. Which of the following action removes a sheet from workbook?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Select the sheet, then choose Edit&gt;&gt;Delete Sheet<strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) Select the sheet, then choose Format&gt;&gt;Sheet&gt;&gt;Hide<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Both of the above<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of the above<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">129. Electronic spreadsheet is also known as<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Data processor<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Word processor <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) Presentation package<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">130. Type of data in a cell of a worksheet can be of<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) label<\/span><\/p>\n<p><span style=\"color: #000000;\">b) value<\/span><\/p>\n<p><span style=\"color: #000000;\">c) formula<\/span><\/p>\n<p><span style=\"color: #000000;\">d) all of the above<strong>\u2713<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">131. What do you use to create a chart?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) chart wizard on toolbar<\/span><\/p>\n<p><span style=\"color: #000000;\">b) insert&gt;chart on menu bar <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) insert&gt;diagram on menu bar<\/span><\/p>\n<p><span style=\"color: #000000;\">d) both a and b<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">132. Arrange the information in the row and column is called<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Table <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">b) Field \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Record<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Database<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">133. From which menu, you can hide sheet?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) View<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Insert<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Format <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) Window<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">134. Which of the following is not related to Ms. Excel?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Row<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Column<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Lookup <strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">d) Cell<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">135. What does it mean by Goal seek in spread sheet?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) To draw the curve for given cell value<\/span><\/p>\n<p><span style=\"color: #000000;\">b) To determine the value of cell for given result<strong>\u2713<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">c) To omit the cell data for given graph<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of the above<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<table style=\"width: 99.0228%; border-collapse: collapse; border-style: none; height: 79px;\">\n<tbody>\n<tr style=\"height: 28px;\">\n<td style=\"width: 25.1118%; background-color: #000000; border-style: none; height: 28px;\"><strong><span style=\"font-size: 14pt; color: #ffff00;\">#<\/span><span style=\"color: #ffffff; font-size: 12pt;\">TRENDING<\/span><\/strong><\/td>\n<td style=\"width: 74.8882%; border-style: none; height: 28px;\"><\/td>\n<\/tr>\n<tr style=\"height: 51px;\">\n<td style=\"width: 100%; background-color: #00a2f5; border-style: none; height: 51px;\" colspan=\"2\">\n<h3><a href=\"https:\/\/cbsepython.in\/mcq-on-digital-documentation-class-10\/\"><strong><span style=\"color: #ffffff;\">Important MCQ on Digital Documentation Class 10 IT<\/span><\/strong><\/a><\/h3>\n<h3><a href=\"https:\/\/cbsepython.in\/database-management-system-mcq-class-10\/\"><strong><span style=\"color: #ffffff;\">Imp0rtant MCQ on Database Management System Class 10 IT<\/span><\/strong><\/a><\/h3>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Electronic Spreadsheet MCQ Class 10\u00a0 In this section we will cover unit 2 Electronic Spreadsheet MCQ Class 10 Information Technology (402).\u00a0\u00a0 &nbsp; 1. Computer spreadsheet cell that is highlighted with heavy border is : a) Active cell b) Passive cell c) Locked cell d) Formatted cell &nbsp; 2. Rohan selected the 4th row and 3rd [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[],"class_list":["post-1409","post","type-post","status-publish","format-standard","hentry","category-information-technology-for-cbse-class-10"],"_links":{"self":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/1409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/comments?post=1409"}],"version-history":[{"count":0,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/1409\/revisions"}],"wp:attachment":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/media?parent=1409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/categories?post=1409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/tags?post=1409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}