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 11 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 11 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the purpose of spreadsheets? A) To present information on different engaging slides. B) To deliver a speech to a crowd. C) To perform basic and complex math computations in an organized way. D) To excel your research papers and citations. Show Answer Correct Answer: C) To perform basic and complex math computations in an organized way. 2. Dan Bricklin and ..... co-invented the software called visicalc. A) Eric Thompson. B) Bob Frankston. C) And Bricklin. D) None of the above. Show Answer Correct Answer: B) Bob Frankston. 3. It is on-screen spreadsheet that contains various cell in columns and rows. A) Worksheet. B) Workbook. C) MS Excel. D) MS Word. Show Answer Correct Answer: A) Worksheet. 4. Which is the Input device? A) Monitor. B) Printer. C) Keyboard. D) Jamboard. Show Answer Correct Answer: C) Keyboard. 5. A cell name contains A) Column numbers and row letters. B) Column letters and row numbers. C) All the above. D) None of the above. Show Answer Correct Answer: B) Column letters and row numbers. 6. Which of the following is not the advantage of Ms-EXCEL? A) We can represent data through different charts and graphs. B) We can easily perform calculations by using different functions available in this program. C) We can work with two or more than two worksheet at a single time. D) It is a software that allows us to create, edit, view, format and print text document in the computer. Show Answer Correct Answer: D) It is a software that allows us to create, edit, view, format and print text document in the computer. 7. String data type A) Text. B) Column. C) Row. D) Workbook. Show Answer Correct Answer: A) Text. 8. The following are steps to make Step By Step Mail Merge Wizard is ..... A) View-Start Mail Merger. B) Insert-Start mail Merge. C) Mailing-Select Recipients. D) Mailing-Start Mail Merge. Show Answer Correct Answer: D) Mailing-Start Mail Merge. 9. MS Excel is a type of Presentation Software. A) False. B) True. C) All the above. D) None of the above. Show Answer Correct Answer: A) False. 10. SUM, AVERAGE, MAX and MIN are preset formulas on the ..... menu. A) Fill color. B) Functions. C) Border. D) Filter. Show Answer Correct Answer: B) Functions. 11. Which option reorients the content of copied cells when pasting? Data in rows is pasted into columns and vice versa. A) Values & Source Formatting. B) Transpose. C) Keep source column width. D) Keep source formatting. Show Answer Correct Answer: B) Transpose. 12. String of type document in which data are organized in columns and rows. A) Spreadsheets. B) Workbook. C) Worksheet. D) Text. Show Answer Correct Answer: A) Spreadsheets. 13. A formula should always start with an ..... A) =. B) +. C) -. D) None of the above. Show Answer Correct Answer: A) =. 14. Department group of the home tab used for quick addition of number in cells A) Auto add. B) Autoosum. C) Quick sum. D) None of the above. Show Answer Correct Answer: A) Auto add. 15. What are the basic rectangular building blocks of a spreadsheet? A) Cells. B) Zoom slider. C) Help button. D) All of these. Show Answer Correct Answer: A) Cells. 16. The function COUNT is specific for ..... A) Counting text. B) Counting cells. C) Counting tables. D) Counting number. Show Answer Correct Answer: D) Counting number. 17. The number processing program/spreadsheet contains certain calculations used to analyze data in the form ..... A) Email, letter, and sales. B) Time schedule, dissemination of invitations, and mailing lists. C) Statistical data, accounting calculations, and making time schedules. D) Graphics, presentations, and letters. Show Answer Correct Answer: C) Statistical data, accounting calculations, and making time schedules. 18. What is the collection of worksheets called? A) Workbook. B) Book. C) Testbook. D) Ledger. Show Answer Correct Answer: A) Workbook. 19. Which one is the first word processor application A) Word star. B) Apple i work. C) MS word. D) Sun star office. Show Answer Correct Answer: A) Word star. 20. State whether the statements are True or False.Excel is used for creating presentation. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 21. Below this is not an internet function, namely ..... A) Meet clients. B) Get material. C) Searching for information. D) Send letters. Show Answer Correct Answer: A) Meet clients. 22. What is said to make changes to a document? A) Creating. B) Editing. C) Modifying. D) None of these. Show Answer Correct Answer: B) Editing. 23. What techniques are often used to copy and stick between applications? A) Save As. B) Print. C) Copy-Paste. D) Drag and Drop. Show Answer Correct Answer: C) Copy-Paste. 24. What symbol is used for division (divide)? A) +. B) /. C) -. D) *. Show Answer Correct Answer: B) /. 25. See the following formula. Which of the following formula is the another method of the given formula?=(B2+C2+D2+E2)/4 A) = SUM (B2, C2, D2, E2). B) = SUM(B2, E2/4). C) = AVERAGE (B2:E2). D) = MAX(B2:E2). Show Answer Correct Answer: C) = AVERAGE (B2:E2). 26. Provides easy access to frequently used commands: A) Group. B) Quick Access Toolbar. C) Cell. D) None of the above. Show Answer Correct Answer: B) Quick Access Toolbar. 27. In Excel, the name of the bar where information appears as you input data is called? A) Status Bar. B) Formula Bar. C) Help Bar. D) File Bar. Show Answer Correct Answer: B) Formula Bar. 28. Round the number 83 to the nearest tens A) 90. B) 80. C) 60. D) None of the above. Show Answer Correct Answer: B) 80. 29. The numbers in spreadsheet are called ..... A) Digits. B) Labels. C) Values. D) Letters. Show Answer Correct Answer: C) Values. 30. What do you call the entries that have no value associated with them? A) Art. B) Formula. C) Text. D) Value. Show Answer Correct Answer: C) Text. 31. Hyperlink in Calc can be used to jump from from A) One sheet to another. B) One sheet to website. C) One section to another section of same sheet. D) All of the above. Show Answer Correct Answer: D) All of the above. 32. A row is horizontal. A) True. B) False. C) None. D) None of the above. Show Answer Correct Answer: A) True. 33. Joan has created a spreadsheet that displays sales of her employees. She would like to view only those employees with sales above $ 25, 000 who are from Region 3. What option will allow her to do that? A) Ascending. B) Descending. C) Custom Filter. D) Filter. Show Answer Correct Answer: C) Custom Filter. 34. ..... is not a function in Excel. A) MAX. B) SUM. C) SUBTRACT. D) MIN. Show Answer Correct Answer: C) SUBTRACT. 35. Which of the following identifies a cell in Excel? A) Address. B) Name. C) Label. D) Formula. Show Answer Correct Answer: A) Address. 36. The first electronic spreadsheet software was ..... A) Visual Calculator. B) Ms-Excel. C) Microsoft Excel. D) VISICALC. Show Answer Correct Answer: D) VISICALC. 37. ..... is the easiest way to add a SUM formula A) Auto-sum. B) Average car. C) All the above. D) None of the above. Show Answer Correct Answer: A) Auto-sum. 38. What is the name of the 1st cell address A) AA. B) 11. C) 1A. D) A1. Show Answer Correct Answer: D) A1. 39. How are ROWS in MS EXCEL spreadsheet named? A) Numbers. B) Columns. C) Letters. D) Cells. Show Answer Correct Answer: A) Numbers. 40. Excel file is saved as a ..... A) Workbook. B) Presentation. C) Worksheets. D) Document. Show Answer Correct Answer: A) Workbook. 41. Every formula needs to begin with ..... A) FORMULA. B) =. C) ;. D) (). Show Answer Correct Answer: B) =. 42. Office applications used to make presentations are called ..... A) Ms. Excel. B) Ms. Publish. C) Ms. Power Point. D) Ms. Word. E) Google Docs. Show Answer Correct Answer: C) Ms. Power Point. 43. What will be the cell address of the cell formed by the intersection of the 10th Column and 10th Row A) A10. B) J10. C) F10. D) D10. Show Answer Correct Answer: B) J10. 44. It select the content of the entire worksheet. A) Name box. B) Formula bar. C) Sheet tab. D) Select all button. Show Answer Correct Answer: D) Select all button. 45. The process of keeping or storing a workbook into the computer. A) Editing. B) Saving. C) Encoding. D) Surfing. Show Answer Correct Answer: B) Saving. 46. Which tool creates scenario with a set of values that Excel saves without changing the actual values. A) Goal seek. B) Solver. C) Scenario manager. D) Data Table. Show Answer Correct Answer: C) Scenario manager. 47. In 1978 Dan Bricklin gave the idea of a interactive visible calculator called ..... A) Brickcalc. B) VISICALC. C) Visualcalc. D) None of the above. Show Answer Correct Answer: B) VISICALC. 48. The option that reduces the font size of the data to accommodate it within the column width A) Wrap text. B) Shrink to fit. C) Columns. D) Text orientation. Show Answer Correct Answer: B) Shrink to fit. 49. In MS Excel you can use Mathematical symbols Such as (+, -, *, /) to do a simple calculation A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 50. Group Tab to set letters such as size, type of letters and style is A) Clipboard. B) Font. C) Paragraph. D) Style. Show Answer Correct Answer: B) Font. 51. What is the function of a formula in Excel? A) Change the font style. B) Perform calculations. C) Insert images. D) None of the above. Show Answer Correct Answer: B) Perform calculations. 52. Notepad is an example of Word Processor A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 53. Among the applications you have learned over the years, identify the software that stores data in the form of tables, filters data and allows the user to calculate totals fast is ..... A) MS Paint. B) MS Powerpoint. C) MS Excel. D) MS Word. Show Answer Correct Answer: C) MS Excel. 54. How many rows are there in MS-EXCEL? A) 10, 48, 570. B) 10, 48, 576. C) 10, 49, 576. D) 10, 48, 577. Show Answer Correct Answer: B) 10, 48, 576. 55. A cell is identified by: A) Row only. B) Column only. C) Column and row. D) None of these. Show Answer Correct Answer: C) Column and row. 56. Rio wants to create an attendance sheet for her class. The worksheet includes the names of the students, class number and dates for the school days. What data type will not be of used for the said worksheet? A) Numbers. B) Texts. C) Date and Time. D) Currency. Show Answer Correct Answer: D) Currency. 57. What does the Goal Seek tool do? A) Allows you to see how changing one data item in a formula affects the others. B) Automatically sorts or totals data. C) Highlights the major functions and outcomes of your data set. D) Allows you to add values in a selection of cells. Show Answer Correct Answer: A) Allows you to see how changing one data item in a formula affects the others. 58. In a spreadsheet, Rows move in ..... direction. A) Vertical. B) Horizontal. C) Diagonal. D) None of the above. Show Answer Correct Answer: B) Horizontal. 59. The types of data can be feed in spreadsheet are A) 3. B) 2. C) 4. D) None of the above. Show Answer Correct Answer: A) 3. 60. Coding can is also known as ..... A) Coding. B) Programmer. C) Coder. D) Programming. Show Answer Correct Answer: D) Programming. ← 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