This quiz works best with JavaScript enabled. Home > Cbse > Class 7 > Computer Science > Ms Excel Spreadsheet > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 17 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 17 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of these is the data type available in MS Excel? A) Number. B) Text. C) Formula. D) All of these. Show Answer Correct Answer: D) All of these. 2. These applications are applications used to process words, which mainly make documents such as letters, proposals, or reports, except ..... A) MS. Word. B) Open Office Spreadsheet. C) Google Docs. D) None of the above. Show Answer Correct Answer: B) Open Office Spreadsheet. 3. A type of network where computers are connected within the same city A) PAN (personal area network). B) LAN (local area network). C) Internet. D) MAN (metropolitan area network). Show Answer Correct Answer: D) MAN (metropolitan area network). 4. Another name for Microsoft Excel is ..... A) Spreadsheet. B) Document. C) Slide. D) Google form. Show Answer Correct Answer: A) Spreadsheet. 5. Shortcut key to go directly to cell A1 A) Ctrl + End. B) Ctrl + F9. C) Ctrl + A1. D) Ctrl + Home. Show Answer Correct Answer: D) Ctrl + Home. 6. What can a spreadsheet be used for? A) To record information in an organised manner. B) To perform mathematical calculations. C) To generate graphs and pie charts. D) All of the above. Show Answer Correct Answer: D) All of the above. 7. Spreadsheet models are useful because you can recreate a real life situations. A) Yes. B) No. C) All the above. D) None of the above. Show Answer Correct Answer: A) Yes. 8. What contains both the column and the row number? A) Formula. B) Cell Address. C) Row. D) None of the above. Show Answer Correct Answer: B) Cell Address. 9. Why is the integration of office applications important? A) To reduce the use of the internet. B) To improve image quality. C) To facilitate work and efficiency. D) To save storage space. Show Answer Correct Answer: C) To facilitate work and efficiency. 10. Anybody that can write computer codes or program is also known as a ..... A) Coding. B) Programmer or Coder. C) Computer scientist. D) Typist. Show Answer Correct Answer: B) Programmer or Coder. 11. Microsoft Excel functions are as follows, except. A) Make a financial statement. B) Calculate currency exchange rate. C) Present data precisely, neatly, and accurately. D) Make a paper. E) Make a diagram. Show Answer Correct Answer: D) Make a paper. 12. This data type is used to label values or sometimes part of data. A) Numbers. B) Texts. C) Date and Time. D) Currency. Show Answer Correct Answer: B) Texts. 13. What do we need to click to create a new worksheet in our workbook? A) Active cell. B) New sheet button. C) Sheet tab. D) None of the above. Show Answer Correct Answer: B) New sheet button. 14. In Excel, Columns Are Labelled AS ..... In Excel, the columns are labeled ..... is labeled. A) A, B, C, etc. B) A1, A2, etc. C) $ A$ 1, $ A$ 2, etc. D) 1, 2, 3 etc. Show Answer Correct Answer: A) A, B, C, etc. 15. What is located at the top of the Excel window and displays the name of the workbook? A) Row. B) Toolbar. C) Bar menu. D) Title Bar. Show Answer Correct Answer: D) Title Bar. 16. Press ..... to select a row in which a cell is active. A) Shift +space bar. B) Shift. C) Shift +enter. D) None of the above. Show Answer Correct Answer: A) Shift +space bar. 17. What is the Sum formula? A) Sum( )=. B) =( )Sum. C) =Sum( ). D) Sum( ). Show Answer Correct Answer: C) =Sum( ). 18. An equation that calculates a new value from values currently in a worksheet. A) Column. B) Cell. C) Formula. D) Formula Bar. Show Answer Correct Answer: C) Formula. 19. It is a collection of data that is stored electronically as a series of records in a table. A) Spreadsheet. B) Presentation. C) MS Word. D) Database. Show Answer Correct Answer: D) Database. 20. Mathematical calculations in a spreadsheet are called: A) Formulas. B) Words. C) Values. D) Labels. Show Answer Correct Answer: A) Formulas. 21. Microsoft Excel is a ..... used to analyze data A) Software. B) Hardware. C) All the above. D) None of the above. Show Answer Correct Answer: A) Software. 22. Writing the function of finding the smallest value is ..... A) =MAX(A8:A12). B) = From (Ah:A 12). C) =COUNT(A7:A10). D) From (District:12 A). Show Answer Correct Answer: B) = From (Ah:A 12). 23. What to do to copy a nd moving worksheet? A) Click on move or copy option. B) Do magic. C) Call ironman. D) Call bill gates ( correct answer ). Show Answer Correct Answer: A) Click on move or copy option. 24. To accept a formula in a cell, press the ..... key. A) Ctrl. B) Tab. C) Enter. D) Shift. Show Answer Correct Answer: C) Enter. 25. Rows in MS Excel A) 1048576. B) 1048577. C) 1026589. D) 1048555. Show Answer Correct Answer: A) 1048576. 26. The first sign that was affixed when making a formula was ..... A) '' ". B) :. C) =. D) /. Show Answer Correct Answer: C) =. 27. 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. 28. 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. 29. Who invented the WWW? A) Tim Berners-Lee. B) Steve Jobs. C) Alan Turing. D) Mark Zuckerberg. Show Answer Correct Answer: A) Tim Berners-Lee. 30. 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. 31. The name of the working area cell. It will have a thick border around it. A) Active cell. B) Row. C) Cell. D) Column. Show Answer Correct Answer: A) Active cell. 32. 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 $ E5. D) B1 to e5. Show Answer Correct Answer: B) B1:E5. 33. What do you call an MS Excel file? A) Worksheet. B) Cell. C) .xls. D) Workbook. Show Answer Correct Answer: D) Workbook. 34. 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. 35. 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. 36. What function in MS Excel will be used to easily compute the Classification of Grades? A) Frequency. B) If. C) Sum. D) Average. Show Answer Correct Answer: A) Frequency. 37. 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. 38. Why should you use Pixlr? A) To write an esay. B) To shop on amazon. C) To Draw. D) To edit or make online photos. Show Answer Correct Answer: D) To edit or make online photos. 39. This function finds the lowest number in the range of cells. A) =AVERAGE( ). B) =SUM( ). C) =MIN( ). D) =MAX( ). Show Answer Correct Answer: C) =MIN( ). 40. The understanding of the column is ..... A) The meeting between the workbook. B) The part marked by the letter. C) Just any collection of cells. D) Parts marked by numbers. E) The meeting between the worksheet. Show Answer Correct Answer: B) The part marked by the letter. 41. Group of cells that runs from the top of the page to the bottom. In Excel, these are identified by letters. A) Worksheet. B) Column. C) Row. D) Formula Bar. Show Answer Correct Answer: B) Column. 42. Used to sort data from A-Z is A) Sort descending. B) Paint. C) Copy. D) Sort ascending. E) Paste. Show Answer Correct Answer: D) Sort ascending. 43. What is the keyboard shortcut key to lock cell references in a formula? A) Category. B) ALT. C) CTRL. D) Fg. Show Answer Correct Answer: D) Fg. 44. ..... is a collection of cells organized in rows and columns where you keep and manipulate the data. A) Workbook. B) Spreadsheet. C) ARRAY. D) Worksheet. Show Answer Correct Answer: D) Worksheet. 45. The 1t electronic spreadsheet was ..... A) VISICALC. B) Lotus 1-2-3. C) MS Excel. D) Gnumeric. Show Answer Correct Answer: A) VISICALC. 46. 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. 47. Each box on a spreadsheet is called a ..... A) Row. B) Cell. C) Box. D) Column. Show Answer Correct Answer: B) Cell. 48. 1) Joining multiple cells into a single cell A) Cross. B) Down. C) Merge. D) Split. Show Answer Correct Answer: C) Merge. 49. 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. 50. A formula and a function are the same thing A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 51. In Microsoft Excel the part used to fill in the formula or calculation is A) Tool Bar. B) Name Box. C) Tittle bar. D) Formula Bar. Show Answer Correct Answer: D) Formula Bar. 52. Cell reference ..... A) The column number and row letter for one cell. B) The column letter and column number for one cell. C) The column letter and row number for one cell. D) The column letter and row number for two cells. Show Answer Correct Answer: C) The column letter and row number for one cell. 53. When is a MS Excel Spreadsheet used? A) Making a Drawing. B) For Collecting Information. C) For Baking a Cake. D) When Reading. Show Answer Correct Answer: B) For Collecting Information. 54. The first version of Ms.Office Excel is released what year? A) 1985. B) 1992. C) 1987. D) 1990. Show Answer Correct Answer: C) 1987. 55. To edit something on a worksheet you need to select this first? A) Columns. B) Rows. C) Cell Range. D) None of the above. Show Answer Correct Answer: C) Cell Range. 56. What is a rectangular box in a MS EXCEL Spreadsheet called? A) Row. B) Column. C) Cell. D) None of the above. Show Answer Correct Answer: C) Cell. 57. Google doc is much similar to which application? A) MS-word. B) MS-outlook. C) MS-Excel. D) MS-powerpoint. Show Answer Correct Answer: A) MS-word. 58. In Excel it means Add A) Plus sign. B) Sort. C) Asterisk. D) Forward slash. Show Answer Correct Answer: A) Plus sign. 59. One of its important features is the use of formulas to make computations. A) MS Excel. B) MS Word. C) MS Powerpoint. D) None of the above. Show Answer Correct Answer: A) MS Excel. 60. Combination of an absolute and a relative cell A) Relative Reference. B) Absolute Reference. C) Mixed Reference. D) None of the above. Show Answer Correct Answer: C) Mixed Reference. ← PreviousNext →Related QuizzesComputer Science QuizzesClass 7 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 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books