This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 26 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 26 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. String data type A) Row. B) Column. C) Text. D) Workbook. Show Answer Correct Answer: C) Text. 2. The following are steps to make Step By Step Mail Merge Wizard is ..... A) Insert-Start mail Merge. B) Mailing-Start Mail Merge. C) Mailing-Select Recipients. D) View-Start Mail Merger. Show Answer Correct Answer: B) Mailing-Start Mail Merge. 3. 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. 4. SUM, AVERAGE, MAX and MIN are preset formulas on the ..... menu. A) Filter. B) Functions. C) Border. D) Fill color. Show Answer Correct Answer: B) Functions. 5. Which option reorients the content of copied cells when pasting? Data in rows is pasted into columns and vice versa. A) Keep source column width. B) Transpose. C) Keep source formatting. D) Values & Source Formatting. Show Answer Correct Answer: B) Transpose. 6. String of type document in which data are organized in columns and rows. A) Workbook. B) Worksheet. C) Text. D) Spreadsheets. Show Answer Correct Answer: D) Spreadsheets. 7. A formula should always start with an ..... A) =. B) +. C) -. D) None of the above. Show Answer Correct Answer: A) =. 8. 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. 9. 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. 10. The function COUNT is specific for ..... A) Counting cells. B) Counting text. C) Counting number. D) Counting tables. Show Answer Correct Answer: C) Counting number. 11. 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. 12. What is the collection of worksheets called? A) Ledger. B) Book. C) Testbook. D) Workbook. Show Answer Correct Answer: D) Workbook. 13. Which one is the first word processor application A) MS word. B) Apple i work. C) Sun star office. D) Word star. Show Answer Correct Answer: D) Word star. 14. 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. 15. The symbol of greater than use in inserting text and numeric data. A) *. B) >. C) &. D) None of the above. Show Answer Correct Answer: B) >. 16. Below this is not an internet function, namely ..... A) Searching for information. B) Send letters. C) Meet clients. D) Get material. Show Answer Correct Answer: C) Meet clients. 17. 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. 18. 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. 19. What symbol is used for division (divide)? A) *. B) /. C) +. D) -. Show Answer Correct Answer: B) /. 20. 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) = MAX(B2:E2). C) = SUM(B2, E2/4). D) = AVERAGE (B2:E2). Show Answer Correct Answer: D) = AVERAGE (B2:E2). 21. 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. 22. Numbers in spreadsheet are known as ..... A) Values. B) Labels. C) All the above. D) None of the above. Show Answer Correct Answer: A) Values. 23. In Excel, the name of the bar where information appears as you input data is called? A) File Bar. B) Status Bar. C) Formula Bar. D) Help Bar. Show Answer Correct Answer: C) Formula Bar. 24. 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. 25. The numbers in spreadsheet are called ..... A) Values. B) Labels. C) Digits. D) Letters. Show Answer Correct Answer: A) Values. ← 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