This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 49 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 49 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. The extension used in Microsoft Office Excel 2007 is A) *.cdr. B) *.xlsx. C) *.ppt. D) *.exlx. Show Answer Correct Answer: B) *.xlsx. 2. An MS Excel file is synonymous with ..... A) A work table. B) A worksheet. C) A book sheet. D) A cell. E) A workbook. Show Answer Correct Answer: E) A workbook. 3. MS Excel is widely used for ..... , financial application, statistics and engineering calculations. A) Accounting. B) Word processing. C) Photo editing. D) Video editing. Show Answer Correct Answer: A) Accounting. 4. We can add a comment regarding any changes made in shared worksheet by: A) Edit > Changes > Comments. B) File > Changes > Comments. C) View > Changes > Comments. D) None. Show Answer Correct Answer: A) Edit > Changes > Comments. 5. Which ofthe following is not the correct method of editing the cell content? A) Press the Alt key. B) Press the F2 key. C) Click the formula bar. D) Double click the cell. Show Answer Correct Answer: A) Press the Alt key. 6. What format should I save my work as? A) Webp. B) MPP. C) Lonely. D) JPEG. Show Answer Correct Answer: D) JPEG. 7. What term describes explanatory text attached to a cell? A) Context. B) Callout. C) Comment. D) Dialog. Show Answer Correct Answer: C) Comment. 8. ..... are the combination of column letter and row number. A) Formula. B) Cell address. C) Operators. D) None of the above. Show Answer Correct Answer: B) Cell address. 9. What should be clicked to move on next cell A) Tab key. B) Arrow keys. C) Using the mouse pointer. D) All of the above. Show Answer Correct Answer: D) All of the above. 10. Which is the correct example for formula data A) =5+10. B) A1+B1 =. C) = A1B1. D) None of the above. Show Answer Correct Answer: A) =5+10. 11. Explain the difference between Sumif and Sumifs! A) Sumif is only used for numbers, Sumifs for text. B) Sumif add up all data, Sumifs did not add up at all. C) Sumif adds up data with one criterion, Sumifs adds up data with several criteria. D) Sumif and Sumifs have the same function. Show Answer Correct Answer: C) Sumif adds up data with one criterion, Sumifs adds up data with several criteria. 12. This classification indicates that the data has the potential to be used in calculations. A) Label. B) Value. C) Formula. D) Function. Show Answer Correct Answer: B) Value. 13. The excel window part used to move the work sheet in horizontal direction is ..... A) Scroll Bar Vertical. B) Scroll Bar Horizontal. C) Task Pane. D) Costumize. Show Answer Correct Answer: B) Scroll Bar Horizontal. 14. In Excel, a row is denoted by ..... A) Symbols. B) Letters. C) Numbers. D) Colors. Show Answer Correct Answer: C) Numbers. 15. Getting data from a cell located in a different worksheet is called? A) Accessing. B) Referencing. C) Updating. D) Functioning. Show Answer Correct Answer: B) Referencing. 16. Each Excel file is known as a ..... A) Worksheet. B) Workbook. C) Tab. D) Document. Show Answer Correct Answer: B) Workbook. 17. A ..... is a faded text or image behind the text in a document. A) Page orientation. B) Header. C) Watermark. D) None of the above. Show Answer Correct Answer: C) Watermark. 18. How many sheets does an excel window displays by default? A) 1. B) 2. C) 3. D) 4. Show Answer Correct Answer: C) 3. 19. Which function returns the current date? A) TIME. B) DATE. C) NOW. D) THEN. Show Answer Correct Answer: C) NOW. 20. ..... is description of the task that gives you information to design a spreadsheet. A) Briefcase. B) Summary design. C) Design brief. D) Structure brief. Show Answer Correct Answer: C) Design brief. 21. ..... tells you what type of organization is operating the network. A) GIF. B) Suffix. C) Website. D) Browser. Show Answer Correct Answer: B) Suffix. 22. Which is the right below which is the display of Microsoft Excel ..... A) Office Button. B) Tab Ribbon. C) Insert Function. D) All answers are correct. Show Answer Correct Answer: D) All answers are correct. 23. Word/Docs is a ..... program. A) Document. B) Spreadsheets. C) Presentation. D) Internet. Show Answer Correct Answer: A) Document. 24. The meeting between columns and rows in Microsoft Excel is known as A) Range. B) Cell. C) Sheet. D) Clipboard. Show Answer Correct Answer: B) Cell. 25. In spreadsheet what we can do? A) We can enter data. B) We can not edit data. C) We can not draw charts. D) We can not create worksheets. Show Answer Correct Answer: A) We can enter data. ← 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