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 22 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 22 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What are the keyboard shortcut keys to edit formula in a cell? A) CTRL + 1. B) CTRL + 1. C) Category. D) Fg. Show Answer Correct Answer: C) Category. 2. What is the another name for cell address A) Cell box. B) Cell Number. C) Cell Name. D) Cell Reference. Show Answer Correct Answer: D) Cell Reference. 3. What is the column header name for 27th Column A) AB. B) AA. C) Z. D) BA. Show Answer Correct Answer: B) AA. 4. Widely used to create or edit a typed document. A) Spreadsheet software. B) Word and data processing software. C) Presentation software. D) None of the above. Show Answer Correct Answer: B) Word and data processing software. 5. Menubar used in the process of the importance of Mail Merge is ..... A) Home. B) Mailings. C) Usen An Existing List. D) Select Recipients. Show Answer Correct Answer: B) Mailings. 6. In the Microsoft Excel display, the bar that shows the name of the file and application program that is being active is ..... A) Formula bar. B) Men's menu. C) Tool bar. D) Title bar. Show Answer Correct Answer: D) Title bar. 7. Geogebra used for ..... subject. A) Language. B) Science. C) Geography. D) Math. Show Answer Correct Answer: D) Math. 8. Samantha needs to total the values in cells A1 to A10. Which should she enter to find the answer? A) =TOTAL(A1:A10). B) =TOTAL(A1+A10). C) =SUM(A1:A10). D) SUM(A1+A10). Show Answer Correct Answer: C) =SUM(A1:A10). 9. The section of excel that has horizontal rows are identified by A) Numbers. B) Letters. C) None. D) None of the above. Show Answer Correct Answer: A) Numbers. 10. Formulas can be copied to adjacent cells with the ..... A) Fill handle. B) PgDn Key. C) Function key F4. D) None of the above. Show Answer Correct Answer: A) Fill handle. 11. The function of the exit file is ..... A) Delete programs. B) End the program. C) Mainformat program. D) Run the program. E) Open the program. Show Answer Correct Answer: B) End the program. 12. A software commonly used by accountants and other people involved in businesses. A) MS Calculator. B) MS Business. C) MS Excel. D) MS Accounting. Show Answer Correct Answer: C) MS Excel. 13. Explain the usefulness of the Ify formula in Excel! A) The IF formula is used to produce a true/false value of certain criteria. B) The IF formula is used to produce a true/false value of a particular range. C) The IF formula is used to produce a true/false value of a particular logic test. D) None of the above. Show Answer Correct Answer: C) The IF formula is used to produce a true/false value of a particular logic test. 14. The one which has embedded spreadsheet A) Twitter. B) You tube. C) Google. D) None of the above. Show Answer Correct Answer: C) Google. 15. Which one of the following alignment option is not available in excel? A) Right. B) Justify. C) Left. D) Middle. Show Answer Correct Answer: B) Justify. 16. If B3:J8 is given, what is it referring to? A) Range of cells B3 through J8. B) Only cell J8. C) Only cells B3 and J8. D) Only cell B3. Show Answer Correct Answer: A) Range of cells B3 through J8. 17. The "Undo" icon works ..... A) Cancel the workmanship. B) Print documents. C) Save documents. D) Open files. E) Cutting part of the document. Show Answer Correct Answer: A) Cancel the workmanship. 18. There are number 3, 6, 7 then for the sum function is A) 5. B) 4. C) 10. D) 16. E) 6. Show Answer Correct Answer: D) 16. 19. What is the formula for =sum(B2:B9) A) Ba+Baa+B 4+ Square+Duck+Bald+Blind. B) = B 1+Ba+Baa+B 4. C) = Ba++B+B 4+ Square+Duck++Bulle. D) B 1+Ba+Baa+B 4. Show Answer Correct Answer: C) = Ba++B+B 4+ Square+Duck++Bulle. 20. Located on the left side or the entry bar, displays the active cell reference: A) Entry bar. B) Cell reference. C) Name box. D) None of the above. Show Answer Correct Answer: C) Name box. 21. Which of the following is an example of an addition formula? A) Fz*. B) 2+3+6=11. C) = Bc+ns. D) = Bass/duck. Show Answer Correct Answer: C) = Bc+ns. 22. Which of the following is a selected cell? A) Current command. B) Default option. C) Active cell. D) Default cell. Show Answer Correct Answer: C) Active cell. 23. 22-Each Cell has two names (e.g. B3 or 3B) A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: B) FALSE. 24. The ..... feature of ms excel quickly completes a series of data. A) Auto Fill. B) Auto Complete. C) Auto Sum. D) Car filter. Show Answer Correct Answer: A) Auto Fill. 25. Space between vertical grid lines. A) Cell. B) Row. C) Column. D) Range. Show Answer Correct Answer: C) Column. 26. SHORT CUT FOR CUT A) CTRL+D. B) CTRL+V. C) CTRL+C. D) CTRL+X. Show Answer Correct Answer: D) CTRL+X. 27. Applications that is only accessed over the internet are called? A) Online app. B) Virtual application. C) Web application. D) All of the above. Show Answer Correct Answer: C) Web application. 28. By default, how many worksheet Availble when You create a New Excel Sheet A) 4. B) 1. C) 3. D) 2. Show Answer Correct Answer: C) 3. 29. A formula begins with an EQUAL SIGN. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 30. What function will produce results that indicate whether a student has passed or failed a course by enter the text "Pass" or "Fail" ? A) Counta. B) IF. C) SUM. D) Count. Show Answer Correct Answer: B) IF. 31. An individual box within a worksheet is known as? A) Cell. B) Referencing. C) Range. D) Square. Show Answer Correct Answer: A) Cell. 32. SUM, AVERAGE, MAX and VLOOKUP are examples of what? A) Formulae. B) Functions. C) Statistical tools. D) Tables. Show Answer Correct Answer: B) Functions. 33. How to integrate applications is as follows except ..... A) Messaging. B) Coneccting Database. C) Sharing Database. D) File Transfer. Show Answer Correct Answer: B) Coneccting Database. 34. The entry bar is also known as (AKA): A) Name box. B) Formula bar. C) Status bar. D) None of the above. Show Answer Correct Answer: B) Formula bar. 35. Merger ..... documents become ..... documents A) Two, two. B) Two, one. C) One two. D) One, one. Show Answer Correct Answer: B) Two, one. 36. Which part of Excel contains the commands for performing tasks? A) Row. B) Toolbar. C) Bar menu. D) Title Bar. Show Answer Correct Answer: C) Bar menu. 37. ..... Is a collection of cells in a worksheet in which we enter data A) Cell address. B) Sheet tab. C) Worksheet. D) Workbook. Show Answer Correct Answer: C) Worksheet. 38. In MS-Excel value used in a formula that does not change is called a A) Cell address. B) Constant. C) Function. D) None of these. Show Answer Correct Answer: B) Constant. 39. What do you call the intersection of column and row in Ms-Excel or other spreadsheet software? A) Cell. B) Coordination. C) Joint point. D) Intersection. Show Answer Correct Answer: A) Cell. 40. The location of a cell on a spreadsheet. It is a column letter followed by a row number. A) Cell range. B) Active cell. C) Cell reference. D) Row. Show Answer Correct Answer: C) Cell reference. 41. Individual box where a row and column intersect. A) Column. B) Active cell. C) Worksheet. D) Cell. Show Answer Correct Answer: D) Cell. 42. The menu only found on ms.word is A) Mailing. B) Animation. C) Data. D) Formula. Show Answer Correct Answer: A) Mailing. 43. In PowerPoint, under which tab can you change the slide background? A) Insert. B) Format. C) File. D) Design. Show Answer Correct Answer: D) Design. 44. To calculate the average in a range we use a formula ..... A) =max(). B) =average(). C) =sum(). D) =count(). E) =round(). Show Answer Correct Answer: B) =average(). 45. What is it called when one slide changes to the other? A) Animation. B) Transition. C) Style Effect. D) Switcharoo. Show Answer Correct Answer: B) Transition. 46. Each cell can hold a label or a value. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 47. A computer application that displays and organizes data is called ..... A) Electronic Spreadsheet. B) Word. C) Publisher. D) PowerPoint Presentation. Show Answer Correct Answer: A) Electronic Spreadsheet. 48. The box on the MS.EXCEL worksheet that is lined up with alphabet letters is called A) Column. B) Row. C) Sel. D) Line. Show Answer Correct Answer: A) Column. 49. A computer program that imitates a paper worksheet A) Cell. B) Video Game. C) Typing. D) Spreadsheets. Show Answer Correct Answer: D) Spreadsheets. 50. What is the keyboard shortcut to copy selected cells in Excel? A) Ctrl + C. B) Ctrl + X. C) Ctrl + Z. D) Ctrl + V. Show Answer Correct Answer: A) Ctrl + C. 51. In which tab wrap text feature is present in MS Excel 2007? A) Formulas. B) View. C) Home. D) Insert. Show Answer Correct Answer: C) Home. 52. MS Excel can accommodate up to how many columns? A) 16, 384. B) 15, 384. C) 16, 834. D) 13, 684. Show Answer Correct Answer: A) 16, 384. 53. Which function displays row data in a column or column data in a row? A) Hyperlink. B) Transpose. C) Rows. D) Index. Show Answer Correct Answer: B) Transpose. 54. What is the shortcut key for Save As in Excel? A) ALT + S. B) F12 (Function key). C) Ctrl + A. D) Ctrl + S. Show Answer Correct Answer: B) F12 (Function key). 55. Google, Bing and Yahoo are commonly known as? A) Search Engines. B) Web Browsers. C) Search Engineering. D) Hardware. Show Answer Correct Answer: A) Search Engines. 56. What tab in the ribbon do I click on to create a chart for my data? A) Page Layout. B) Formulas. C) Home. D) Insert. Show Answer Correct Answer: D) Insert. 57. To select all the cells in a worksheet, press ..... A) Ctrl + Z. B) Ctrl + B. C) Ctrl + Z. D) Ctrl + A. Show Answer Correct Answer: D) Ctrl + A. 58. What function will calculate the AVERAGE of all the numbers in a column? A) = If (a1:a6). B) =AVERAGE(E1:E5). C) =CONCAT(E1:E5). D) =SUM(E1:E5). Show Answer Correct Answer: B) =AVERAGE(E1:E5). 59. To use the Merge and Center feature, we can ..... A) Select the cells to merge. B) Click the Home tab. C) Click the merge and center option. D) None of the above. Show Answer Correct Answer: C) Click the merge and center option. 60. The cell in which you are working, outlined in a darker color than the rest of the cells A) Active Cell. B) Next Cell. C) Last Cell. D) Inactive Cell. Show Answer Correct Answer: A) Active Cell. ← 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