This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 55 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 55 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. SUM, AVERAGE, MAX and VLOOKUP are examples of what? A) Functions. B) Tables. C) Formulae. D) Statistical tools. Show Answer Correct Answer: A) Functions. 2. How to integrate applications is as follows except ..... A) Messaging. B) Sharing Database. C) File Transfer. D) Coneccting Database. Show Answer Correct Answer: D) Coneccting Database. 3. The entry bar is also known as (AKA): A) Name box. B) Formula bar. C) Status bar. D) None of the above. Show Answer Correct Answer: B) Formula bar. 4. Merger ..... documents become ..... documents A) Two, two. B) Two, one. C) One, one. D) One two. Show Answer Correct Answer: B) Two, one. 5. Which part of Excel contains the commands for performing tasks? A) Row. B) Bar menu. C) Title Bar. D) Toolbar. Show Answer Correct Answer: B) Bar menu. 6. ..... Is a collection of cells in a worksheet in which we enter data A) Worksheet. B) Workbook. C) Cell address. D) Sheet tab. Show Answer Correct Answer: A) Worksheet. 7. In MS-Excel value used in a formula that does not change is called a A) Cell address. B) Constant. C) Function. D) None of these. Show Answer Correct Answer: B) Constant. 8. What do you call the intersection of column and row in Ms-Excel or other spreadsheet software? A) Cell. B) Coordination. C) Intersection. D) Joint point. Show Answer Correct Answer: A) Cell. 9. The location of a cell on a spreadsheet. It is a column letter followed by a row number. A) Cell range. B) Cell reference. C) Active cell. D) Row. Show Answer Correct Answer: B) Cell reference. 10. Individual box where a row and column intersect. A) Worksheet. B) Cell. C) Active cell. D) Column. Show Answer Correct Answer: B) Cell. 11. The menu only found on ms.word is A) Mailing. B) Data. C) Animation. D) Formula. Show Answer Correct Answer: A) Mailing. 12. In PowerPoint, under which tab can you change the slide background? A) Format. B) Design. C) Insert. D) File. Show Answer Correct Answer: B) Design. 13. To calculate the average in a range we use a formula ..... A) =sum(). B) =max(). C) =count(). D) =round(). E) =average(). Show Answer Correct Answer: E) =average(). 14. What is it called when one slide changes to the other? A) Transition. B) Animation. C) Switcharoo. D) Style Effect. Show Answer Correct Answer: A) Transition. 15. Each cell can hold a label or a value. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 16. A computer application that displays and organizes data is called ..... A) PowerPoint Presentation. B) Publisher. C) Electronic Spreadsheet. D) Word. Show Answer Correct Answer: C) Electronic Spreadsheet. 17. The box on the MS.EXCEL worksheet that is lined up with alphabet letters is called A) Line. B) Sel. C) Row. D) Column. Show Answer Correct Answer: D) Column. 18. A computer program that imitates a paper worksheet A) Video Game. B) Spreadsheets. C) Typing. D) Cell. Show Answer Correct Answer: B) Spreadsheets. 19. What is the keyboard shortcut to copy selected cells in Excel? A) Ctrl + C. B) Ctrl + V. C) Ctrl + X. D) Ctrl + Z. Show Answer Correct Answer: A) Ctrl + C. 20. In which tab wrap text feature is present in MS Excel 2007? A) Formulas. B) View. C) Insert. D) Home. Show Answer Correct Answer: D) Home. 21. MS Excel can accommodate up to how many columns? A) 16, 834. B) 15, 384. C) 16, 384. D) 13, 684. Show Answer Correct Answer: C) 16, 384. 22. Which function displays row data in a column or column data in a row? A) Rows. B) Transpose. C) Hyperlink. D) Index. Show Answer Correct Answer: B) Transpose. 23. What is the shortcut key for Save As in Excel? A) F12 (Function key). B) Ctrl + S. C) Ctrl + A. D) ALT + S. Show Answer Correct Answer: A) F12 (Function key). 24. Google, Bing and Yahoo are commonly known as? A) Web Browsers. B) Search Engines. C) Search Engineering. D) Hardware. Show Answer Correct Answer: B) Search Engines. 25. What tab in the ribbon do I click on to create a chart for my data? A) Formulas. B) Home. C) Insert. D) Page Layout. Show Answer Correct Answer: C) Insert. ← 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