This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 27 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 27 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What do you call the entries that have no value associated with them? A) Formula. B) Text. C) Value. D) Art. Show Answer Correct Answer: B) Text. 2. 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. 3. A row is horizontal. A) True. B) False. C) None. D) None of the above. Show Answer Correct Answer: A) True. 4. 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) Filter. D) Custom Filter. Show Answer Correct Answer: D) Custom Filter. 5. ..... is not a function in Excel. A) SUM. B) MIN. C) SUBTRACT. D) MAX. Show Answer Correct Answer: C) SUBTRACT. 6. Which of the following identifies a cell in Excel? A) Address. B) Formula. C) Name. D) Label. Show Answer Correct Answer: A) Address. 7. The first electronic spreadsheet software was ..... A) Ms-Excel. B) Microsoft Excel. C) VISICALC. D) Visual Calculator. Show Answer Correct Answer: C) VISICALC. 8. ..... 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. 9. What is the name of the 1st cell address A) 1A. B) AA. C) 11. D) A1. Show Answer Correct Answer: D) A1. 10. How are ROWS in MS EXCEL spreadsheet named? A) Numbers. B) Letters. C) Cells. D) Columns. Show Answer Correct Answer: A) Numbers. 11. Excel file is saved as a ..... A) Document. B) Workbook. C) Worksheets. D) Presentation. Show Answer Correct Answer: B) Workbook. 12. Every formula needs to begin with ..... A) =. B) (). C) ;. D) FORMULA. Show Answer Correct Answer: A) =. 13. Office applications used to make presentations are called ..... A) Ms. Word. B) Ms. Excel. C) Ms. Power Point. D) Ms. Publish. E) Google Docs. Show Answer Correct Answer: C) Ms. Power Point. 14. The intersection of a row and column: A) Cell. B) Row. C) Column. D) Gridline. Show Answer Correct Answer: A) Cell. 15. What will be the cell address of the cell formed by the intersection of the 10th Column and 10th Row A) F10. B) J10. C) D10. D) A10. Show Answer Correct Answer: B) J10. 16. 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. 17. The process of keeping or storing a workbook into the computer. A) Encoding. B) Saving. C) Surfing. D) Editing. Show Answer Correct Answer: B) Saving. 18. Which tool creates scenario with a set of values that Excel saves without changing the actual values. A) Data Table. B) Goal seek. C) Scenario manager. D) Solver. Show Answer Correct Answer: C) Scenario manager. 19. 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. 20. The option that reduces the font size of the data to accommodate it within the column width A) Shrink to fit. B) Columns. C) Text orientation. D) Wrap text. Show Answer Correct Answer: A) Shrink to fit. 21. 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. 22. Group Tab to set letters such as size, type of letters and style is A) Clipboard. B) Paragraph. C) Style. D) Font. Show Answer Correct Answer: D) Font. 23. 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. 24. 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. 25. 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 Word. B) MS Powerpoint. C) MS Excel. D) MS Paint. Show Answer Correct Answer: C) MS Excel. ← 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