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 1 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 1 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which component of MS-Excel is the intersection of rows and columns? A) Formula bar. B) Row header. C) Column header. D) Cell. Show Answer Correct Answer: D) Cell. 2. The total number of rows in a worksheet is A) 10, 48, 576. B) 11, 48, 576. C) 16, 384. D) 12, 49, 576. Show Answer Correct Answer: A) 10, 48, 576. 3. The various elements of a chart are A) Data label, chart title, legend. B) Data legend, chart title, label. C) Chart legend. chart label, chart title. D) None of the above. Show Answer Correct Answer: A) Data label, chart title, legend. 4. Horizontal line of cells is A) Row. B) Column. C) All the above. D) None of the above. Show Answer Correct Answer: A) Row. 5. Application programs that function to process data in the form of numbers are called A) Ms. Outlook. B) Ms. Power Point. C) Ms. Word. D) Ms. Excell. Show Answer Correct Answer: D) Ms. Excell. 6. 1) A Row goes ..... A) Across. B) Down. C) Cross. D) None of the above. Show Answer Correct Answer: A) Across. 7. The program used for graphic design is ..... A) Corel Draw. B) Windows 10. C) Adobe Reader. D) Winamp. Show Answer Correct Answer: A) Corel Draw. 8. The currently selected cell in spreadsheet is called A) First Cell. B) Last Cell. C) Main Cell. D) Active Cell. Show Answer Correct Answer: D) Active Cell. 9. Every time you add something to an image it creates a new ..... A) Option. B) Color. C) Layer. D) Image. Show Answer Correct Answer: C) Layer. 10. Application on Ms.Office that can be used for presentations is ..... A) Ms. Excel. B) Ms. Word. C) Ms. Power Point. D) PPT. Show Answer Correct Answer: C) Ms. Power Point. 11. Besides Microsoft Excel, there are several types of spreadsheets, as follows, except ..... A) Scenes. B) Adobe sheet. C) Star Office Calc. D) Lotus 1-3. Show Answer Correct Answer: B) Adobe sheet. 12. A function inside other function is called ..... A) Nested Function. B) Round Function. C) Inner Function. D) None of the above. Show Answer Correct Answer: A) Nested Function. 13. Worksheet on Microsoft Excell is commonly called A) All wrong. B) Workspace. C) Worksheet. D) Slide Area. Show Answer Correct Answer: C) Worksheet. 14. The pointers initial position is in the ..... of the screen. A) Left. B) Right. C) Centre. D) All of the above. Show Answer Correct Answer: C) Centre. 15. What is formula in MS Excel? A) A platform to share videos such as YouTube. B) A command to delete picture in MS Paint. C) A rule that tells the computer what to do with the data:+, -, *, /, SUM, Average . D) I want to ask teacher about it. Show Answer Correct Answer: C) A rule that tells the computer what to do with the data:+, -, *, /, SUM, Average . 16. Which of these are not an example of how MS Excel can be used? A) Research Paper. B) Track sales. C) Track Inventory. D) Budget. Show Answer Correct Answer: A) Research Paper. 17. The function for the average calculation using the command ..... A) Count. B) Sum. C) Average. D) Max. Show Answer Correct Answer: C) Average. 18. Software that is distributed free of charge for certain purposes.Usually as a trial with limited features, and use with limited time (usually 15 or 30 days). A) Shareware. B) Freeware. C) Malware. D) Freeware. Show Answer Correct Answer: A) Shareware. 19. Cell value H3 = 20, H4 = 10, H5 = 20, H6 = 10 If given a formula = Average (H3; H6) will produce ..... A) 10. B) 15. C) 5. D) 20. Show Answer Correct Answer: B) 15. 20. The box which is a meeting between a column and row is called ..... A) Worksheet. B) Workbook. C) Sel. D) Range. E) Sheet. Show Answer Correct Answer: C) Sel. 21. AutoFill allows users to automatically fill a number or text series. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 22. Which part shows the content of an active cell, and it is also where we type formula for a certain operation? A) Formula bar. B) New sheet button. C) Active cell. D) None of the above. Show Answer Correct Answer: A) Formula bar. 23. The writing of the vlookup formula below is true ..... A) VLOOKUP(A3, G2:h5, 2). B) =VLOOKUP(A3, G2;h5, 2). C) =VLOOKUP(A3, G2:h5). D) = Hallabab (Act, Jum:Bachening, A). E) =VLOOKUP(A3;G2:h5;2). Show Answer Correct Answer: E) =VLOOKUP(A3;G2:h5;2). 24. Each grid or box in spreadsheet is called ..... A) Cell. B) Column. C) Cell reference. D) Row. Show Answer Correct Answer: A) Cell. 25. To alert Excel that you are entering a formula and not text, type a(n) ..... preceding the formula. A) #. B) *. C) &. D) =. Show Answer Correct Answer: D) =. 26. In Step Mail Merge "Starting Document" is used to select the type of document. The following is the choice of the type of document to be used, except ..... A) Email. B) Letters. C) Form. D) Directory. Show Answer Correct Answer: C) Form. 27. This bar displays the contents of active cell A) Formula bar. B) Title bar. C) Quick Access Tool bar. D) Bar menu. Show Answer Correct Answer: A) Formula bar. 28. The following is a form of media, which can be included in MS.PowerPoint is ..... A) Video. B) Picture. C) Everything can. D) Chart. E) Audio. Show Answer Correct Answer: C) Everything can. 29. Contains all the commands you will need to perform common tasks in Excel. It has multiple tabs, each with several groups of commands. A) Column. B) Cell. C) Ribbon. D) Microsoft Account. Show Answer Correct Answer: C) Ribbon. 30. Spreadsheet software is used for storing data in the form of ..... A) Rows and cells. B) Cells and columns. C) Rows and columns. D) None of the above. Show Answer Correct Answer: C) Rows and columns. 31. To close the MS application.Excel we can use the following shortcuts, namely ..... A) Ctrl + W. B) Shift + F11. C) Shift + F5. D) Ctrl + O. Show Answer Correct Answer: A) Ctrl + W. 32. What is the "Active Cell" in Excel? A) The past cell in a worksheet. It is indicated by a dark border onscreen. B) The Bottom cell in a worksheet. It is indicated by a dark border onscreen. C) The current cell in a worksheet. It is indicated by a dark border onscreen. D) The top cell in a worksheet. It is indicated by a dark border onscreen. Show Answer Correct Answer: C) The current cell in a worksheet. It is indicated by a dark border onscreen. 33. In MS Excel 2016, How many columns are there? A) 16386. B) 16384. C) 16387. D) 16385. Show Answer Correct Answer: B) 16384. 34. We use the ..... sign followed by the numeric value that you wish to write a simple formula in the formula bar. A) =. B) &. C) ?. D) #. Show Answer Correct Answer: A) =. 35. Ctrl + X is a keyboard shortcut used for? A) Paste. B) Copy. C) Delete. D) Cut. Show Answer Correct Answer: D) Cut. 36. When starting a formula what is the first thing you type in the cell? A) %. B) =. C) +. D) &. Show Answer Correct Answer: B) =. 37. Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion? A) Sort & Filter. B) Find & Select. C) Organize. D) Format Cell. Show Answer Correct Answer: A) Sort & Filter. 38. What would I use to combine cells A1:A9? A) Adjust column width. B) Merge. C) Wrap text. D) None of the above. Show Answer Correct Answer: B) Merge. 39. A cell address is A) 8. B) M. C) M8. D) None of the above. Show Answer Correct Answer: C) M8. 40. The application program from Microsoft Corporation used for presentations is ..... A) Ms. Power Point. B) Ms. Word. C) Ms. Excel. D) Ms. access. Show Answer Correct Answer: A) Ms. Power Point. 41. The extension produced by the spreadsheet file is A) Ppt. B) Doc. C) Xls. D) Exe. Show Answer Correct Answer: C) Xls. 42. Multi-platform and freeware number processing application programs even though it is limited only for non-commercial use and not for resale is ..... A) Screams. B) Wing Z. C) Gnumeric. D) Xxl. Show Answer Correct Answer: B) Wing Z. 43. Which includes computer hardware and is an input tool is ..... A) Keyboard dan mousse. B) Keyboard and cpu. C) Memory and CPU. D) Motherboard and VGA. E) Hard disk and CPU. Show Answer Correct Answer: A) Keyboard dan mousse. 44. ..... is a series of two or more adjacent cells in a column or row or rectangular group of cells. A) Section. B) Area. C) List. D) Range. Show Answer Correct Answer: D) Range. 45. Meeting between column and line in MS Worksheet.Excel is ..... A) Range. B) Pigeon. C) Line. D) Cell. Show Answer Correct Answer: D) Cell. 46. In Excel rows are labeled by A) Letters. B) Numbers. C) All the above. D) None of the above. Show Answer Correct Answer: B) Numbers. 47. What is the application file of MS-Excel? A) Exe.excel. B) Excel.exe. C) Excell.exe. D) Excel.exe. Show Answer Correct Answer: B) Excel.exe. 48. Shortcut to turn off the computer is ..... A) Ctrl + I. B) Shift + F11. C) Shift + F5. D) ALT + F4. Show Answer Correct Answer: D) ALT + F4. 49. Which one is a correct cell address? A) A1. B) A. C) 1. D) 1A. Show Answer Correct Answer: A) A1. 50. What is the term used for the intersection of column and row? A) Cell. B) Menu. C) Window. D) None of the above. Show Answer Correct Answer: A) Cell. 51. Which is not in MS Word? A) Italic. B) Font. C) Magic tool. D) Bold. Show Answer Correct Answer: C) Magic tool. 52. In PowerPoint you create: A) Slide shows. B) Documents. C) Spreadsheets. D) None of the above. Show Answer Correct Answer: A) Slide shows. 53. To give a frame to the cell, the menu that must be selected in the Cells format dialog box is A) Borders. B) Aligment. C) Button. D) Number. Show Answer Correct Answer: A) Borders. 54. David wants to arrange the employee salaries in Column A of his spreadsheet from lowest to highest. What command should he use to complete this task? A) Find & Replace. B) Autofill. C) Filter. D) Sort. Show Answer Correct Answer: D) Sort. 55. The main function of the Microsoft Excel program is A) Word processing. B) Communicate. C) Manage documents. D) Number data processor. Show Answer Correct Answer: D) Number data processor. 56. Which is the correct formula for division in a spreadsheet? A) (BT/CCTA). B) = (BT*CHART). C) = (BT-Dost). D) = (BT/CNTA). Show Answer Correct Answer: D) = (BT/CNTA). 57. The intersection between the row and the column is called A) Cursor. B) Sheet. C) Pointer. D) Cell. Show Answer Correct Answer: D) Cell. 58. Option to print the document so that the height of the page is less than its width A) Portrait. B) Landscape. C) All the above. D) None of the above. Show Answer Correct Answer: B) Landscape. 59. The main characteristic of the number processing application is ..... A) Can present graphics. B) Slide-shaped worksheet. C) Worksheet in the form of spreadsheet. D) Can process text. Show Answer Correct Answer: C) Worksheet in the form of spreadsheet. 60. A quick way to include professional formatting for different parts of your workbook, such as titles and headers. A) Borders. B) Cell Style. C) Fill Color. D) Font Color. Show Answer Correct Answer: B) Cell Style. Next →Related QuizzesComputer Science QuizzesClass 7 QuizzesClass 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 8Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 9 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books