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 13 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 13 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Below is a social benefit of Facebook, except ..... A) Looking for old friends. B) Add new friends. C) Help others. D) Help the account piracy process. Show Answer Correct Answer: D) Help the account piracy process. 2. In the menu bar there are buttons called A) Title Bar. B) Formula Bar. C) Tool Bar. D) All wrong. Show Answer Correct Answer: C) Tool Bar. 3. The function of the Sum formula is to search A) Group. B) Max value. C) Mean value of mean. D) Average value. E) Amount. Show Answer Correct Answer: E) Amount. 4. To adjust the height of the table using the command A) Format, row, autoselection. B) Format, coloum, autoselection. C) Format, wide, height. D) Format, row, height. Show Answer Correct Answer: D) Format, row, height. 5. That used to save documents is A) Export. B) New. C) Close. D) Save. E) Open. Show Answer Correct Answer: D) Save. 6. The following are not included in the Microsoft Office program group is A) Microsoft word. B) Microsoft excel. C) Microsoft power point. D) Microsoft windows. Show Answer Correct Answer: D) Microsoft windows. 7. Which place shows the cell address? A) Title Bar. B) Name Box. C) Formula Bar. D) Active Cell. Show Answer Correct Answer: B) Name Box. 8. The section of excel that has vertical columns are identified by A) Numbers. B) Letters. C) None. D) None of the above. Show Answer Correct Answer: B) Letters. 9. Any type of motion or movement that occurs in your presentation is called? A) Place holder. B) Slide. C) Animation. D) Movement. Show Answer Correct Answer: C) Animation. 10. The function used to determine the biggest value is ..... A) Sum. B) Max. C) Min. D) Count. Show Answer Correct Answer: B) Max. 11. Tabs on the Ribbon are divided into ..... A) Clusters. B) Collections. C) Groups. D) Units. Show Answer Correct Answer: C) Groups. 12. What is the name of each "box" on a spreadsheet? A) Cell. B) Box. C) Rectangle. D) None of the above. Show Answer Correct Answer: A) Cell. 13. What will be the cell address of the cell formed by the intersection of the 5th Column and 8th Row A) F8. B) E8. C) A8. D) D8. Show Answer Correct Answer: B) E8. 14. The following is a function of Microsoft Excel, except ..... A) Make a financial statement. B) Perform mathematical operations. C) Make an attendance report. D) Creating a graph and table of a calculation. E) Make a financial bill. Show Answer Correct Answer: E) Make a financial bill. 15. What type of chart is useful for comparing values over categories? A) Pie Chart. B) Line Chart. C) Dot Graph. D) Column Chart. Show Answer Correct Answer: D) Column Chart. 16. TEXT ENTRY are used for titles, headings, and other notes A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 17. Command Save, Save As, New, Open, and Print are in the Ms. section.Excel section ..... A) Formula Bar. B) Office Button. C) Tittle Bar. D) Shoutcurt. Show Answer Correct Answer: B) Office Button. 18. The combination of columns and rows is called ..... A) Menu. B) Margin. C) Cell. D) Insert. Show Answer Correct Answer: C) Cell. 19. Allows some data to be hidden from view. A) Filtering. B) Active cell. C) Row. D) Range. Show Answer Correct Answer: A) Filtering. 20. A formula is used to calculate the value of the cell from the contents of the other cells. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 21. Save icons are used for ..... A) Open documents. B) Save documents. C) Save documents with new names. D) See documents. Show Answer Correct Answer: B) Save documents. 22. Shows values by means of Percentages Such as 20 %, 60% A) Currency Format. B) Percentage format. C) All the above. D) None of the above. Show Answer Correct Answer: B) Percentage format. 23. To find total using certain conditions is ..... A) Countif. B) IF. C) SUMIF. D) SUM. E) MAX. Show Answer Correct Answer: C) SUMIF. 24. To create an email, which option we should select first? A) New. B) Edit. C) Open. D) Compose/Write. Show Answer Correct Answer: D) Compose/Write. 25. What is Mail Merge? A) Data preparation from MS Word to be displayed at Ms.Word. B) Data preparation from MS Excel to be displayed at Ms.Word. C) Data preparation from MS Word to be displayed at Ms.Excel. D) Data preparation from MS Excel to be displayed at Ms.Excel. Show Answer Correct Answer: B) Data preparation from MS Excel to be displayed at Ms.Word. 26. Which is not included in the number processing software A) MS Exel. B) Open Office Calculator. C) WPS Spreadsheet. D) Photoshop. Show Answer Correct Answer: D) Photoshop. 27. It is a spreadsheet program file that you create in Excel that contains one or more worksheets. A) Book. B) Worksheet. C) Active Cell. D) Workbook. Show Answer Correct Answer: D) Workbook. 28. The process of connecting wauto with spreadsheet? A) Attach. B) Adjust. C) Conflict. D) Synchronize. Show Answer Correct Answer: D) Synchronize. 29. The value in a function on which calculation are performed A) Argument. B) Numbers. C) Believer. D) Cell values. Show Answer Correct Answer: D) Cell values. 30. To improve the quality of human resources in an agency or institution, each agency holds training.As an appreciation of the organizer, the organizer will give appreciation in what form?So that the activity can benefit the participants and the organizers. A) Order. B) Land certificate. C) Certificate. D) Invitation. E) Participant card. Show Answer Correct Answer: C) Certificate. 31. In accordance with the development of the technology era that is so fast.We as technology users should use it with ..... A) Chat. B) Good and wise. C) Act negatively as a user. D) Don't want to use technology. Show Answer Correct Answer: B) Good and wise. 32. Excel is a ..... program developed by Microsoft. A) Spreadsheet. B) Document. C) Data management. D) All the mentioned. Show Answer Correct Answer: A) Spreadsheet. 33. A spreadsheet program is used to store data in: A) A database. B) A text document. C) Rows and columns. D) Letters and numbers. Show Answer Correct Answer: C) Rows and columns. 34. How many sheets are there, by default, when we create a new Excel file? A) 5. B) 3. C) 10. D) 1. Show Answer Correct Answer: B) 3. 35. What do you call a portable computer A) Bookshop. B) Computer. C) Laptop. D) RAM. Show Answer Correct Answer: B) Computer. 36. It is a program that is used to create electronic presentations to display information to an audience. A) MS Word. B) MS PowerPoint. C) All the above. D) None of the above. Show Answer Correct Answer: B) MS PowerPoint. 37. A presentation software developed by Microsoft. A) MS Excel. B) MS Word. C) MS PowerPoint. D) None of the above. Show Answer Correct Answer: C) MS PowerPoint. 38. The short cut key used to move to next cell A) Next. B) Tab. C) Say Friday ( AI) to move to the next cell. D) Enter. Show Answer Correct Answer: B) Tab. 39. Number formats make your spreadsheet difficult to read and use A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 40. What are the examples of presentation material makers? A) Google Docs. B) OpenOffice Writer. C) Microsoft Word. D) Microsoft PowerPoint. Show Answer Correct Answer: D) Microsoft PowerPoint. 41. The function of Microsoft PowerPoint is ..... A) Database processing application. B) Presentation processing application. C) Image processing application. D) Word processing application. E) Number processing application. Show Answer Correct Answer: B) Presentation processing application. 42. The advantage of this program is that it is able to clarify data on the work sheet and help users to create graphics and convert data.The program in question is ..... A) Screams. B) Star Office Calc. C) Open Office Calc. D) Abacus. Show Answer Correct Answer: B) Star Office Calc. 43. The pages of a spreadsheet application is called ..... A) Slides. B) Pages. C) Sheets. D) Document. Show Answer Correct Answer: C) Sheets. 44. What are the two additional tabs that appears after inserting a chart A) LAYOUT, DESIGN. B) INSERT, FORMAT. C) FORMAT, LAYOUT. D) DESIGN, FORMAT. Show Answer Correct Answer: D) DESIGN, FORMAT. 45. Below, what is not a number processing application is ..... A) Google Sheets. B) Apple's Numbers. C) Microsoft Excel. D) Google Slides. Show Answer Correct Answer: D) Google Slides. 46. The name of the file that we are actively aimed at or we do it will be in the section ..... A) Tab Ribbon. B) Office Button. C) Tittle bar. D) Insert Function. Show Answer Correct Answer: C) Tittle bar. 47. Function in Ms.Excel used to read the table horizontally is A) VLOOK. B) HLOOK. C) VLOOKUP. D) Hlookup. Show Answer Correct Answer: D) Hlookup. 48. MS Excel is an example of Spreadsheet A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 49. ..... is made of rows and columns. A) MS Word. B) MS Power point. C) MS Excel. D) None of the above. Show Answer Correct Answer: C) MS Excel. 50. How many tabs having in ribbon of ms excel A) 3. B) 7. C) 4. D) 6. Show Answer Correct Answer: B) 7. 51. The following used to sort data from A-Z is ..... A) Paste. B) Copy. C) Sort ascending. D) Sort desending. Show Answer Correct Answer: C) Sort ascending. 52. The intersection of row and column makes: A) Table. B) Form. C) Formula Bar. D) Cell. Show Answer Correct Answer: D) Cell. 53. The ..... function can be used to find the total of numbers entered in a range of cells. A) Max. B) Sum. C) Min. D) None of the above. Show Answer Correct Answer: B) Sum. 54. Another name for the flowchart is ..... A) Channel. B) Algorithm. C) Flow. D) Tree. Show Answer Correct Answer: C) Flow. 55. What type of chart is good for single series of data? A) Column Chart. B) Pie Chart. C) Cone Chart. D) Line Chart. Show Answer Correct Answer: B) Pie Chart. 56. ..... is a way of telling the computer what you want it to do using codes A) Presentation. B) Coder. C) Coding. D) Typing. Show Answer Correct Answer: C) Coding. 57. A4 is an example of ..... A) Cell Address. B) Formula. C) Function. D) Cell Range. Show Answer Correct Answer: A) Cell Address. 58. A four-sided arrow does what in Excel? A) Copies the contents of one cell to others around it. B) Moves the contents of one cell to another location. C) Selects the cell. D) None of the above. Show Answer Correct Answer: B) Moves the contents of one cell to another location. 59. It contain one or more worksheet which are automatically named in the sheet tabs as sheet 1, sheet 2, and so on. A) Excel. B) Worksheet. C) Cell. D) Workbook. Show Answer Correct Answer: D) Workbook. 60. A collection or group of several cells in the spreadsheet is called ..... A) Sel. B) Range. C) Column. D) Line. Show Answer Correct Answer: B) 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 2Class 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 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books