This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 7 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 7 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. In what tools can we set the size of a font? A) Fonts color. B) Fonts size. C) Bold. D) Italic. Show Answer Correct Answer: B) Fonts size. 2. Tabs you see at the bottom of your workbook file, labeled Sheet 1, Sheet 2, and so on. You can rename the tabs. They represent worksheets within the workbook. A) Function. B) Sheet Tabs. C) Workbook. D) Drag. Show Answer Correct Answer: B) Sheet Tabs. 3. What kind of referencing uses $ to keep the cell the same? A) Relative. B) Absolute. C) Magic. D) Heart. Show Answer Correct Answer: B) Absolute. 4. In Microsoft Excel, the file you create and edit is called: A) A form. B) A ledger. C) A table. D) A workbook. E) A record. Show Answer Correct Answer: D) A workbook. 5. I can find the lowest number in a range with the ..... function A) MIN. B) MAX. C) AVERAGE. D) COUNT. Show Answer Correct Answer: A) MIN. 6. Serves to show the number of pages, number of words, language that we write (type), etc., is a function of ..... A) Bar menu. B) Status bar. C) Tool bar. D) Scroll bar. Show Answer Correct Answer: B) Status bar. 7. In an Excel spreadsheet, what is the correct formula to multiply the value in B6 by the value in C12? A) (C12 X B6). B) = Bsh*12. C) Bsh*12. D) (12*bsh). Show Answer Correct Answer: B) = Bsh*12. 8. Making a graph is one of the functions of ..... A) Ms-word. B) Ms-power point. C) Ms-excel. D) All answers are wrong. E) OF THE. Show Answer Correct Answer: A) Ms-word. 9. The intersection of a row and column forms a small rectangular area called cell. A) False. B) True. C) All the above. D) None of the above. Show Answer Correct Answer: B) True. 10. Place where you can rename each worksheet. Located at the bottom of the worksheet window. A) Sheet tab. B) Formula. C) Name Box. D) Chart. Show Answer Correct Answer: A) Sheet tab. 11. ..... tab allows you to correct spelling and grammar issues as well as security portion A) Data. B) View. C) Review. D) None of the above. Show Answer Correct Answer: C) Review. 12. Below that is not an arithmetic function is ..... A) +. B) -. C) /. D) ?. Show Answer Correct Answer: D) ?. 13. Which error is obtained when a formatted number does not fit within a cell? A) #####. B) #DIV/0. C) #DIV@. D) #VALUE!. Show Answer Correct Answer: A) #####. 14. What is MS Excel? A) Spreadsheet. B) Database Management. C) Presentation. D) Workbook. Show Answer Correct Answer: A) Spreadsheet. 15. Allows you to create clear and defined boundaries for different sections of your worksheet. A) Cell Borders and Fill Colors. B) Headings. C) Font Size. D) Font Color. Show Answer Correct Answer: A) Cell Borders and Fill Colors. 16. The lines on your worksheet that separate the columns and rows. A) Sheet Tabs. B) Functions. C) Formula Bar. D) Cell Grid. Show Answer Correct Answer: D) Cell Grid. 17. Cells that run horizontally on a spreadsheet A) Row. B) Column. C) Workbook. D) Range. Show Answer Correct Answer: A) Row. 18. The symbol used to make absolute reference is ..... A) $. B) @. C) #. D) %. Show Answer Correct Answer: A) $. 19. The statistical function to find the highest value is ..... A) COUNT. B) MIN. C) MAX. D) SUM. Show Answer Correct Answer: C) MAX. 20. Division symbol in spreadsheet. A) /. B) +. C) =. D) None of the above. Show Answer Correct Answer: A) /. 21. The type of data that can be calculated mathematically is ..... A) Alphanumeric. B) Numeric. C) Text. D) Symbol. Show Answer Correct Answer: B) Numeric. 22. The file extension for Excel: A) .pptx. B) .docx. C) .xlsx. D) None of the above. Show Answer Correct Answer: C) .xlsx. 23. What application can you use to create emails? A) Word. B) PowerPoint. C) Excel. D) Outlook. Show Answer Correct Answer: D) Outlook. 24. Besides being able to help users in the number calculation process, spreadsheet is also able to help in the following aspects, except ..... A) Make graphics. B) Analyze data. C) Data management. D) Time management. Show Answer Correct Answer: D) Time management. 25. Which of the followings can not be performed in Microsoft Excel? A) Creating chart, making mathematical calculations. B) Inserting pictures, creating table. C) Making graphic design. D) Using formulas and functions. Show Answer Correct Answer: C) Making graphic design. ← 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 8Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 9Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 10Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books