This quiz works best with JavaScript enabled. Home > Cbse > Class 7 > Computer Science > Ms Excel Spreadsheet > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 14 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 14 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. In a worksheet, there are ..... columns. A) 16, 384. B) 16, 382. C) 16, 390. D) 16, 385. Show Answer Correct Answer: A) 16, 384. 2. To select a group of cells, you must click each cell individually until all cells in the range are selected. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 3. When was first elctric spreadsheet invented? what was it's name? A) 1979, Visicalc. B) 1978, Compu. C) 1950, spreadsheet. D) 1978, Visicalc. Show Answer Correct Answer: D) 1978, Visicalc. 4. Which of the following is not a valid bar in MS-Excel? A) Paint Bar. B) Title Bar. C) Formula Bar. D) Bar menu. Show Answer Correct Answer: A) Paint Bar. 5. Spreadsheet type applications designed to process numbers or data are ..... A) Database. B) Microsoft word. C) Microsoft Excel. D) Corel draw. E) Microsoft access. Show Answer Correct Answer: C) Microsoft Excel. 6. In Excel, Column is denoted by ..... A) Formulas. B) Letters. C) Numbers. D) Symbols. Show Answer Correct Answer: B) Letters. 7. Office applications that are integrated with Microsoft PowerPoint and others as well, which can create presentation, infographic, A4 document, and various design templates are office applications ..... A) Canva. B) Google Jamboard. C) ClassPoint. D) Google Slide. E) PowerPoint. Show Answer Correct Answer: A) Canva. 8. In a worksheet, you ..... edit rows, columns and cells. A) Can. B) Cannot. C) All the above. D) None of the above. Show Answer Correct Answer: A) Can. 9. Columns in MS Excel ranges from ..... to ..... A) A to XFD. B) And this is. C) A to BZ. D) A to WFD. Show Answer Correct Answer: A) A to XFD. 10. The formula for calculating the overall numbers in MS.Excel is ..... A) MAX. B) MIN. C) SUM. D) IF. Show Answer Correct Answer: C) SUM. 11. MS Excel is a/an A) Painting software. B) Spreadsheet software. C) Word processing software. D) Database software. Show Answer Correct Answer: B) Spreadsheet software. 12. The most important thing that is carried out in inputting a formula in Ms.Excel is ..... A) Colon. B) Equal. C) Semicolon. D) Brackets open and cover brackets. Show Answer Correct Answer: B) Equal. 13. If you selected (A1:B5) what is this called? A) Row. B) Cell range. C) Column. D) Cell grouping. Show Answer Correct Answer: B) Cell range. 14. WPS Office or better known as Writter, Percentation, and ..... A) Software. B) Brainware. C) Hardware. D) Spreadsheet. Show Answer Correct Answer: D) Spreadsheet. 15. Which command will put a procedure in the computer memory? A) Save. B) Erase. C) Delete. D) Load. Show Answer Correct Answer: A) Save. 16. Take away 2 from 10 A) 7. B) 8. C) 9. D) None of the above. Show Answer Correct Answer: B) 8. 17. Microsoft Excel is categorize as? A) Presentation Software. B) Database Software. C) Spreadsheet Software. D) Word Processing Software. Show Answer Correct Answer: C) Spreadsheet Software. 18. 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. 19. Excel files have a default extension of A) .pptx. B) .wk1. C) .xlsx. D) .docx. Show Answer Correct Answer: C) .xlsx. 20. Statistics Function in Ms.Excel to calculate the average is A) Mean. B) Average. C) Sum. D) Count. Show Answer Correct Answer: B) Average. 21. What is the Formula sign for multiply? A) . B) *. C) All the above. D) None of the above. Show Answer Correct Answer: B) *. 22. 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. 23. Which option in Excel helps you to rotate your text diagonally or vertically? A) Increase Indent. B) Merge & Center. C) Wrap Text. D) Text Orientation. E) Decrease Indent. Show Answer Correct Answer: D) Text Orientation. 24. How can I cut away the background and extra information from an image? A) The Arrange Tool. B) The Liquify Tool. C) The Cutout Tool. D) The Retouch Tool. Show Answer Correct Answer: C) The Cutout Tool. 25. 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. 26. When you right-click and select the 'Format Cells' option in MS Excel 2010, which of the following Tab is NOT visible A) Alignment. B) Font. C) Sheet. D) Fill. E) Border. Show Answer Correct Answer: C) Sheet. 27. How do you make a cell the active cell? A) Cells are always active. B) Click the ACTIVE button. C) Click on the cell. D) Click INSERT CELL. Show Answer Correct Answer: C) Click on the cell. 28. 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: A) = A1*A7. 29. 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. 30. 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. 31. Choose Excel Extension Excel: A) .ppt. B) .xls. C) .doc. D) .exe. Show Answer Correct Answer: B) .xls. 32. In the current presentation, if we want to insert a new slide, we can choose which of these? A) Ctrl + N. B) Ctrl + F. C) Ctrl + M. D) Ctrl + O. Show Answer Correct Answer: C) Ctrl + M. 33. What is the shortcut key for Replace? A) ALT + H. B) Ctrl + H. C) ALT + R. D) Ctrl + R. Show Answer Correct Answer: B) Ctrl + H. 34. What are the uses of the Excel Sumif formula? A) Add up data on certain ranges that have one criterion. B) Add up data on certain ranges that have many criteria. 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: A) Add up data on certain ranges that have one criterion. 35. 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. 36. To open the document that has been saved then done through the icon ..... A) Save. B) Save As. C) New. D) Open. Show Answer Correct Answer: D) Open. 37. Programs in Ms.Office that are useful for managing databases are ..... A) Ms.Access. B) Ms.Outlook. C) Ms.Excel. D) Ms.Word. Show Answer Correct Answer: A) Ms.Access. 38. A moving picture is called ..... A) Png. B) Gif. C) Jpg. D) Jpeg. Show Answer Correct Answer: B) Gif. 39. What version of Excel are we using in class? A) Excel 2010. B) Excel 2015. C) Excel 2017. D) Excel 2018. Show Answer Correct Answer: A) Excel 2010. 40. The first process in making mail merge is ..... A) Create a word file, then save the file. B) After the data is ready, open MS Word. C) After the data is ready, open MS Excel. D) Create an excel file, then save the file. Show Answer Correct Answer: D) Create an excel file, then save the file. 41. A ..... is made up of operands and operators, for example "=C2+D2" . A) Rule. B) Formula. C) Function. D) Math. Show Answer Correct Answer: B) Formula. 42. Excel is part of A) Access. B) Microsoft Office. C) PowerPoint. D) None of the above. Show Answer Correct Answer: B) Microsoft Office. 43. Paste copy techniques in office applications are often referred to as ..... A) Cut paste. B) The paste. C) Copy paste. D) Paste copy. E) Cut the. Show Answer Correct Answer: C) Copy paste. 44. The default row height is ..... and the default column width is ..... A) 8.09, 14.06. B) 14.50, 8.09. C) None of the above. D) None of the above. Show Answer Correct Answer: B) 14.50, 8.09. 45. By default, how many sheet/s can you see when you open a MS-Excel application? A) Two. B) Three. C) One. D) Four. Show Answer Correct Answer: C) One. 46. A Chart is a pictorial representation of data A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 47. The sum of all numbers divided by the amount of numbers. A) Average. B) Median. C) Minimum. D) Maximun. Show Answer Correct Answer: A) Average. 48. The default file name of Excel A) 1 book. B) Book 1. C) Spreadsheets. D) Ms Excel. Show Answer Correct Answer: B) Book 1. 49. What is an excel file that contains individual worksheets called? A) Active cell. B) Worksheet. C) Workbook. D) Spreadsheet. Show Answer Correct Answer: C) Workbook. 50. We use forward slash (/ ) operator in an Excel formulas to: A) ADD. B) Divide. C) All the above. D) None of the above. Show Answer Correct Answer: B) Divide. 51. Which of the following cannot be used to create a spreadsheet? A) Google Docs. B) Google Sheets. C) Microsoft Excel. D) Open Office Calc. Show Answer Correct Answer: A) Google Docs. 52. ..... is the popular Windows spreadsheet program that provides worksheets, charts, database and list operations, and application programming all in one software environment. A) MS. Excel. B) MS. PowerPoint. C) MS. Word. D) MS. Access. Show Answer Correct Answer: A) MS. Excel. 53. The Object Linking command on MS Office aims to ..... objects derived from other applications. A) Copy. B) Combine. C) Attach. D) Cut. E) Connect. Show Answer Correct Answer: E) Connect. 54. Which feature of Excel allows you to easily arrange and summarize complex data? A) Pivot Table. B) Smart Art Graphics. C) Table. D) Charts. Show Answer Correct Answer: A) Pivot Table. 55. The steps used to open the Microsoft Excel 2007 program are ..... A) Start-program-Microsoft office-Microsoft excel 2007. B) Start-program-paint. C) Start-program word-program. D) Start-program-accessories-Microsoft excel 2007. E) Start-program-close. Show Answer Correct Answer: A) Start-program-Microsoft office-Microsoft excel 2007. 56. Radio is one of the ICTs? A) Correct. B) Salah. C) All the above. D) None of the above. Show Answer Correct Answer: A) Correct. 57. In general, Office applications include the following application, except ..... A) Number processing application. B) Database application. C) Image processing application. D) Presentation application. E) Word processing application. Show Answer Correct Answer: C) Image processing application. 58. The process of arranging the items of a column in some sequence or order is known as A) Database. B) Sorting. C) Autofill. D) None of the above. Show Answer Correct Answer: B) Sorting. 59. What is the name of the term used to repost and share with other followers is called ..... A) Follow. B) Retweet. C) Unfollowing. D) Followers. Show Answer Correct Answer: B) Retweet. 60. To put the cell back or copy with the command ..... A) Click the Edit menu $\rightarrow$ COP. B) Click the Edit Menu $\rightarrow$ Paste. C) Click the View menu $\rightarrow$ Paste. D) Click the Edit Menu $\rightarrow$ Cut. E) Click the View Menu $\rightarrow$ Cut. Show Answer Correct Answer: B) Click the Edit Menu $\rightarrow$ Paste. ← PreviousNext →Related QuizzesComputer Science QuizzesClass 7 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 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books