This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 42 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 42 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Rows in MS Excel A) 1048577. B) 1048576. C) 1048555. D) 1026589. Show Answer Correct Answer: B) 1048576. 2. The first sign that was affixed when making a formula was ..... A) =. B) :. C) /. D) '' ". Show Answer Correct Answer: A) =. 3. Command used to reverse the previous action is ..... A) Re redo. B) Redo. C) Undo. D) None of the above. Show Answer Correct Answer: C) Undo. 4. Percentage, currency, date, and time are A) Number Formats. B) Picture Formats. C) All the above. D) None of the above. Show Answer Correct Answer: A) Number Formats. 5. Who invented the WWW? A) Alan Turing. B) Tim Berners-Lee. C) Mark Zuckerberg. D) Steve Jobs. Show Answer Correct Answer: B) Tim Berners-Lee. 6. Is it possible to insert an image from a file into an Excel spreadsheet? A) Yes. B) No. C) All the above. D) None of the above. Show Answer Correct Answer: A) Yes. 7. The name of the working area cell. It will have a thick border around it. A) Column. B) Cell. C) Active cell. D) Row. Show Answer Correct Answer: C) Active cell. 8. In Excel, which one deenoted a rang from B1 through e5 Who will select the range of B1 to E5 in Excel? A) B1-E5. B) B1:E5. C) B1 to e5. D) B1 $ E5. Show Answer Correct Answer: B) B1:E5. 9. What do you call an MS Excel file? A) Cell. B) Worksheet. C) Workbook. D) .xls. Show Answer Correct Answer: C) Workbook. 10. What is the use of annoying insert? A) Set everything related to the file (open, set, store) etc. B) Insert/insert objects in the form of;Text/writing, shape, image, and others. C) Display or print documents on the screen, adjust the mold size, and display the auxiliary lines on the worksheet. D) Check the spelling, choose the desired language, calculate many words or characters, protect documents, and so on. Show Answer Correct Answer: B) Insert/insert objects in the form of;Text/writing, shape, image, and others. 11. A computer application used to create and modify spreadsheets. A) Power Point program. B) Windows program. C) Spreadsheet program. D) Word program. Show Answer Correct Answer: C) Spreadsheet program. 12. What function in MS Excel will be used to easily compute the Classification of Grades? A) Sum. B) If. C) Average. D) Frequency. Show Answer Correct Answer: D) Frequency. 13. A group of cells which are adjacent to each other are called ..... A) Active Cell. B) Cell range. C) All the above. D) None of the above. Show Answer Correct Answer: B) Cell range. 14. Why should you use Pixlr? A) To shop on amazon. B) To write an esay. C) To Draw. D) To edit or make online photos. Show Answer Correct Answer: D) To edit or make online photos. 15. This function finds the lowest number in the range of cells. A) =SUM( ). B) =AVERAGE( ). C) =MAX( ). D) =MIN( ). Show Answer Correct Answer: D) =MIN( ). 16. The understanding of the column is ..... A) Just any collection of cells. B) Parts marked by numbers. C) The meeting between the worksheet. D) The part marked by the letter. E) The meeting between the workbook. Show Answer Correct Answer: D) The part marked by the letter. 17. Group of cells that runs from the top of the page to the bottom. In Excel, these are identified by letters. A) Row. B) Worksheet. C) Column. D) Formula Bar. Show Answer Correct Answer: C) Column. 18. Used to sort data from A-Z is A) Sort ascending. B) Sort descending. C) Copy. D) Paste. E) Paint. Show Answer Correct Answer: A) Sort ascending. 19. What is the keyboard shortcut key to lock cell references in a formula? A) CTRL. B) ALT. C) Category. D) Fg. Show Answer Correct Answer: D) Fg. 20. ..... is a collection of cells organized in rows and columns where you keep and manipulate the data. A) Workbook. B) Worksheet. C) Spreadsheet. D) ARRAY. Show Answer Correct Answer: B) Worksheet. 21. The 1t electronic spreadsheet was ..... A) VISICALC. B) MS Excel. C) Lotus 1-2-3. D) Gnumeric. Show Answer Correct Answer: A) VISICALC. 22. Borders are used for merging the cells. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 23. Each box on a spreadsheet is called a ..... A) Row. B) Column. C) Cell. D) Box. Show Answer Correct Answer: C) Cell. 24. 1) Joining multiple cells into a single cell A) Merge. B) Down. C) Cross. D) Split. Show Answer Correct Answer: A) Merge. 25. MS Excel is used to ..... and manage business transactions that deal with accounting. A) Create. B) Destroy. C) All the above. D) None of the above. Show Answer Correct Answer: A) Create. ← 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