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 19 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 19 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Pay attention to the types of shortcuts on the following keyboard:1) Ctrl+C2) Ctrl+P3) Ctrl+V4) Ctrl+XShortcut Keyboard for Paste and Copy commands as a result is ..... A) 1 and 2. B) 2 and 1. C) 1 and 3. D) 3 and 1. E) 2 and 4. Show Answer Correct Answer: D) 3 and 1. 2. Short key to print italics in excel is ..... A) CTRL + B. B) CTRL + I. C) CTRL + A. D) CTRL + C. E) CTRL + U. Show Answer Correct Answer: B) CTRL + I. 3. Formulas must also always begin with a question mark A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 4. Division in Excel using the symbol ":" A) Correct. B) Salah. C) All the above. D) None of the above. Show Answer Correct Answer: B) Salah. 5. A ..... can be used to complete more complex processes such as calculating average, finding the sum of multiple cells ..... A) Formula. B) Rule. C) Math. D) Function. Show Answer Correct Answer: D) Function. 6. In the Microsoft Office program group, the program used for presentations is ..... A) MS. Paint. B) MS. Power Point. C) MS. Excel. D) MS. Word. Show Answer Correct Answer: B) MS. Power Point. 7. Space between horizontal grid lines. A) Active cell. B) Column. C) Cell. D) Row. Show Answer Correct Answer: D) Row. 8. Function that helps us to locate specific values in specific cells A) Look and reference function. B) Information function. C) Database function. D) None of the above. Show Answer Correct Answer: A) Look and reference function. 9. The function of MS Excel is ..... A) Processing words. B) Processing sound. C) Processing numbers. D) Processing images. Show Answer Correct Answer: C) Processing numbers. 10. ..... is a collection of worksheets. A) Workbook. B) Homework. C) All the above. D) None of the above. Show Answer Correct Answer: A) Workbook. 11. In a spreadsheet, Rows are denoted by Letters? A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 12. Among the following clear options, which of the option is used to clear only formatting applied for the selected cells? A) Clear Formats. B) Clear All. C) Clear Contents. D) Clear Comments. E) Clear Hyperlinks. Show Answer Correct Answer: A) Clear Formats. 13. In Spreadsheet, whenever there is a change in data or formula, automatically calculations are A) Re active. B) Re done. C) Re conciliate. D) None of the above. Show Answer Correct Answer: B) Re done. 14. ..... is useful in both website and games to create motion and sound effects. A) Graphics design. B) Animation. C) Story writing. D) Website. Show Answer Correct Answer: B) Animation. 15. Bit is equal to how many byte A) 128byte. B) 1byte. C) 32byte. D) 64byte. Show Answer Correct Answer: A) 128byte. 16. After we finish typing an invitation to the word, then we enter the chain letter setting into the menu tab ..... A) Design. B) View. C) Insert. D) Home. E) Mailings. Show Answer Correct Answer: E) Mailings. 17. Jill wants to search her spreadsheet for a vaule in the first column of her tabel. What function should she use? A) SEARCH. B) Hlookup. C) VLOOKUP. D) LOOKUP. Show Answer Correct Answer: C) VLOOKUP. 18. A fact or event that is still raw and has no meaning for the recipient is called ..... A) Data. B) Information. C) Option. D) Information. Show Answer Correct Answer: A) Data. 19. In Excel, Columns move in ..... direction A) Horizontal. B) Vertical. C) Diagonal. D) None of the above. Show Answer Correct Answer: B) Vertical. 20. Which of the following menu bars is not an option in MS Word A) Insert. B) Page Layout. C) Home page. D) Internet. Show Answer Correct Answer: D) Internet. 21. The function of the enter button is ..... A) Move to Cell A1. B) Move one cell to the top. C) Move one cell down. D) Move one cell to the left. E) Move to column A. Show Answer Correct Answer: C) Move one cell down. 22. Referencing in =$ B3+B$ 4 formula is A) Absolute. B) Mixed. C) Relative. D) Proper. Show Answer Correct Answer: B) Mixed. 23. For writing formulas in Ms.Excel starts with a sign ..... A) +. B) *. C) #. D) =. Show Answer Correct Answer: D) =. 24. To apply formatting on cells, select the option "Cells" from ..... menu A) Edit. B) Format. C) Home. D) Allignment. Show Answer Correct Answer: B) Format. 25. The box on the MS.Excel worksheet that is lined up is marked by a number called ..... A) Grid. B) Sheet. C) Sel. D) Line. Show Answer Correct Answer: D) Line. 26. Copy files, texts, or objects using ..... A) Cut. B) Find. C) Copy. D) Paste. Show Answer Correct Answer: C) Copy. 27. Which option allows you to apply a format to a cell or a range of cells based on certain criteria? A) Percent Style. B) Number Formats. C) Cell Formats. D) Conditional Formatting. Show Answer Correct Answer: D) Conditional Formatting. 28. The bar that displays the data being entered in the active cell: A) Status bar. B) Entry bar. C) Windows Task Bar. D) None of the above. Show Answer Correct Answer: B) Entry bar. 29. The active cell group is mentioned A) Cell address. B) Cell line. C) Kolom Cell. D) Range Cell. Show Answer Correct Answer: D) Range Cell. 30. The ..... function is used to determine how many pupils were able to get a passing score in a test. A) COUNT. B) Counta. C) Countif. D) COUNTBLANK. Show Answer Correct Answer: C) Countif. 31. To enter the delivery destination, for example name and address entrance to the sub menu ..... A) Edit recipient. B) Start mail merge. C) Insert merge field. D) Preview results. E) Finish and merge. Show Answer Correct Answer: C) Insert merge field. 32. The name of the cell is determined by the name of the row and the column intersecting, such as A8. A) Formula. B) Cell Grid. C) Cell Address. D) Formula Bar. Show Answer Correct Answer: C) Cell Address. 33. Below that is not included in the statistical function is ..... A) Max(). B) =min(). C) =count(). D) =sum(). E) =if(). Show Answer Correct Answer: E) =if(). 34. A ..... IS A MEETING POINT OF A ..... AND A ..... A) CELL-ROW-FILE. B) CELL-WORKSHEET-WORKBOOK. C) CELL-COLUMN-ROW. D) CELL-TAB-GROUP. Show Answer Correct Answer: C) CELL-COLUMN-ROW. 35. Click ..... group in DESIGN tab to move a chart to a new worksheet. A) Data. B) Type. C) Layouts. D) Location. Show Answer Correct Answer: D) Location. 36. The number processing application issued by IBM is ..... A) Ms Excel. B) Xxl. C) Gnumeric. D) Lotus 123. Show Answer Correct Answer: D) Lotus 123. 37. What part of Microsoft Excel Window is a text field where you can enter words and phrases about what you want to do next and quickly get to features you want to use or actions you want to perform? A) Tell Me. B) File Tab. C) Formula Bar. D) Quick Access Toolbar. Show Answer Correct Answer: A) Tell Me. 38. What is the column header name for 28th Column A) AA. B) BA. C) Z. D) AB. Show Answer Correct Answer: D) AB. 39. Numbers on the side, run horizontally A) Column. B) Row. C) Cell. D) None of the above. Show Answer Correct Answer: B) Row. 40. Features to create a table of contents on Ms.Word is called ..... A) Table Of Content. B) Recording. C) Mailings. D) Merge Cell. E) Mail Merge. Show Answer Correct Answer: A) Table Of Content. 41. In the intercourse, can we find clipart tools? A) Design. B) File. C) Page Layout. D) Insert. Show Answer Correct Answer: D) Insert. 42. What do you mean by the term workbook, in MS Excel? A) It is a collection of excel files. B) Collection of cells. C) Collection of rows and columns. D) Collection of worksheets. Show Answer Correct Answer: D) Collection of worksheets. 43. The letters in Excel represent the ..... A) Columns. B) Cells. C) Data. D) Rows. Show Answer Correct Answer: A) Columns. 44. Spreadsheet rows are easily identified by: A) Numbers. B) Letters. C) Colors. D) Roman numerals. Show Answer Correct Answer: A) Numbers. 45. The last column name in a worksheet is A) FXD. B) Dfx. C) FXD. D) XFD. Show Answer Correct Answer: D) XFD. 46. Google Drive Function? A) Save documents online. B) Creating Excel Documents. C) Saving offline documents. D) Print documents. Show Answer Correct Answer: A) Save documents online. 47. When Cell A5 is worth 60 and B5 worth 5, then the formula that produces TRUE is ..... A) = At (brother <> Zz B) =NOT(A5=B5). C) = At (brother <75; Brother = Squirt). D) = R (brother Show Answer Correct Answer: A) = At (brother <> Zz 48. Vertical axis of a chart is ..... A) Y axis. B) X axis. C) B axis. D) X axis. Show Answer Correct Answer: A) Y axis. 49. All formulas in Excel begin with the following symbol A) %. B) =. C) #. D) +. Show Answer Correct Answer: B) =. 50. The following, which is not included in the spreadsheet software is A) Spreadsheet. B) Lotus. C) Microsoft Excel. D) Wordpad. Show Answer Correct Answer: D) Wordpad. 51. Which of the following is an example of a multiplication formula? A) =C10-B9. B) = Ba*. C) A-B. D) 14 x 10 = 140. Show Answer Correct Answer: B) = Ba*. 52. Which tool you will use to join some cells and place the content at the middle of joined cell? A) From Format Cells dialog box click on Merge Cells check box. B) From Format Cells dialog box select the Centered alignment. C) From Format Cells dialog box choose Merge and Center check box. D) Click on Merge and Center tool on formatting toolbar. Show Answer Correct Answer: D) Click on Merge and Center tool on formatting toolbar. 53. Which office component is used to create text document? A) MS OneNote. B) MS Excel. C) MS Access. D) MS Word. Show Answer Correct Answer: D) MS Word. 54. Steps to use Microsoft Excel ..... A) Start-micrososft word-program. B) Start-program-close. C) Start-program-accessories-microsoft excel. D) Start-program-micrososft office-micrososft excel. E) Start-program-paint. Show Answer Correct Answer: D) Start-program-micrososft office-micrososft excel. 55. Letters in Excel represent A) Data. B) Columns. C) Functions. D) Rows. Show Answer Correct Answer: B) Columns. 56. What type of chart is useful for comparing parts of a whole? A) Pie Chart. B) Dot Graph. C) Line Chart. D) Column Chart. Show Answer Correct Answer: A) Pie Chart. 57. To add a line in Excel, the order clicked on the Insert menu is ..... A) Insert Sheet. B) Insert Sheet Rows. C) Insert Cells. D) Insert Sheet Column. E) Insert Name. Show Answer Correct Answer: B) Insert Sheet Rows. 58. The name of the active cell appears in the ..... A) Cell. B) Active cell. C) Name box. D) None of the above. Show Answer Correct Answer: C) Name box. 59. It is a way to transmit information that is usually viewed or listened to. A) Multimedia. B) Medium. C) Multimedia computing. D) None of the above. Show Answer Correct Answer: B) Medium. 60. Excel spreadsheets that are already created and ready for you to edit are known as? A) Spreadsheets. B) Data inputs. C) Templates. D) Pages. Show Answer Correct Answer: C) Templates. ← 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