This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 22 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 22 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following option is a formula? A) =SUM(A1:A5). B) Add A1-A5. C) Subtract the numbers. D) A1 = A5. Show Answer Correct Answer: A) =SUM(A1:A5). 2. A small box that holds data A) Row. B) Column. C) Cell. D) None of the above. Show Answer Correct Answer: C) Cell. 3. MS Excel is a ..... A) Database Management software. B) Presentation software. C) Workbook software. D) Spreadsheet software. Show Answer Correct Answer: D) Spreadsheet software. 4. Ms. Worksheet Section.Excel which displays the name of the workbook that is being active or opened A) Title Bar. B) Quick Accsess. C) Men's menu. D) Status Bar. Show Answer Correct Answer: A) Title Bar. 5. In Excel, the heading "boxes" going from left to right are called ..... A) Rows. B) Columns. C) Letters. D) Headers. Show Answer Correct Answer: B) Columns. 6. How would you write a cell reference formula for cell A1 subtracted by Cell C3? A) A1-kz. B) A1-kz =. C) = A1-kz. D) = KZ-A1. Show Answer Correct Answer: C) = A1-kz. 7. The intersection point of row and column is called? A) Pixel. B) Cell. C) Track. D) Pointer. Show Answer Correct Answer: B) Cell. 8. Once a type of graph is chosen it cannot be changed to other type A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 9. The Hyperlink function is used to create links to ..... A) Workbook locations. B) Pages on the internet. C) Files on network servers. D) All of the above. Show Answer Correct Answer: D) All of the above. 10. Which of the following would NOT be stored in a cell? A) Formula. B) Text. C) Number. D) Chart. Show Answer Correct Answer: D) Chart. 11. We can add charts in a way ..... A) Click the Home Menu Select Table. B) Click the Insert menu select chart. C) Click the Mailings menu select Table. D) Click the References menu select Design. E) Click the Design Menu Select Chart. Show Answer Correct Answer: B) Click the Insert menu select chart. 12. The following is a function of Ms.excel, except A) Making financial reporting. B) Make an attendance report. C) Make a financial bill. D) Perform mathematical operations. Show Answer Correct Answer: C) Make a financial bill. 13. Workbook is a collection of worksheets. A) Worksheets. B) Sheets. C) None of the above. D) None of the above. Show Answer Correct Answer: A) Worksheets. 14. Which function can be used to convert a text string to a date format in Excel? A) TEXT. B) VALUE. C) DATE VALUE. D) CONVERT. Show Answer Correct Answer: B) VALUE. 15. ..... programs perform specific tasks usually related to managing a computer, its devices and programs. A) DTP. B) DBMS. C) Utility. D) Application. Show Answer Correct Answer: C) Utility. 16. Nine dot grid is otherwise known as ..... A) Waffle iron. B) OF THE. C) WINDOWS. D) INBOX. Show Answer Correct Answer: A) Waffle iron. 17. MS Excel application is a processing application ..... A) Number. B) Symbol. C) Character. D) Letter. Show Answer Correct Answer: A) Number. 18. Pivot Table feature introduced by A) Lotus 123. B) Multi plan. C) MS Office. D) Open Office. Show Answer Correct Answer: A) Lotus 123. 19. What is meant by active cells is ..... A) The cell used at that time. B) The cells that appear in the worksheet. C) Cells containing the results of calculations. D) Cells containing data. E) Cells that contain formulas or formulas. Show Answer Correct Answer: A) The cell used at that time. 20. In a company, making financial statements will be easier to make using the application ..... A) Ms. Word. B) Ms. Excel. C) Ms. PowerPoint. D) Ms. Outlook. E) Ms. Publisher. Show Answer Correct Answer: B) Ms. Excel. 21. A spreadsheet program that allows you to store, organize, and analyze information. A) MS Excel. B) MS Word. C) MS PowerPoint. D) MS Access. Show Answer Correct Answer: A) MS Excel. 22. The bar where information appears as you input data is called ..... A) File bar. B) Help bar. C) Window bar. D) Formula bar. Show Answer Correct Answer: D) Formula bar. 23. Which of the following is an example of a cell reference? A) Column C. B) =SUM. C) Row 1. D) A5. Show Answer Correct Answer: D) A5. 24. Program groups to process specific data used for specific needs such as helping employment A) Programming language. B) Utility. C) Sisem operated. D) Application. Show Answer Correct Answer: D) Application. 25. 44 ..... tab shows backstage view. A) Home. B) Edit. C) File. D) None of the above. Show Answer Correct Answer: C) File. ← 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