This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 1 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 1 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which component of MS-Excel is the intersection of rows and columns? A) Cell. B) Formula bar. C) Row header. D) Column header. Show Answer Correct Answer: A) Cell. 2. The total number of rows in a worksheet is A) 16, 384. B) 12, 49, 576. C) 10, 48, 576. D) 11, 48, 576. Show Answer Correct Answer: C) 10, 48, 576. 3. The various elements of a chart are A) Data label, chart title, legend. B) Data legend, chart title, label. C) Chart legend. chart label, chart title. D) None of the above. Show Answer Correct Answer: A) Data label, chart title, legend. 4. Horizontal line of cells is A) Row. B) Column. C) All the above. D) None of the above. Show Answer Correct Answer: A) Row. 5. Application programs that function to process data in the form of numbers are called A) Ms. Word. B) Ms. Excell. C) Ms. Power Point. D) Ms. Outlook. Show Answer Correct Answer: B) Ms. Excell. 6. 1) A Row goes ..... A) Across. B) Down. C) Cross. D) None of the above. Show Answer Correct Answer: A) Across. 7. The program used for graphic design is ..... A) Windows 10. B) Winamp. C) Adobe Reader. D) Corel Draw. Show Answer Correct Answer: D) Corel Draw. 8. The currently selected cell in spreadsheet is called A) First Cell. B) Last Cell. C) Main Cell. D) Active Cell. Show Answer Correct Answer: D) Active Cell. 9. Every time you add something to an image it creates a new ..... A) Layer. B) Image. C) Color. D) Option. Show Answer Correct Answer: A) Layer. 10. Application on Ms.Office that can be used for presentations is ..... A) Ms. Power Point. B) PPT. C) Ms. Word. D) Ms. Excel. Show Answer Correct Answer: A) Ms. Power Point. 11. Besides Microsoft Excel, there are several types of spreadsheets, as follows, except ..... A) Lotus 1-3. B) Adobe sheet. C) Star Office Calc. D) Scenes. Show Answer Correct Answer: B) Adobe sheet. 12. A function inside other function is called ..... A) Nested Function. B) Round Function. C) Inner Function. D) None of the above. Show Answer Correct Answer: A) Nested Function. 13. Worksheet on Microsoft Excell is commonly called A) All wrong. B) Workspace. C) Worksheet. D) Slide Area. Show Answer Correct Answer: C) Worksheet. 14. The pointers initial position is in the ..... of the screen. A) Left. B) Right. C) Centre. D) All of the above. Show Answer Correct Answer: C) Centre. 15. What is formula in MS Excel? A) A platform to share videos such as YouTube. B) A command to delete picture in MS Paint. C) A rule that tells the computer what to do with the data:+, -, *, /, SUM, Average . D) I want to ask teacher about it. Show Answer Correct Answer: C) A rule that tells the computer what to do with the data:+, -, *, /, SUM, Average . 16. Which of these are not an example of how MS Excel can be used? A) Budget. B) Research Paper. C) Track sales. D) Track Inventory. Show Answer Correct Answer: B) Research Paper. 17. The function for the average calculation using the command ..... A) Average. B) Sum. C) Count. D) Max. Show Answer Correct Answer: A) Average. 18. Software that is distributed free of charge for certain purposes.Usually as a trial with limited features, and use with limited time (usually 15 or 30 days). A) Freeware. B) Shareware. C) Malware. D) Freeware. Show Answer Correct Answer: B) Shareware. 19. Cell value H3 = 20, H4 = 10, H5 = 20, H6 = 10 If given a formula = Average (H3; H6) will produce ..... A) 5. B) 10. C) 15. D) 20. Show Answer Correct Answer: C) 15. 20. The box which is a meeting between a column and row is called ..... A) Sheet. B) Worksheet. C) Workbook. D) Sel. E) Range. Show Answer Correct Answer: D) Sel. 21. AutoFill allows users to automatically fill a number or text series. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 22. Which part shows the content of an active cell, and it is also where we type formula for a certain operation? A) Formula bar. B) New sheet button. C) Active cell. D) None of the above. Show Answer Correct Answer: A) Formula bar. 23. The writing of the vlookup formula below is true ..... A) VLOOKUP(A3, G2:h5, 2). B) =VLOOKUP(A3, G2;h5, 2). C) =VLOOKUP(A3, G2:h5). D) = Hallabab (Act, Jum:Bachening, A). E) =VLOOKUP(A3;G2:h5;2). Show Answer Correct Answer: E) =VLOOKUP(A3;G2:h5;2). 24. Each grid or box in spreadsheet is called ..... A) Cell reference. B) Cell. C) Column. D) Row. Show Answer Correct Answer: B) Cell. 25. To alert Excel that you are entering a formula and not text, type a(n) ..... preceding the formula. A) &. B) =. C) #. D) *. Show Answer Correct Answer: B) =. Next →Related QuizzesClass 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 10Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books