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 8 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 8 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following are physical devices of a computer? A) System Software. B) Software. C) Hardware. D) Package. Show Answer Correct Answer: C) Hardware. 2. As a secretary, we are required to be able to process words, process numbers and make a powerpoint.Inside Microsoft Office Types that can be used to process words are called ..... A) Microsoft Powerpoint. B) Microsoft Office. C) Microsoft Excel. D) Microsoft Outlook. E) Microsoft Word. Show Answer Correct Answer: E) Microsoft Word. 3. What do you call the part of MS Excel where you can see the active cell? A) Formula Bar. B) Taskbar. C) Name Box. D) Status bar. Show Answer Correct Answer: C) Name Box. 4. A cell formed at the intersection of row 8 and column E is addressed as ..... A) E8. B) 8E. C) All the above. D) None of the above. Show Answer Correct Answer: A) E8. 5. What is the name given to the intersection of a row and a column in a spreadsheet? A) Cube. B) Cell. C) Block. D) Square. Show Answer Correct Answer: B) Cell. 6. You can use this tool to combine more than one cell to make a larger cell working area A) Blend. B) Combine. C) Function. D) Merge. Show Answer Correct Answer: D) Merge. 7. Three types of data that can be entered in a worksheet are Numbers, Text & Formulae. A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: A) TRUE. 8. The shortcut key to edit a cell is A) Category. B) F5. C) Fg. D) F11. Show Answer Correct Answer: A) Category. 9. The row on the spreadsheet usually starts with? A) Number. B) Letter. C) All the above. D) None of the above. Show Answer Correct Answer: A) Number. 10. Average function is used to calculate arithmetic mean of the numbers. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 11. Where rows and columns meet are referred to as A) Boxes. B) Cells. C) All the above. D) None of the above. Show Answer Correct Answer: B) Cells. 12. An ..... allows the user to see or hear data coming out of the computer. A) Input device. B) Output device. C) All the above. D) None of the above. Show Answer Correct Answer: B) Output device. 13. The MS Excel program is included in the application ..... A) Spreadsheet. B) Assembly. C) Presentation. D) Database. E) Word processing. Show Answer Correct Answer: A) Spreadsheet. 14. Smart Art is used to add charts in a document A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 15. A spreadsheet is made up of one "workbook" and can have have many "worksheets" . A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 16. This is a combination of computing, printing, broadcasting, and electronics. A) Multimedia. B) Medium. C) Multimedia computing. D) None of the above. Show Answer Correct Answer: C) Multimedia computing. 17. Wordart is commonly used for ..... A) Make a word arrangement. B) Make variations of writing. C) Changing fonts. D) Make a picture of a picture. E) Coloring text. Show Answer Correct Answer: B) Make variations of writing. 18. The first cell in a worksheet is what? A) A1. B) 1A. C) FX. D) Cell Name. Show Answer Correct Answer: A) A1. 19. The total number of columns in a worksheet? A) 26. B) 256. C) 12, 834. D) 16, 384. Show Answer Correct Answer: D) 16, 384. 20. Based on the following formula:= 8*3 The results are ..... A) 5. B) 24. C) 2.25. D) 11. Show Answer Correct Answer: B) 24. 21. Mathematical operator sign used to start a calculation function in Excel ..... A) @. B) #. C) =. D) ?. Show Answer Correct Answer: C) =. 22. Press Ctrl + Home to go to cell A1. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 23. Which of the following is a valid function? A) = Sum1:Ashst. B) = am (A1, Ash). C) Am = (a1:Ash). D) = am (A1:Ash). Show Answer Correct Answer: D) = am (A1:Ash). 24. Spreadsheet is a ..... A) Program. B) Hardware. C) All the above. D) None of the above. Show Answer Correct Answer: A) Program. 25. How must a cell containing a formula start? A) ( ). B) SUM. C) =. D) +. Show Answer Correct Answer: C) =. 26. Spreadsheets consists of ..... and ..... A) Rows and Tables. B) Rows and Columns. C) Tables and chairs. D) Columns and tables. Show Answer Correct Answer: A) Rows and Tables. 27. Absolute cell reference uses which sign A) =. B) &. C) +. D) $. Show Answer Correct Answer: D) $. 28. Files that have been removed and available on Recycle Bin, can be called back by order ..... A) File, Open. B) Back. C) Rename. D) Restore. E) Delete. Show Answer Correct Answer: D) Restore. 29. What returns a position of a cell? A) Lookup. B) Column. C) Index. D) Match. Show Answer Correct Answer: D) Match. 30. It is Productivity Suite created by the Microsoft Corporation. A) Microsoft Office Suite. B) Microsoft office 2013. C) Productivity tools. D) None of the above. Show Answer Correct Answer: B) Microsoft office 2013. 31. The number are used in calculations A) Labels. B) Values. C) Numbers. D) None of the above. Show Answer Correct Answer: B) Values. 32. In Excel, Rows are labelled as ..... A) A, B, C, etc. B) A1, A2, etc. C) 1, 2, 3 etc. D) $ A$ 1, $ A$ 2, etc. Show Answer Correct Answer: C) 1, 2, 3 etc. 33. The following is not an office application is ..... A) Ms. Power Point. B) Ms. Excel. C) Google Docs. D) Ms. Word. E) Corel. Show Answer Correct Answer: E) Corel. 34. Individual pieces of information typed into the spreadsheet. A) Entry. B) Cell. C) Workbook. D) Spreadsheet. Show Answer Correct Answer: A) Entry. 35. Microsoft Excel is one of the number processing applications, also called ..... A) Graphic Design. B) Drawing. C) Word Processor. D) Spreadsheet. Show Answer Correct Answer: D) Spreadsheet. 36. Which option will you click from borders drop-down list to see more borders? A) More Borders. B) Thick Border. C) Thick Box Border. D) Outside Borders. Show Answer Correct Answer: A) More Borders. 37. The advantage of using a spreadsheet is: A) Calculations can be done automatically. B) Changing data automatically updates calculations. C) More flexibility. D) All of the above. Show Answer Correct Answer: D) All of the above. 38. A formula in the spreadsheet should always start with A) An equals sign. B) An asterisk. C) A plus sign. D) A capital letter. Show Answer Correct Answer: A) An equals sign. 39. Each excel formula / function should begin with ..... symbol. A) -. B) . C) *. D) =. Show Answer Correct Answer: D) =. 40. In Microsoft Excel or Spreadsheets there are 2 elements namely ..... and ..... A) Column and table. B) Row and column. C) Tables and lines. D) Everything is wrong. Show Answer Correct Answer: B) Row and column. 41. Which of the following is not an MS Excel data type? A) Money. B) Date and Time. C) Number. D) Text. Show Answer Correct Answer: A) Money. 42. In Excel, numbers automatically align to ..... ? A) The right. B) The centre. C) The Top. D) The left. Show Answer Correct Answer: A) The right. 43. What is Microsoft PowerPoint used for? A) Create and deliver presentations. B) Watch movies. C) Create documents. D) Create spreadsheets. Show Answer Correct Answer: A) Create and deliver presentations. 44. Spreadsheets are best for doing what? A) Writing reports. B) Sorting data. C) Making lists. D) None of the above. Show Answer Correct Answer: C) Making lists. 45. Absolute address is a cell address whose value does not change if the data must be copied.The correct writing of absolute cells is ..... A) $ A1 $. B) A1 $. C) $ A1. D) $ A$ 1. E) A$ $ 1. Show Answer Correct Answer: D) $ A$ 1. 46. Ravi thinks MS-Excel is a word processing software. Correct him. A) Presentation Software. B) Calculator. C) Word document. D) Spreadsheet. Show Answer Correct Answer: D) Spreadsheet. 47. Coding is categorized into ..... except A) Games design. B) Graphic design. C) Web design. D) Animation. Show Answer Correct Answer: B) Graphic design. 48. In MS-Excel you can use the drag and drop method to A) Copy cell contents. B) Move cell contents. C) Add cell contents. D) (A) and (B). Show Answer Correct Answer: D) (A) and (B). 49. Which term is used to join the selected cells in to one cell? A) Filter. B) Wrap. C) Pivot. D) Merge. Show Answer Correct Answer: D) Merge. 50. To make a line on the cell, we can use ..... A) Font. B) Border. C) Style. D) Format. E) Insert. Show Answer Correct Answer: B) Border. 51. First electronic spreadsheet was conceived by A) And Bricklin. B) Bill Gates. C) Steve Jobs. D) IBM. Show Answer Correct Answer: A) And Bricklin. 52. A grid of rows and columns in which you enter text, numbers, and the results of calculations. A) Range. B) Spreadsheet. C) Worksheet. D) Chart. Show Answer Correct Answer: B) Spreadsheet. 53. What does the WWW means? A) Wide World Web. B) World Wide Web. C) World Web Wide. D) None of the above. Show Answer Correct Answer: B) World Wide Web. 54. Which of the following Excel charts represents only one value for each variable? A) Pie. B) Bar. C) Function. D) Lines. Show Answer Correct Answer: A) Pie. 55. To find out how many persons are there in a certain field, the following function is applied A) Counta (-;-). B) Count( : ). C) Average( : ). D) Counta (-:-). Show Answer Correct Answer: D) Counta (-:-). 56. The name of a cell is made up of a column letter and row number A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: A) TRUE. 57. An Active cell is the ..... A) Previous Cell Selected. B) Next cell selected. C) Current cell selected. D) None of the above. Show Answer Correct Answer: C) Current cell selected. 58. By default, in the Ms. WorksheetExcel will display ..... A) 1 sheet. B) 4 sheet. C) 2 sheet. D) 5 sheet. E) 3 sheet. Show Answer Correct Answer: E) 3 sheet. 59. The "boxes" in Microsoft Excel are called ..... A) Griddies. B) Boxes. C) Cells. D) Spreadsheets. Show Answer Correct Answer: C) Cells. 60. You can't Copy the Formula to other cells. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. ← 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 9 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books