This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 33 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 33 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Functions in MS Excel Must Begin With ..... Must Start Function in MS Excel ..... A) ( ). B) =. C) +. D) >. Show Answer Correct Answer: B) =. 2. A student has a value of three subjects namely 50, 70, and 60. The student will pass if the single IF function in Excel for the total score is ..... A) = If (student> = 75; pass; failed). B) = If (student = 75; pass; fail). C) = If (student> = 60; pass; failed). D) = If (student> 65; pass; failed). E) = If (student> = 70; pass; failed). Show Answer Correct Answer: C) = If (student> = 60; pass; failed). 3. The ..... function can be used to find the total of numbers entered in a range of cells. A) Max. B) Sum. C) Min. D) None of the above. Show Answer Correct Answer: B) Sum. 4. Another name for the flowchart is ..... A) Algorithm. B) Flow. C) Channel. D) Tree. Show Answer Correct Answer: B) Flow. 5. What type of chart is good for single series of data? A) Column Chart. B) Line Chart. C) Pie Chart. D) Cone Chart. Show Answer Correct Answer: C) Pie Chart. 6. ..... is a way of telling the computer what you want it to do using codes A) Typing. B) Coding. C) Presentation. D) Coder. Show Answer Correct Answer: B) Coding. 7. A4 is an example of ..... A) Cell Address. B) Cell Range. C) Formula. D) Function. Show Answer Correct Answer: A) Cell Address. 8. A four-sided arrow does what in Excel? A) Copies the contents of one cell to others around it. B) Moves the contents of one cell to another location. C) Selects the cell. D) None of the above. Show Answer Correct Answer: B) Moves the contents of one cell to another location. 9. It contain one or more worksheet which are automatically named in the sheet tabs as sheet 1, sheet 2, and so on. A) Cell. B) Workbook. C) Worksheet. D) Excel. Show Answer Correct Answer: B) Workbook. 10. To add pictures to the document using the menu steps ..... A) Insert > Shape. B) Insert > Table. C) Insert > Pictures. D) Insert > Word Art. Show Answer Correct Answer: C) Insert > Pictures. 11. What is the use of Microsoft PowerPoint? A) Create Presentation. B) Store excel sheet. C) Sent E-mails. D) Create text document. Show Answer Correct Answer: A) Create Presentation. 12. A collection or group of several cells in the spreadsheet is called ..... A) Line. B) Column. C) Sel. D) Range. Show Answer Correct Answer: D) Range. 13. In a worksheet, there are ..... columns. A) 16, 384. B) 16, 385. C) 16, 390. D) 16, 382. Show Answer Correct Answer: A) 16, 384. 14. To select a group of cells, you must click each cell individually until all cells in the range are selected. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 15. When was first elctric spreadsheet invented? what was it's name? A) 1978, Compu. B) 1979, Visicalc. C) 1950, spreadsheet. D) 1978, Visicalc. Show Answer Correct Answer: D) 1978, Visicalc. 16. Which of the following is not a valid bar in MS-Excel? A) Paint Bar. B) Title Bar. C) Formula Bar. D) Bar menu. Show Answer Correct Answer: A) Paint Bar. 17. Spreadsheet type applications designed to process numbers or data are ..... A) Microsoft Excel. B) Microsoft access. C) Database. D) Corel draw. E) Microsoft word. Show Answer Correct Answer: A) Microsoft Excel. 18. In Excel, Column is denoted by ..... A) Symbols. B) Numbers. C) Formulas. D) Letters. Show Answer Correct Answer: D) Letters. 19. Office applications that are integrated with Microsoft PowerPoint and others as well, which can create presentation, infographic, A4 document, and various design templates are office applications ..... A) Canva. B) Google Slide. C) ClassPoint. D) Google Jamboard. E) PowerPoint. Show Answer Correct Answer: A) Canva. 20. In a worksheet, you ..... edit rows, columns and cells. A) Can. B) Cannot. C) All the above. D) None of the above. Show Answer Correct Answer: A) Can. 21. Columns in MS Excel ranges from ..... to ..... A) A to XFD. B) And this is. C) A to BZ. D) A to WFD. Show Answer Correct Answer: A) A to XFD. 22. The formula for calculating the overall numbers in MS.Excel is ..... A) SUM. B) MAX. C) IF. D) MIN. Show Answer Correct Answer: A) SUM. 23. MS Excel is a/an A) Spreadsheet software. B) Word processing software. C) Painting software. D) Database software. Show Answer Correct Answer: A) Spreadsheet software. 24. The most important thing that is carried out in inputting a formula in Ms.Excel is ..... A) Colon. B) Equal. C) Semicolon. D) Brackets open and cover brackets. Show Answer Correct Answer: B) Equal. 25. If you selected (A1:B5) what is this called? A) Row. B) Column. C) Cell range. D) Cell grouping. Show Answer Correct Answer: C) Cell range. ← 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