This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 38 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 38 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. In a spreadsheet, all formulae must begin with ..... sign. A) #. B) =. C) $. D) &. Show Answer Correct Answer: B) =. 2. What image tool removes an unwanted portion of the image? A) Crop. B) Anchor. C) Canvas. D) Stacking. Show Answer Correct Answer: A) Crop. 3. What value would excel return for this formula? =(82-32)5+8*2 A) 30. B) 21. C) 26. D) 37. Show Answer Correct Answer: C) 26. 4. The sign of division in represented by the sign ..... A) =. B) +. C) -. D) /. Show Answer Correct Answer: D) /. 5. Which one is not included in the Mailing Menu A) Table of contens. B) Labels. C) Envelopes. D) Directory. Show Answer Correct Answer: A) Table of contens. 6. The following is a function of ms.word ..... A) Make posters. B) Create a database. C) Make images. D) Make a letter. E) Processing numbers. Show Answer Correct Answer: D) Make a letter. 7. What does the Average formula return? A) Returns the lowest argument. B) Returns the middle argument. C) Returns the three highest arguments. D) Returns the mean of all its arguments. Show Answer Correct Answer: D) Returns the mean of all its arguments. 8. ..... is a feature of MS Word used to represent hierarchy charts. A) WordArt. B) Smartart. C) All the above. D) None of the above. Show Answer Correct Answer: B) Smartart. 9. Social media is ..... A) Media to socialize with many people through online. B) Media to spread gossip. C) Media to do online learning. D) Media to spread viral news. Show Answer Correct Answer: A) Media to socialize with many people through online. 10. Fraction of 100 A) Percentage. B) Range. C) Numbers. D) Fraction. Show Answer Correct Answer: A) Percentage. 11. How to close MS-excel is ..... A) File-open. B) File-new. C) File-close. D) Edit-close. E) Edit-paste. Show Answer Correct Answer: C) File-close. 12. Joan wants to see her sales representatives in numerical order with the sales person who sold the least at the top. Which sorting option should she choose? A) Ascending. B) Customer Filter. C) Descending. D) Primary Sort. Show Answer Correct Answer: A) Ascending. 13. What Programming language is used in Excel A) Basic. B) Fortran. C) Visual Basic. D) Python. Show Answer Correct Answer: C) Visual Basic. 14. Can users move between various worksheets A) Yes. B) No. C) All the above. D) None of the above. Show Answer Correct Answer: A) Yes. 15. Every time writing the formula must begin with a sign ..... A) =. B) *. C) /. D) +. Show Answer Correct Answer: A) =. 16. Intersections of rows and column A) Box. B) Cell. C) All the above. D) None of the above. Show Answer Correct Answer: B) Cell. 17. Which symbol means to multiply? A) /. B) *. C) SUM. D) ( ). Show Answer Correct Answer: B) *. 18. In the formula =MAX(G4:G19), the cell references are an example of which term? A) Label. B) Value. C) Range. D) Numeric label. Show Answer Correct Answer: C) Range. 19. By default, the Excel workbook contains: A) 2 worksheets. B) 5 worksheets. C) 4 worksheets. D) 3 worksheets. Show Answer Correct Answer: D) 3 worksheets. 20. Total Income amount of money received before taxes A) Gross Income. B) Net Income. C) Income. D) Savings. Show Answer Correct Answer: A) Gross Income. 21. The following is an office application, except ..... A) Ms excell. B) Ms word. C) Ms power point. D) Adobe Reader. E) Google Docs. Show Answer Correct Answer: D) Adobe Reader. 22. What is meant by cells (cells) in Excel? A) Group from worksheets. B) A group of several cells. C) Meeting between rows and columns. D) Meeting between cells and range. Show Answer Correct Answer: C) Meeting between rows and columns. 23. Below that is not a number processing application program is ..... A) Lotus 123. B) Microsoft Excel. C) Star Office Writer. D) Open Office Calc. Show Answer Correct Answer: C) Star Office Writer. 24. Ctrl+P is a Shortcut Key works to feature A) Page setup. B) Customize. C) Heater. D) Print. Show Answer Correct Answer: D) Print. 25. The process of reverse calculation to achieve a desired result by using a single variable and a single cell. A) Scenario manager. B) Solver. C) Data Table. D) Goal Seek. Show Answer Correct Answer: D) Goal Seek. ← 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