This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 28 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 28 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. How many rows are there in MS-EXCEL? A) 10, 48, 576. B) 10, 48, 577. C) 10, 49, 576. D) 10, 48, 570. Show Answer Correct Answer: A) 10, 48, 576. 2. A cell is identified by: A) Row only. B) Column only. C) Column and row. D) None of these. Show Answer Correct Answer: C) Column and row. 3. Rio wants to create an attendance sheet for her class. The worksheet includes the names of the students, class number and dates for the school days. What data type will not be of used for the said worksheet? A) Numbers. B) Texts. C) Date and Time. D) Currency. Show Answer Correct Answer: D) Currency. 4. What does the Goal Seek tool do? A) Allows you to see how changing one data item in a formula affects the others. B) Automatically sorts or totals data. C) Highlights the major functions and outcomes of your data set. D) Allows you to add values in a selection of cells. Show Answer Correct Answer: A) Allows you to see how changing one data item in a formula affects the others. 5. In a spreadsheet, Rows move in ..... direction. A) Vertical. B) Horizontal. C) Diagonal. D) None of the above. Show Answer Correct Answer: B) Horizontal. 6. The types of data can be feed in spreadsheet are A) 3. B) 2. C) 4. D) None of the above. Show Answer Correct Answer: A) 3. 7. Coding can is also known as ..... A) Programmer. B) Coder. C) Coding. D) Programming. Show Answer Correct Answer: D) Programming. 8. To Add up entries from D6 to D10, we use the formula? A) Add D6 to D10. B) @Sum(D6 D10). C) Add D6 D10. D) @Add(D6 D10). Show Answer Correct Answer: B) @Sum(D6 D10). 9. The menu that must be chosen to widen or narrow the size of the column in the worksheet is ..... A) Insert Sheet Column. B) Insert Sheet. C) Borders. D) Row Height. E) Column Width. Show Answer Correct Answer: E) Column Width. 10. Rows are identified by ..... A) Alphabets. B) Numbers. C) Roman number. D) Mixed of number and alphabets. Show Answer Correct Answer: B) Numbers. 11. It is a collection of applications dedicated to help accomplish specific tasks. A) File explorer. B) Productivity tools. C) All apps. D) None of the above. Show Answer Correct Answer: B) Productivity tools. 12. What is basic file of MS Excel? A) Presentation. B) Spreadsheet. C) Worksheet. D) Workbook. Show Answer Correct Answer: D) Workbook. 13. An individual box which contains data. A) Cell Address. B) Cell Sheet. C) Cell. D) Cell Number. Show Answer Correct Answer: C) Cell. 14. We can use this function to count the number of cells containing words/letters A) = Counta. B) =COUNTW. C) =COUNT. D) =COUNTN. Show Answer Correct Answer: A) = Counta. 15. Every formula starts with what? A) (). B) +. C) -. D) =. Show Answer Correct Answer: D) =. 16. In Excel, what are the individual boxes on the worksheet where you enter your data? A) Name Box. B) Row. C) Cells. D) Column. Show Answer Correct Answer: C) Cells. 17. A media with an online system whose users can actively interact called ..... A) Site. B) Social media. C) Application. D) Website. Show Answer Correct Answer: B) Social media. 18. Function to find the average value of a range ..... A) AVERAGE. B) SUM. C) MAX. D) IF. Show Answer Correct Answer: A) AVERAGE. 19. ..... allows you to set a column's width to fit its content automatically. A) Auto Fill. B) Resize. C) Fill Handle. D) Auto Fit. Show Answer Correct Answer: D) Auto Fit. 20. The columns represent the ..... A) Rows. B) Numbers. C) Letters. D) Columns. Show Answer Correct Answer: C) Letters. 21. To quickly create a chart press ..... function key. A) F8. B) Fuck. C) F10. D) F11. Show Answer Correct Answer: D) F11. 22. In an excel formula, it means substract A) Add sign. B) Minus sign. C) Divide sign. D) Average Sign. Show Answer Correct Answer: B) Minus sign. 23. When creating a budget, ..... would be best the software program to use A) Docs/MS Word. B) Slides/PowerPoint. C) Sheets/Excel. D) Windows/IOS. Show Answer Correct Answer: C) Sheets/Excel. 24. What is meant by office applications? A) Application for editing photos. B) Application to play games. C) Application to facilitate office work. D) Application for watching movies. Show Answer Correct Answer: C) Application to facilitate office work. 25. Microsoft Word is a ..... A) Spreadsheet application. B) Database application. C) Word processing application. D) Presentation application. Show Answer Correct Answer: C) Word processing application. ← 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