This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 20 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 20 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Spreadsheets are best for doing what? A) Writing reports. B) Sorting data. C) Making lists. D) None of the above. Show Answer Correct Answer: C) Making lists. 2. Absolute address is a cell address whose value does not change if the data must be copied.The correct writing of absolute cells is ..... A) $ A1 $. B) $ A1. C) A$ $ 1. D) $ A$ 1. E) A1 $. Show Answer Correct Answer: D) $ A$ 1. 3. Ravi thinks MS-Excel is a word processing software. Correct him. A) Word document. B) Spreadsheet. C) Presentation Software. D) Calculator. Show Answer Correct Answer: B) Spreadsheet. 4. Coding is categorized into ..... except A) Animation. B) Graphic design. C) Games design. D) Web design. Show Answer Correct Answer: B) Graphic design. 5. In MS-Excel you can use the drag and drop method to A) Copy cell contents. B) Move cell contents. C) Add cell contents. D) (A) and (B). Show Answer Correct Answer: D) (A) and (B). 6. Which term is used to join the selected cells in to one cell? A) Filter. B) Wrap. C) Pivot. D) Merge. Show Answer Correct Answer: D) Merge. 7. To make a line on the cell, we can use ..... A) Insert. B) Format. C) Border. D) Style. E) Font. Show Answer Correct Answer: C) Border. 8. First electronic spreadsheet was conceived by A) And Bricklin. B) Bill Gates. C) Steve Jobs. D) IBM. Show Answer Correct Answer: A) And Bricklin. 9. A grid of rows and columns in which you enter text, numbers, and the results of calculations. A) Worksheet. B) Range. C) Spreadsheet. D) Chart. Show Answer Correct Answer: C) Spreadsheet. 10. What does the WWW means? A) Wide World Web. B) World Wide Web. C) World Web Wide. D) None of the above. Show Answer Correct Answer: B) World Wide Web. 11. Which of the following Excel charts represents only one value for each variable? A) Bar. B) Function. C) Pie. D) Lines. Show Answer Correct Answer: C) Pie. 12. To find out how many persons are there in a certain field, the following function is applied A) Average( : ). B) Count( : ). C) Counta (-;-). D) Counta (-:-). Show Answer Correct Answer: D) Counta (-:-). 13. The name of a cell is made up of a column letter and row number A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: A) TRUE. 14. An Active cell is the ..... A) Previous Cell Selected. B) Next cell selected. C) Current cell selected. D) None of the above. Show Answer Correct Answer: C) Current cell selected. 15. By default, in the Ms. WorksheetExcel will display ..... A) 1 sheet. B) 2 sheet. C) 3 sheet. D) 4 sheet. E) 5 sheet. Show Answer Correct Answer: C) 3 sheet. 16. ###### means A) Entered Number is Wrong. B) Misspelled. C) Cell is not wide enough. D) None of the above. Show Answer Correct Answer: C) Cell is not wide enough. 17. The "boxes" in Microsoft Excel are called ..... A) Griddies. B) Boxes. C) Cells. D) Spreadsheets. Show Answer Correct Answer: C) Cells. 18. You can't Copy the Formula to other cells. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 19. The number processing application is also called ..... A) Word Programming. B) Word Processor. C) Word Presentation. D) Spreadsheet. Show Answer Correct Answer: D) Spreadsheet. 20. This menu basically has a function that is almost the same as a storage.However, this menu has more specific functions such as selecting storage locations and changing file types. A) Save as. B) Save. C) Paste. D) Open. Show Answer Correct Answer: A) Save as. 21. Small input box on the left A) Formula Bar. B) Status Bar. C) Name box. D) None of the above. Show Answer Correct Answer: C) Name box. 22. Excel is what type of software? A) Word Processing. B) Presentation. C) Database. D) Spreadsheets. Show Answer Correct Answer: D) Spreadsheets. 23. The extension of the Microsoft Excel file is ..... A) *.pdf. B) *.xls. C) *.ppt. D) *.doc. E) *.html. Show Answer Correct Answer: B) *.xls. 24. Examples of word processing programs below, except ..... A) Notepad. B) Ms Access 2003. C) MS Word 2007. D) MS Word 2010. E) Wordpad. Show Answer Correct Answer: B) Ms Access 2003. 25. How will you graphically represent expenditure in different departments? A) Column Chart. B) Line Chart. C) Pie Chart. D) Dot Chart. Show Answer Correct Answer: C) Pie Chart. ← 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