This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 31 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 31 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. That used to save documents is A) Save. B) New. C) Open. D) Export. E) Close. Show Answer Correct Answer: A) Save. 2. The following are not included in the Microsoft Office program group is A) Microsoft excel. B) Microsoft word. C) Microsoft power point. D) Microsoft windows. Show Answer Correct Answer: D) Microsoft windows. 3. Which place shows the cell address? A) Formula Bar. B) Title Bar. C) Name Box. D) Active Cell. Show Answer Correct Answer: C) Name Box. 4. 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. 5. A formula starts with: A) >. B) <>. C) =. D) (). Show Answer Correct Answer: C) =. 6. Any type of motion or movement that occurs in your presentation is called? A) Slide. B) Place holder. C) Animation. D) Movement. Show Answer Correct Answer: C) Animation. 7. The function used to determine the biggest value is ..... A) Max. B) Min. C) Count. D) Sum. Show Answer Correct Answer: A) Max. 8. Tabs on the Ribbon are divided into ..... A) Groups. B) Clusters. C) Units. D) Collections. Show Answer Correct Answer: A) Groups. 9. 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. 10. 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) D8. D) A8. Show Answer Correct Answer: B) E8. 11. 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. 12. What type of chart is useful for comparing values over categories? A) Pie Chart. B) Column Chart. C) Line Chart. D) Dot Graph. Show Answer Correct Answer: B) Column Chart. 13. 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. 14. Command Save, Save As, New, Open, and Print are in the Ms. section.Excel section ..... A) Formula Bar. B) Shoutcurt. C) Tittle Bar. D) Office Button. Show Answer Correct Answer: D) Office Button. 15. The combination of columns and rows is called ..... A) Cell. B) Margin. C) Menu. D) Insert. Show Answer Correct Answer: A) Cell. 16. Allows some data to be hidden from view. A) Active cell. B) Row. C) Range. D) Filtering. Show Answer Correct Answer: D) Filtering. 17. 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. 18. Save icons are used for ..... A) Open documents. B) Save documents. C) See documents. D) Save documents with new names. Show Answer Correct Answer: B) Save documents. 19. 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. 20. To find total using certain conditions is ..... A) SUM. B) SUMIF. C) Countif. D) IF. E) MAX. Show Answer Correct Answer: B) SUMIF. 21. To create an email, which option we should select first? A) Compose/Write. B) Edit. C) New. D) Open. Show Answer Correct Answer: A) Compose/Write. 22. What is Mail Merge? A) Data preparation from MS Excel to be displayed at Ms.Word. B) Data preparation from MS Word to be displayed at Ms.Excel. C) Data preparation from MS Word to be displayed at Ms.Word. D) Data preparation from MS Excel to be displayed at Ms.Excel. Show Answer Correct Answer: A) Data preparation from MS Excel to be displayed at Ms.Word. 23. MS EXCEL IS AN ..... A) ELECTRONIC WORKBOOK. B) ELECTRONIC FOLDER. C) ELECTRONIC COLUMN. D) ELECTRONIC SPREADHEET. Show Answer Correct Answer: D) ELECTRONIC SPREADHEET. 24. Which is not included in the number processing software A) MS Exel. B) Photoshop. C) Open Office Calculator. D) WPS Spreadsheet. Show Answer Correct Answer: B) Photoshop. 25. It is a spreadsheet program file that you create in Excel that contains one or more worksheets. A) Worksheet. B) Workbook. C) Book. D) Active Cell. Show Answer Correct Answer: B) Workbook. ← PreviousNext →Related 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 8Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 9Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books