This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 34 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 34 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. WPS Office or better known as Writter, Percentation, and ..... A) Software. B) Spreadsheet. C) Hardware. D) Brainware. Show Answer Correct Answer: B) Spreadsheet. 2. Which command will put a procedure in the computer memory? A) Save. B) Erase. C) Load. D) Delete. Show Answer Correct Answer: A) Save. 3. Take away 2 from 10 A) 7. B) 8. C) 9. D) None of the above. Show Answer Correct Answer: B) 8. 4. Microsoft Excel is categorize as? A) Word Processing Software. B) Database Software. C) Spreadsheet Software. D) Presentation Software. Show Answer Correct Answer: C) Spreadsheet Software. 5. The function that tell you how many entire are there in the specified cell A) Average. B) Autocount. C) Count. D) None of the above. Show Answer Correct Answer: C) Count. 6. Excel files have a default extension of A) .xlsx. B) .docx. C) .pptx. D) .wk1. Show Answer Correct Answer: A) .xlsx. 7. Statistics Function in Ms.Excel to calculate the average is A) Sum. B) Average. C) Mean. D) Count. Show Answer Correct Answer: B) Average. 8. To give a frame to the cell, the menu that must be selected in the Cells format box is A) Number. B) Alignment. C) Borders. D) Font. Show Answer Correct Answer: C) Borders. 9. What is the Formula sign for multiply? A) . B) *. C) All the above. D) None of the above. Show Answer Correct Answer: B) *. 10. It contains the most essential functions and commands that you will use to format and edit your document. A) File tab. B) Home tab. C) Status bar. D) None of the above. Show Answer Correct Answer: B) Home tab. 11. Which option in Excel helps you to rotate your text diagonally or vertically? A) Wrap Text. B) Merge & Center. C) Text Orientation. D) Increase Indent. E) Decrease Indent. Show Answer Correct Answer: C) Text Orientation. 12. How can I cut away the background and extra information from an image? A) The Arrange Tool. B) The Liquify Tool. C) The Retouch Tool. D) The Cutout Tool. Show Answer Correct Answer: D) The Cutout Tool. 13. Rows are the vertical divisions of a worksheet that are identified by number. A) False. B) True. C) All the above. D) None of the above. Show Answer Correct Answer: A) False. 14. The intersection of a column and a row is called A) Cell. B) Box. C) Edit. D) Line. Show Answer Correct Answer: A) Cell. 15. Excel is a: A) Database application. B) Spreadsheet application. C) Word processing application. D) None of the above. Show Answer Correct Answer: B) Spreadsheet application. 16. When you right-click and select the 'Format Cells' option in MS Excel 2010, which of the following Tab is NOT visible A) Font. B) Sheet. C) Border. D) Alignment. E) Fill. Show Answer Correct Answer: B) Sheet. 17. How do you make a cell the active cell? A) Click the ACTIVE button. B) Click INSERT CELL. C) Click on the cell. D) Cells are always active. Show Answer Correct Answer: C) Click on the cell. 18. Which Formula is written correctly for multiplying cell A1 and A7? A) = A1+A7. B) = A1*A7. C) A1+A7. D) A1*A7. Show Answer Correct Answer: B) = A1*A7. 19. In Excel, rows are identified by this A) Letters. B) Numbers. C) All the above. D) None of the above. Show Answer Correct Answer: B) Numbers. 20. 2 ..... combines a cell with adjacent empty cells to create one large cell. A) Concatenate. B) Auto Fit. C) Merging. D) None of the above. Show Answer Correct Answer: C) Merging. 21. Choose Excel Extension Excel: A) .xls. B) .exe. C) .doc. D) .ppt. Show Answer Correct Answer: A) .xls. 22. In the current presentation, if we want to insert a new slide, we can choose which of these? A) Ctrl + F. B) Ctrl + O. C) Ctrl + M. D) Ctrl + N. Show Answer Correct Answer: C) Ctrl + M. 23. What is the shortcut key for Replace? A) Ctrl + R. B) Ctrl + H. C) ALT + H. D) ALT + R. Show Answer Correct Answer: B) Ctrl + H. 24. What are the uses of the Excel Sumif formula? A) Add up data on certain ranges that have many criteria. B) Add up data on certain ranges that have one criterion. C) Count the amount of data in a particular range with one criterion. D) Count the amount of data in a particular range with many criteria. Show Answer Correct Answer: B) Add up data on certain ranges that have one criterion. 25. When you are typing data that is in a series, such as days of the week, you can use this tool to complete the series. A) Autous. B) Custom Fill. C) Fill Handle. D) Ctrl+C. Show Answer Correct Answer: C) Fill Handle. ← 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