This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 37 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 37 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What function will add up all the numbers in a column? A) = If (a1:a6). B) =SUM(E1:E5). C) =AVERAGE(E1:E5). D) =CONCAT(E1:E5). Show Answer Correct Answer: B) =SUM(E1:E5). 2. The data for a chart should be inserted in a cell in spreadsheet. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 3. All of the following are the uses of MS Excel, EXCEPT: A) Used for Calculations. B) Managing inventory. C) Presenting videos and audio. D) Collecting data from different sources. Show Answer Correct Answer: C) Presenting videos and audio. 4. What is the cell in the worksheet in which you can type data? A) Main Cell. B) Open Cell. C) Active Cell. D) Absolute Cell. Show Answer Correct Answer: C) Active Cell. 5. The worksheet in Excel is also called ..... A) Range. B) Cell. C) Worksheet. D) Area slide. Show Answer Correct Answer: C) Worksheet. 6. In Excel, what is a horizontal group of cells identified by numbers? A) Row. B) Column. C) Cells. D) Name Box. Show Answer Correct Answer: A) Row. 7. ..... command is used to draw lines in different directions. A) Screen. B) Draw. C) Colour. D) Circle. Show Answer Correct Answer: B) Draw. 8. In MS Excel spreadsheet, Data can be sorted using ..... A) Filter function. B) ARRAY function. C) Lookup function. D) Operator function. Show Answer Correct Answer: A) Filter function. 9. Which of the following is not a web browser A) Google Chrome. B) Edge. C) Yahoo. D) Firefox. Show Answer Correct Answer: C) Yahoo. 10. Which of the following features cannot be found in the Data ribbon? A) What-If Analysis. B) Pivot Table. C) Data Validation. D) Text to Columns. Show Answer Correct Answer: B) Pivot Table. 11. What does the VLOOKUP function do? A) Looks up text that contain V. B) Checks whether text is the same in one cell as in the next. C) Finds related records. D) All of above. Show Answer Correct Answer: C) Finds related records. 12. What is an example of a RANGE in MS Excel. A) Swollen. B) Trap:Ba. C) Ba:Fear. D) (Ba:A trap). Show Answer Correct Answer: D) (Ba:A trap). 13. In Excel, all formulae must begin with ..... sign. A) #. B) $. C) =. D) &. Show Answer Correct Answer: C) =. 14. Where to write a formula is called ..... A) Title Bar. B) Bar menu. C) Tool bar. D) Formula bar. E) Tab Ribbon. Show Answer Correct Answer: D) Formula bar. 15. Mircrosoft Excel can be used for working with ..... A) Tables. B) Chart. C) Both Charts & Tables. D) None of the above. Show Answer Correct Answer: C) Both Charts & Tables. 16. Which of the following is spreadsheet software? A) MS Word. B) MS Excel. C) MS Paint. D) Notepad. Show Answer Correct Answer: B) MS Excel. 17. Which of the following is an absolute cell reference? A) !A!1. B) $ A$ 1. C) #a#1. D) A1. Show Answer Correct Answer: B) $ A$ 1. 18. Title line in Ms.Excel is also called A) Bar menu. B) Tittle bar. C) Toolbar. D) All answers are wrong. Show Answer Correct Answer: B) Tittle bar. 19. You can check the conditions against ..... when applying conditional formatting A) Cell value. B) Formula. C) Both of above. D) None of above. Show Answer Correct Answer: A) Cell value. 20. By default, the number is ..... aligned in a cell. A) Left. B) Center. C) Right. D) None of the above. Show Answer Correct Answer: C) Right. 21. There are three types of data found in a spreadsheet. A) Data, words, numbers. B) Equations, data, numbers. C) Words, numbers, labels. D) Numbers formulas, labels. Show Answer Correct Answer: D) Numbers formulas, labels. 22. The columns in MS Excel are being labelled as: A) Roman numerals. B) Numbers. C) English Alphabet. D) Symbols. Show Answer Correct Answer: C) English Alphabet. 23. It is part of a spreadsheet software. It has boxes called cells. These cells are arranged in rows and columns. A) Spreadsheets. B) Workbooks. C) Worksheets. D) None of the above. Show Answer Correct Answer: C) Worksheets. 24. MS Excel is a component of ..... A) Adobe Suit software. B) Movie Maker Software. C) MS Office package. D) None of the above. Show Answer Correct Answer: C) MS Office package. 25. Answer =2+3*3-2 A) 9. B) 10. C) 11. D) 12. Show Answer Correct Answer: A) 9. ← 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