This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 41 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 41 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the column header name for 14th Column A) D. B) E. C) X. D) N. Show Answer Correct Answer: D) N. 2. Which of these is the data type available in MS Excel? A) Number. B) Text. C) Formula. D) All of these. Show Answer Correct Answer: D) All of these. 3. These applications are applications used to process words, which mainly make documents such as letters, proposals, or reports, except ..... A) MS. Word. B) Open Office Spreadsheet. C) Google Docs. D) None of the above. Show Answer Correct Answer: B) Open Office Spreadsheet. 4. A type of network where computers are connected within the same city A) MAN (metropolitan area network). B) LAN (local area network). C) PAN (personal area network). D) Internet. Show Answer Correct Answer: A) MAN (metropolitan area network). 5. Another name for Microsoft Excel is ..... A) Document. B) Slide. C) Google form. D) Spreadsheet. Show Answer Correct Answer: D) Spreadsheet. 6. Shortcut key to go directly to cell A1 A) Ctrl + Home. B) Ctrl + F9. C) Ctrl + A1. D) Ctrl + End. Show Answer Correct Answer: A) Ctrl + Home. 7. What can a spreadsheet be used for? A) To record information in an organised manner. B) To perform mathematical calculations. C) To generate graphs and pie charts. D) All of the above. Show Answer Correct Answer: D) All of the above. 8. Spreadsheet models are useful because you can recreate a real life situations. A) Yes. B) No. C) All the above. D) None of the above. Show Answer Correct Answer: A) Yes. 9. What contains both the column and the row number? A) Formula. B) Cell Address. C) Row. D) None of the above. Show Answer Correct Answer: B) Cell Address. 10. Why is the integration of office applications important? A) To reduce the use of the internet. B) To improve image quality. C) To facilitate work and efficiency. D) To save storage space. Show Answer Correct Answer: C) To facilitate work and efficiency. 11. Anybody that can write computer codes or program is also known as a ..... A) Coding. B) Programmer or Coder. C) Typist. D) Computer scientist. Show Answer Correct Answer: B) Programmer or Coder. 12. Microsoft Excel functions are as follows, except. A) Make a financial statement. B) Calculate currency exchange rate. C) Present data precisely, neatly, and accurately. D) Make a paper. E) Make a diagram. Show Answer Correct Answer: D) Make a paper. 13. This data type is used to label values or sometimes part of data. A) Numbers. B) Texts. C) Date and Time. D) Currency. Show Answer Correct Answer: B) Texts. 14. What do we need to click to create a new worksheet in our workbook? A) Active cell. B) New sheet button. C) Sheet tab. D) None of the above. Show Answer Correct Answer: B) New sheet button. 15. In Excel, Columns Are Labelled AS ..... In Excel, the columns are labeled ..... is labeled. A) A, B, C, etc. B) 1, 2, 3 etc. C) A1, A2, etc. D) $ A$ 1, $ A$ 2, etc. Show Answer Correct Answer: A) A, B, C, etc. 16. What is located at the top of the Excel window and displays the name of the workbook? A) Row. B) Bar menu. C) Title Bar. D) Toolbar. Show Answer Correct Answer: C) Title Bar. 17. Press ..... to select a row in which a cell is active. A) Shift +space bar. B) Shift. C) Shift +enter. D) None of the above. Show Answer Correct Answer: A) Shift +space bar. 18. What is the Sum formula? A) Sum( ). B) Sum( )=. C) =Sum( ). D) =( )Sum. Show Answer Correct Answer: C) =Sum( ). 19. An equation that calculates a new value from values currently in a worksheet. A) Formula Bar. B) Column. C) Cell. D) Formula. Show Answer Correct Answer: D) Formula. 20. It is a collection of data that is stored electronically as a series of records in a table. A) Spreadsheet. B) Presentation. C) Database. D) MS Word. Show Answer Correct Answer: C) Database. 21. Mathematical calculations in a spreadsheet are called: A) Words. B) Values. C) Formulas. D) Labels. Show Answer Correct Answer: C) Formulas. 22. Microsoft Excel is a ..... used to analyze data A) Software. B) Hardware. C) All the above. D) None of the above. Show Answer Correct Answer: A) Software. 23. Writing the function of finding the smallest value is ..... A) = From (Ah:A 12). B) From (District:12 A). C) =MAX(A8:A12). D) =COUNT(A7:A10). Show Answer Correct Answer: A) = From (Ah:A 12). 24. What to do to copy a nd moving worksheet? A) Click on move or copy option. B) Do magic. C) Call ironman. D) Call bill gates ( correct answer ). Show Answer Correct Answer: A) Click on move or copy option. 25. To accept a formula in a cell, press the ..... key. A) Tab. B) Enter. C) Ctrl. D) Shift. Show Answer Correct Answer: B) Enter. ← 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