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 12 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 12 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. To Add up entries from D6 to D10, we use the formula? A) Add D6 to D10. B) Add D6 D10. C) @Add(D6 D10). D) @Sum(D6 D10). Show Answer Correct Answer: D) @Sum(D6 D10). 2. The menu that must be chosen to widen or narrow the size of the column in the worksheet is ..... A) Insert Sheet Column. B) Column Width. C) Insert Sheet. D) Row Height. E) Borders. Show Answer Correct Answer: B) Column Width. 3. Rows are identified by ..... A) Alphabets. B) Numbers. C) Roman number. D) Mixed of number and alphabets. Show Answer Correct Answer: B) Numbers. 4. 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. 5. What is basic file of MS Excel? A) Presentation. B) Spreadsheet. C) Worksheet. D) Workbook. Show Answer Correct Answer: D) Workbook. 6. An individual box which contains data. A) Cell Number. B) Cell Address. C) Cell. D) Cell Sheet. Show Answer Correct Answer: C) Cell. 7. We can use this function to count the number of cells containing words/letters A) = Counta. B) =COUNTN. C) =COUNTW. D) =COUNT. Show Answer Correct Answer: A) = Counta. 8. Every formula starts with what? A) +. B) -. C) =. D) (). Show Answer Correct Answer: C) =. 9. In Excel, what are the individual boxes on the worksheet where you enter your data? A) Column. B) Name Box. C) Cells. D) Row. Show Answer Correct Answer: C) Cells. 10. A media with an online system whose users can actively interact called ..... A) Social media. B) Application. C) Site. D) Website. Show Answer Correct Answer: A) Social media. 11. Function to find the average value of a range ..... A) IF. B) SUM. C) AVERAGE. D) MAX. Show Answer Correct Answer: C) AVERAGE. 12. ..... 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. 13. The columns represent the ..... A) Letters. B) Columns. C) Numbers. D) Rows. Show Answer Correct Answer: A) Letters. 14. To quickly create a chart press ..... function key. A) Fuck. B) F10. C) F11. D) F8. Show Answer Correct Answer: C) F11. 15. In an excel formula, it means substract A) Average Sign. B) Minus sign. C) Divide sign. D) Add sign. Show Answer Correct Answer: B) Minus sign. 16. When creating a budget, ..... would be best the software program to use A) Windows/IOS. B) Slides/PowerPoint. C) Sheets/Excel. D) Docs/MS Word. Show Answer Correct Answer: C) Sheets/Excel. 17. What is meant by office applications? A) Application to facilitate office work. B) Application for editing photos. C) Application to play games. D) Application for watching movies. Show Answer Correct Answer: A) Application to facilitate office work. 18. Microsoft Word is a ..... A) Presentation application. B) Word processing application. C) Database application. D) Spreadsheet application. Show Answer Correct Answer: B) Word processing application. 19. What symbol is included in the formula in order for it to be computed? A) Asterisk symbol. B) Minus symbol. C) Equal symbol. D) Plus symbol. Show Answer Correct Answer: C) Equal symbol. 20. ..... software helps us in maintaining a document in a presentable manner. A) Word Pad. B) Word Processing Software. C) MS Excel. D) Notepad. Show Answer Correct Answer: B) Word Processing Software. 21. ..... are horizontal A) Rows. B) Columns. C) All the above. D) None of the above. Show Answer Correct Answer: A) Rows. 22. Which one of the following is NOT a web browser? A) Safari. B) Facebook. C) Firefox. D) Chrome. Show Answer Correct Answer: B) Facebook. 23. The electronic spreadsheet made of cells and organized by rows and columns is Known as the ..... A) Worksheet. B) Presentation. C) Document. D) Publication. Show Answer Correct Answer: A) Worksheet. 24. The name of a cell is given by the ..... A) Letter only. B) Letter + Number. C) Number + Letter. D) Number only. Show Answer Correct Answer: B) Letter + Number. 25. Lina needs to make a reference to 5th row and 8 column. What should be the cell address? A) E8. B) H5. C) D6. D) None of these correct. Show Answer Correct Answer: B) H5. 26. The ..... is used to enter Predefined data. A) Autofill feature. B) Range of cells. C) Predefined feature. D) None of the above. Show Answer Correct Answer: A) Autofill feature. 27. In a spreadsheet program, which function allows your to add numbers? A) Addition. B) Sum. C) Average. D) Add. Show Answer Correct Answer: B) Sum. 28. Mail Merge function is useful for the manufacturing process ..... A) Invitation. B) Koran. C) Personal letter. D) Magazine. Show Answer Correct Answer: A) Invitation. 29. The intersection of a row and a column is called this. A) Chart. B) Column. C) Active Cell. D) Row. Show Answer Correct Answer: C) Active Cell. 30. Max in Ms.Excel formula for ..... A) Calculate the minimum number of numbers. B) Calculating human rewards. C) Calculate the maximum number of numbers. D) Calculate the average number. Show Answer Correct Answer: C) Calculate the maximum number of numbers. 31. Numbers down the left side of the spreadsheet. A) Status Bar. B) Row Labels. C) Column Labels. D) Formula Bar. Show Answer Correct Answer: B) Row Labels. 32. What is the name of the spreadsheet software developed by Microsoft? A) Word. B) PowerPoint. C) Access. D) Excel. Show Answer Correct Answer: D) Excel. 33. The tool for typing letters on a computer is ..... A) Screen monitor. B) Keyboard. C) Mouse. D) Speaker. Show Answer Correct Answer: B) Keyboard. 34. Cell is the intersection of ..... A) Row and column. B) Rows. C) Columns. D) None of the above. Show Answer Correct Answer: A) Row and column. 35. What does the CONCATENATE function do in Excel? A) Calculates the average of a range of cells. B) Counts the number of cells that meet a specific condition. C) Concatenates two or more text strings together. D) Adds up a range of cells. Show Answer Correct Answer: C) Concatenates two or more text strings together. 36. The Name box on to the left of formula bar A) Shows the name of workbook currently working on. B) Shows the name of worksheet currently working on. C) Shows the name of cell or range currently working on. D) None of above. Show Answer Correct Answer: C) Shows the name of cell or range currently working on. 37. If some of the content is being cut off by the printer, you can use scaling to fit your workbook to the page automatically. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 38. Pressing the ..... key opens the Save As dialog box. A) FZ. B) F12. C) F10. D) F7. Show Answer Correct Answer: B) F12. 39. Function to find the average in Excel? A) Average. B) Count. C) Rate. D) Median. Show Answer Correct Answer: A) Average. 40. To edit the contents of cell data as needed, the correct step is ..... A) Press F2-Edit Cell-Select Cell to change-Ok. B) Press F2-Select Cell to be changed-Edit Cell-Ok. C) Press F2-OK-Select Cell to Change-Edit Cell. D) Select Cell to be changed-Edit Cell-Press F2-Ok. E) Select Cell to change-Press F2-Edit Cell-Ok. Show Answer Correct Answer: E) Select Cell to change-Press F2-Edit Cell-Ok. 41. A column is vertical. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 42. The panel on the top of the excel window, just below the title bar, is known as ..... A) Ribbon. B) Cell address. C) The panel on the top of the excel window, just below the title bar, is known as my window. D) None of the above. Show Answer Correct Answer: A) Ribbon. 43. Currently selected cell, which is indicated by an outline around the cell. A) Text. B) Active cell. C) Column. D) Cell. Show Answer Correct Answer: B) Active cell. 44. A ..... is a collection of different worksheets. A) Workbook. B) Textbook. C) All the above. D) None of the above. Show Answer Correct Answer: A) Workbook. 45. The button to edit cells is ..... A) F. B) Category. C) F5. D) F1. E) Fg. Show Answer Correct Answer: B) Category. 46. Click and drag the ..... tool to apply the same formula to neighboring cells. A) Auto-fill. B) Alignment. C) Fill. D) Functions. Show Answer Correct Answer: A) Auto-fill. 47. The cell address is the combination of what two things? A) Column number and row number. B) Column letter and row number. C) Column number and row letter. D) None of the above. Show Answer Correct Answer: B) Column letter and row number. 48. It is an example of a spreadsheet program. A) MS Word. B) MS Excel. C) MS Powerpoint. D) None of the above. Show Answer Correct Answer: B) MS Excel. 49. What does this symbol do:/ A) Divide. B) Add. C) Multiply. D) Minus. Show Answer Correct Answer: A) Divide. 50. Intersection of rows and columns are called A) Cell. B) Workbook. C) Excel. D) Worksheet. Show Answer Correct Answer: A) Cell. 51. To enter, repair and also display data or formulas in active cells is a function of A) Tool Bar. B) Cell instructions. C) Title Bar. D) Formula Bar. Show Answer Correct Answer: D) Formula Bar. 52. Spreadsheets have meaning ..... A) Sheet of paper. B) Book pages. C) Word processing. D) Ledger. Show Answer Correct Answer: D) Ledger. 53. Where is the zoom function located in Excel? A) Quick Access Bar. B) Title Bar. C) Formula Bar. D) Status Bar. Show Answer Correct Answer: D) Status Bar. 54. Excel is a program that is used to prepare a A) Slide presentation. B) Database. C) Text document. D) Spreadsheet. Show Answer Correct Answer: D) Spreadsheet. 55. While entering a formula in cell we should start with ..... A) -. B) +. C) =. D) *. Show Answer Correct Answer: C) =. 56. To start the formula in operating the number processing package is ..... A) =. B) -. C) *. D) +. E) /. Show Answer Correct Answer: A) =. 57. What is the term used for cells which appear going across the spreadsheet? A) Row. B) Column. C) Record. D) Field. Show Answer Correct Answer: A) Row. 58. In MS-Excel numeric value can be treated as a label value if it precedes with A) Apostrophe ('). B) Exclamation (!). C) Hash (#). D) None of these. Show Answer Correct Answer: A) Apostrophe ('). 59. In a spreadsheet, a column is denoted by ..... A) Symbols. B) Numbers. C) Letters. D) None of the above. Show Answer Correct Answer: C) Letters. 60. The ..... feature is used to extract data from a spreadsheetthat meets specific criteria quickly. A) Filter. B) Sort. C) All the above. D) None of the above. Show Answer Correct Answer: A) Filter. ← 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