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 4 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 4 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. When entering numbers in Excel, they are automatically (by default): A) Full Justified. B) Right Justified. C) Center Justified. D) Left Justified. Show Answer Correct Answer: B) Right Justified. 2. The following is the use of Microsoft Word, except ..... A) Editing documents. B) Sorting the documents. C) Processing numbers. D) Processing words. Show Answer Correct Answer: C) Processing numbers. 3. State whether the statements are True or False.Outlook is personal information manager. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 4. Windows is a(n) ..... created by Microsoft. A) Operating System. B) Word Processor. C) Notepad. D) None of them. Show Answer Correct Answer: A) Operating System. 5. What is the term used for cells which appear going up and down the spreadsheet? A) Record. B) Column. C) Field. D) Row. Show Answer Correct Answer: B) Column. 6. Where does the file name of the active workbook will appear once we open it? A) Title bar. B) Quick access toolbar. C) Worksheet tab. D) None of the above. Show Answer Correct Answer: B) Quick access toolbar. 7. Which of the following option is used to graphically summarize data and to explore complicated data? A) Graphs. B) Charts. C) Pivot Table. D) Maps. E) Pivot Chart. Show Answer Correct Answer: E) Pivot Chart. 8. Buttons containing new, open, save, save as, print called ..... A) Tittle Bar. B) Group. C) Office Button. D) Formula Bar. Show Answer Correct Answer: C) Office Button. 9. The technique of inserting an object of an application that if changed will change the data from the source is ..... A) Embedding. B) Office integration. C) Mail Merge. D) Object Linking. Show Answer Correct Answer: D) Object Linking. 10. The correct naming of the cell is A) Chap. B) Ash. C) A-6. D) 6-A. Show Answer Correct Answer: B) Ash. 11. What is the default extension of Microsoft Excel 2016 saved file? A) .xls. B) .csv. C) .xlsm. D) .xlsx. Show Answer Correct Answer: D) .xlsx. 12. You can find frequently used commands in A) Scroll bar. B) Formula bar. C) Quick access toll bar. D) Status bar. Show Answer Correct Answer: C) Quick access toll bar. 13. Grid of vertical and horizontal lines where work is done in a spreadsheet. A) Worksheet. B) Column. C) Spreadsheet. D) Workbook. Show Answer Correct Answer: A) Worksheet. 14. A file which contains one or more spreadsheets. A) Spreadsheet. B) Workbook. C) Entry. D) Cells. Show Answer Correct Answer: B) Workbook. 15. The following is a package of the number/spreadsheet processing program is Microsoft ..... A) Exel. B) Visual basic. C) Word. D) Power Point. E) Acces. Show Answer Correct Answer: A) Exel. 16. When using a credit card, the smartest financial decision would be A) Make sure that your parents will have extra money for the bil. B) Make sure that the interest rate is very high. C) Ensure that the item is something you want. D) Make sure that you can pay it off when the bill comes so you don't owe interest on the amount. Show Answer Correct Answer: D) Make sure that you can pay it off when the bill comes so you don't owe interest on the amount. 17. Which of the following is a tool of spreadsheet? A) MS Excel. B) Google Sheets. C) MS Word. D) Google Docs. Show Answer Correct Answer: A) MS Excel. 18. 20-An easy way to change a column's width is to drag the right border of the column heading. A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: A) TRUE. 19. The alphabet the logo of the MS Excel has A) C. B) E. C) X. D) None of the above. Show Answer Correct Answer: C) X. 20. A series of processes to connect several computerized systems and application software both physically and functionally is the understanding of A) Integration. B) Integration system. C) Linking. D) Object Linking and Embedding. Show Answer Correct Answer: B) Integration system. 21. Which area in an Excel window allows entering values and formulas? A) Title Bar. B) Menu bar. C) Formula Bar. D) Standard Tool Bar. Show Answer Correct Answer: C) Formula Bar. 22. Home, Insert, Page Layout, and Review commands can be found on ..... A) Group. B) Office Button. C) Tab Ribbon. D) Formula Bar. E) Title Bar. Show Answer Correct Answer: C) Tab Ribbon. 23. State whether the statements are True or False.Microsoft Office was launched in 2010. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 24. It shows the reference of the active cell. A) Name box. B) Formula bar. C) Cell. D) Rows. Show Answer Correct Answer: A) Name box. 25. A selected cell is highlighted in the sheet and it is called ..... A) Formula bar. B) Name box. C) Active cell. D) Sheet tab. Show Answer Correct Answer: C) Active cell. 26. Two or more cells cannot be merged into one cell. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 27. State whether the statements are True or False.Outlook and OneNote are not web applications. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 28. Can be used travel from cell to cell in a spreadsheet: A) Tab. B) Enter. C) Arrow keys. D) All of the above. Show Answer Correct Answer: D) All of the above. 29. To name a cell or range, you use the A) Name Box. B) Define Name. C) Paste Name. D) Format Cells. Show Answer Correct Answer: A) Name Box. 30. Which is an example of a cell address? A) Lord. B) =SUM. C) 75/65. D) 126. Show Answer Correct Answer: A) Lord. 31. Signs (+) on MS.Excel is useful for ..... A) Kali. B) Added. C) For. D) Not enough. Show Answer Correct Answer: B) Added. 32. The rows in the spreadsheet represents the ..... A) Vowels. B) Numbers. C) Consonants. D) Letters. Show Answer Correct Answer: B) Numbers. 33. The first electronic spread sheet was ..... A) Cobol. B) FOTRON. C) Pascal. D) VISICALC. Show Answer Correct Answer: D) VISICALC. 34. Cells (Cell) in Microsoft Excel are ..... A) Group from worksheets. B) A group of several pictures. C) Group from writing. D) Combined or meetings from rows and columns. Show Answer Correct Answer: D) Combined or meetings from rows and columns. 35. The right step to create a new file in Microsoft Excel is ..... A) File-New-Blank Workbook-Create. B) File-New-Ok. C) Office Button-Blank Workbook-Ok. D) Office Button-New-Create. E) Office Button-New-Blank Workbook-Create. Show Answer Correct Answer: A) File-New-Blank Workbook-Create. 36. The address of last cell in MS-Excel is? A) IV 16384. B) ZZ 16384. C) ZZ 8192. D) ZX 8192. Show Answer Correct Answer: A) IV 16384. 37. What is spreadsheet? A) The cell address. B) The mouse pointer. C) The grid you see on the screen. D) None of the above. Show Answer Correct Answer: C) The grid you see on the screen. 38. Is Shortcut for Cut-Paste? A) Ctrl + C-Ctrl + V. B) Ctrl + C-Ctrl + X. C) Ctrl X +-Ctrl + P. D) Ctrl + X-Ctrl + V. Show Answer Correct Answer: D) Ctrl + X-Ctrl + V. 39. You can add, subtract, multiply and divide in excel. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 40. Every cell has a unique Cell address. A) What. B) What analysis. C) Cell Address. D) How analysis. Show Answer Correct Answer: C) Cell Address. 41. A GROUP OF CELLS IN A WORKSHEET IS CALLED A ..... A) ROW. B) FORMULA. C) COLUMN. D) RANGE. Show Answer Correct Answer: D) RANGE. 42. Vertical arrangement of cells is known as A) Range. B) Cell. C) Row. D) Column. Show Answer Correct Answer: D) Column. 43. Number parts of a whole. A) Percentage. B) Cell. C) Fraction. D) Range. Show Answer Correct Answer: C) Fraction. 44. Wauto can only be utilized with a Gmail account? A) Correct. B) Salah. C) All the above. D) None of the above. Show Answer Correct Answer: A) Correct. 45. The intersection of a row and a column A) Active cell. B) Cell reference. C) Cell. D) Cell range. Show Answer Correct Answer: C) Cell. 46. In MS Excel, to add numeric values in column D, from rows D10 to D15, the formula that should be used is: A) =COUNT (D10:D15). B) =COUNT (D10, D15). C) =SUM (D10:D15). D) =SUM (D10, D15). Show Answer Correct Answer: C) =SUM (D10:D15). 47. The extension used on Microsoft Office Excel is ..... A) *pdf. B) *xls. C) *xlsx. D) *Exl. Show Answer Correct Answer: B) *xls. 48. Google Sheets is sometimes mistakenly called "Google Spreadsheets." A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 49. An Excel file is generally called a / an: A) E-Spreadsheet. B) NoteBook. C) Workbook. D) Worksheet. Show Answer Correct Answer: C) Workbook. 50. What are the uses of the country formula A) The county formula is used to calculate the amount of data in a particular range with a lot of criteria. B) The county formula is used to calculate the amount of data in a particular range with one criterion. C) The county formula is used for the average data in certain ranges with many criteria. D) The county formula is used to add up data in a particular range with one criterion. Show Answer Correct Answer: B) The county formula is used to calculate the amount of data in a particular range with one criterion. 51. Another name for a pre-programmed formula in Excel is A) Range. B) Cell. C) Graph. D) Function. Show Answer Correct Answer: D) Function. 52. In Excel you create: A) Spreadsheets. B) Documents. C) Slide shows. D) None of the above. Show Answer Correct Answer: A) Spreadsheets. 53. Spreadsheet columns are easily identified by: A) Numbers. B) Letters. C) Colors. D) Roman numerals. Show Answer Correct Answer: B) Letters. 54. Which part of Excel displays the cell reference or the name of the cell that is currently selected? A) Title Bar. B) Bar menu. C) Name Box. D) Formula Bar. Show Answer Correct Answer: C) Name Box. 55. Which direction do columns run in a spreadsheet? A) Diagonal. B) Horizontal. C) Vertical. D) Counter Clockwise. Show Answer Correct Answer: C) Vertical. 56. 1 ..... is the electronic spreadsheet program. A) MS PowerPoint. B) MS Word. C) MS Teams. D) MS Excel. Show Answer Correct Answer: D) MS Excel. 57. If you see the following, what does it mean? ###### A) The formula has an error. B) The contents are too large to display. C) Text was entered where numbers should be. D) None of the above. Show Answer Correct Answer: B) The contents are too large to display. 58. MS Excel is the spreadsheet application and is the product of ..... A) Modesoft. B) Monosoft. C) Macrosoft. D) Microsoft. Show Answer Correct Answer: D) Microsoft. 59. The right step is to keep a new file on Ms.Excel is ..... A) Office Button-Save As-Determine the File-Save Storage Location. B) Office Button-Save-Geri File-Ok-Determine Storage Loksi. C) Office button-Save-beri nama file-save. D) Office Button-Save-Determine the File-Save Name-Geri Storage Location. Show Answer Correct Answer: A) Office Button-Save As-Determine the File-Save Storage Location. 60. The address of the currently active cell is displayed in the ..... A) Formula Bar. B) Name Box. C) All the above. D) None of the above. Show Answer Correct Answer: B) Name Box. ← 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 2Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 3Class 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