This quiz works best with JavaScript enabled. Home > Cbse > Class 7 > Computer Science > Ms Excel Spreadsheet > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 2 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 2 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What part of MS Excel Workbook Views will appear on the printed page? A) Normal View. B) Zoom. C) Page-Layout View. D) Page Break View. Show Answer Correct Answer: C) Page-Layout View. 2. In making a computer program, the algorithm was made ..... A) When run. B) When the program was made. C) Before making the program. D) After making the program. Show Answer Correct Answer: C) Before making the program. 3. MS Excel was developed by: A) Microsoft. B) AT & T Lab. C) All the above. D) None of the above. Show Answer Correct Answer: A) Microsoft. 4. Worksheet in the Microsoft Excel program is called ..... A) Jobsheet Sheet. B) Toolshet. C) Booksheet. D) Spreadsheet worksheet. Show Answer Correct Answer: D) Spreadsheet worksheet. 5. Which feature in Excel allows you to view two spreadsheets in one window? A) Freeze panes. B) Split. C) View side by side. D) None of the above. Show Answer Correct Answer: B) Split. 6. What is the file extension for MS Excel worksheet file? A) .doc. B) .exl. C) .html. D) .xlsx. Show Answer Correct Answer: D) .xlsx. 7. The intersection of a colomn and row in a worksheet is called ..... A) Value. B) Column. C) Cell. D) Address. Show Answer Correct Answer: C) Cell. 8. All functions and formulas begin with which symbol? A) =. B) /. C) #. D) :. Show Answer Correct Answer: A) =. 9. Letters of the alphabet going across the top of the spreadsheet. A) Status Bar. B) Row Labels. C) Column Labels. D) Title Bar. Show Answer Correct Answer: C) Column Labels. 10. Which of the following is a FORMULA that will add cells c9 to c15? A) Sum(c9:c10). B) =c9+c15. C) =sum(c9:c15). D) C9+c10. Show Answer Correct Answer: C) =sum(c9:c15). 11. Writing the formula below that is correct is ..... A) =IF(B3=3;B3xC3;0). B) =IF(B3=3;B3=C3;0). C) =IF(B3=3;B3;C3;0). D) =IF(B3=3;B3*C3;0). Show Answer Correct Answer: D) =IF(B3=3;B3*C3;0). 12. The area where the Disbut excel formula is writing A) Menubar. B) Titlebar. C) Toolbar. D) Formulabar. Show Answer Correct Answer: D) Formulabar. 13. What is an EXCEL Spreadsheet used to make? A) Publisher. B) Card. C) Graph. D) Calendar. Show Answer Correct Answer: C) Graph. 14. The application used to create a presentation is A) Microsoft Powerpoint. B) Microsoft Excel. C) Microsoft Visio. D) Microsoft Word. Show Answer Correct Answer: A) Microsoft Powerpoint. 15. The horizontal line on a graph A) X-axis. B) Range. C) Y-axis. D) Chart. Show Answer Correct Answer: A) X-axis. 16. What does a spreadsheet contains? A) Columns. B) Rows. C) Cells. D) All of these. Show Answer Correct Answer: D) All of these. 17. When we Get Backstage View A) By Clicking File Ribbon. B) By Clicking Home Ribbon. C) By Clicking Format Option. D) All of the above. Show Answer Correct Answer: A) By Clicking File Ribbon. 18. The cell reference for cell range of G2 to M12 is ..... A) G2;M12. B) G2-M12. C) G2.M12. D) G2:M12. Show Answer Correct Answer: D) G2:M12. 19. Rows go in what directions? A) Vertical. B) Horizontal. C) All the above. D) None of the above. Show Answer Correct Answer: B) Horizontal. 20. The funds left over after you pay all of your expenses is call ..... A) Savings. B) Debt. C) Loan. D) Income. Show Answer Correct Answer: A) Savings. 21. To lock the column and row is a function of A) Max. B) Average. C) Absolute. D) SUM. Show Answer Correct Answer: C) Absolute. 22. What function will result in the total number of entries in the cell range B5 to B14? A) SUM. B) COUNT. C) MAX. D) MIN. Show Answer Correct Answer: B) COUNT. 23. Which of the following will displays the contents of active cell? A) Status bar. B) Bar menu. C) Formula bar. D) Name box. Show Answer Correct Answer: C) Formula bar. 24. What is the shortcut to enable filtering of selected cells in MS Excel? A) Ctrl + F. B) Shift + F. C) Alt + Click + L. D) Ctrl + Shift + L. Show Answer Correct Answer: D) Ctrl + Shift + L. 25. When the highest value is at the top of the list. Also called Z to A order. A) Descending order. B) Merge. C) Numbers. D) Filtering. Show Answer Correct Answer: A) Descending order. 26. Microsoft Excel is an application ..... A) Spreadsheet. B) Programming. C) Presentation. D) Word Processing. Show Answer Correct Answer: A) Spreadsheet. 27. Through which method we can communicate with another person, both verbally and visually? A) Audio Conferencing. B) Video Conferencing. C) Chatting App. D) None of the above. Show Answer Correct Answer: B) Video Conferencing. 28. The order used to cancel the ordered order is A) Cut. B) Copy. C) Redo. D) Undo. Show Answer Correct Answer: D) Undo. 29. When creating a chart in Excel, what is the first thing you need to do? A) Select the data to be graphed. B) Select the Insert Tab. C) Double click the active cell. D) Choose a chart from the ribbon. Show Answer Correct Answer: A) Select the data to be graphed. 30. One example of an application is A) Unix. B) Windows. C) Power Point. D) Linux. Show Answer Correct Answer: C) Power Point. 31. To insert a new worksheet, press ..... key. A) Shift + F11. B) Shift + F5. C) Ctrl + S. D) ALT + F4. Show Answer Correct Answer: A) Shift + F11. 32. Words in the spreadsheets are called ..... A) Labels. B) Values. C) All the above. D) None of the above. Show Answer Correct Answer: A) Labels. 33. One of the number processing application programs is ..... A) Paint. B) Microsoft Word. C) Microsoft Power Point. D) Microsoft Excel. Show Answer Correct Answer: D) Microsoft Excel. 34. A column is represented by numbers. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 35. Use to create, edit, and manage 2D images. A) Graphic design and editing software. B) File Management Software. C) Desktop Publishing Software. D) None of the above. Show Answer Correct Answer: A) Graphic design and editing software. 36. Consider the following data:1) Type the name range in name box2) Block range that will be named 3) Enter The following are the steps to give the correct range name is ..... A) 2-1-3. B) 1-3-2. C) 1-2-3. D) 3-2-1. Show Answer Correct Answer: A) 2-1-3. 37. The name box contains A) Menu option. B) Numbers. C) Formula. D) Cell address. Show Answer Correct Answer: D) Cell address. 38. What do all calculations start with? A) =. B) . C) (. D) -. Show Answer Correct Answer: A) =. 39. What is the term used for each box in a spreadsheet? A) Field. B) Box. C) Record. D) Cell. Show Answer Correct Answer: D) Cell. 40. ..... is not a competency of EVS. A) Discovery of fact. B) Observation and Reporting. C) Observation and classification. D) Identification and Classification. Show Answer Correct Answer: C) Observation and classification. 41. What do Excel formulas start with? A) . B) F. C) /. D) =. Show Answer Correct Answer: D) =. 42. The function used to calculate the sum of the number data in Excel is ..... A) If. B) Max. C) Sum. D) Average. Show Answer Correct Answer: C) Sum. 43. Function of the Count Formula? A) Calculate the amount of data. B) Add up numbers. C) Count cells. D) Share. Show Answer Correct Answer: A) Calculate the amount of data. 44. What do you call cell A1? A) Opening cell. B) Home row. C) Row one. D) Home cell. Show Answer Correct Answer: D) Home cell. 45. Which of the following is not a term of MS-Excel? A) Document. B) Columns. C) Cells. D) Rows. Show Answer Correct Answer: A) Document. 46. Lotus 123 was replaced by MS Excel as industry standard spreadsheet in ..... A) 2000. B) 1993. C) 1985. D) 1998. Show Answer Correct Answer: B) 1993. 47. Which tab lets you insert clipart? A) View. B) Insert. C) Deginsin. D) Picture. Show Answer Correct Answer: B) Insert. 48. RAM is placed on ..... A) USB. B) Motherboard. C) Hard Disk. D) Extension board. Show Answer Correct Answer: B) Motherboard. 49. ..... is a type of data that contains alphabet and numbers and other symbols. A) Text. B) Number. C) None of the above. D) None of the above. Show Answer Correct Answer: A) Text. 50. The Finish & Merge menu on the mailing is a sub menu? A) Symbol. B) Blank page. C) Chart. D) Print Documents. Show Answer Correct Answer: D) Print Documents. 51. Microsoft Excel is an ..... Software A) System. B) Application. C) General. D) None of the above. Show Answer Correct Answer: B) Application. 52. Matpel Spreadsheet Teacher's Full Name A) Ngurah Mertayasa, S.Kom. B) I Putu Ngurah Mertayasa, S.Pd. C) I Ngurah Mertayasa, S.Kom. D) Ngurah Mertayasa, S.Pd. Show Answer Correct Answer: B) I Putu Ngurah Mertayasa, S.Pd. 53. When referring to the name of the intersection of the active cell in Excel/Sheets, the name includes the ..... titles. Such as B7 A) Formula, Cell. B) Column, Cell. C) Row, Formula. D) Column, Row. Show Answer Correct Answer: D) Column, Row. 54. Microsoft Excel's use is an application for ..... A) Watch YouTube. B) Create applications on computers. C) Make animation. D) Manage numbers and tables. Show Answer Correct Answer: D) Manage numbers and tables. 55. The following is not an example of a spreadsheet is ..... A) Ms. Excel. B) Notepad. C) Dope. D) Scenes. Show Answer Correct Answer: B) Notepad. 56. Which office component is used for taking notes? A) MS Access. B) MS Excel. C) MS Word. D) MS OneNote. Show Answer Correct Answer: D) MS OneNote. 57. The menu used to set the page printing on Microsoft Excell A) Review-Page setup. B) View-Pege Setup. C) Page layout-Page Setup. D) Insert-Page Setup. Show Answer Correct Answer: C) Page layout-Page Setup. 58. To change the unit of size in Excel, the command is used ..... A) Start-Setting-Control Panel-Regional-Currency. B) Office Button-Excel Options-Advanced-Display-Ruler Units. C) Office Button-Open. D) Tools-Options-Print. E) Office Button-Excel Options-Save-Default File Location. Show Answer Correct Answer: B) Office Button-Excel Options-Advanced-Display-Ruler Units. 59. The number of rows in Ms.Excel 2016 A) 16.384. B) 1.048.576. C) 256.000. D) 65.536. Show Answer Correct Answer: B) 1.048.576. 60. Selection of more than one cell. A) Range. B) Worksheet. C) Spreadsheet. D) Cell. Show Answer Correct Answer: A) Range. ← PreviousNext →Related QuizzesComputer Science QuizzesClass 7 QuizzesClass 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 1Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 3Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 4Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 5Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 6Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 7Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 8Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 9 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books