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 10 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 10 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Microsoft Excel has a row limit of? A) 1, 048, 765. B) 1, 048, 576. C) 1, 084, 775. D) 1, 084, 675. Show Answer Correct Answer: B) 1, 048, 576. 2. What refers to the horizontal cells which can contain information? A) Rows. B) Horizontal Scroll Bar. C) Columns. D) Ribbon. Show Answer Correct Answer: A) Rows. 3. In Excel, a cell address is composed of the A) Active cell. B) Cell's row. C) Cell's column. D) Cell's column and row. Show Answer Correct Answer: D) Cell's column and row. 4. The following is a number processing application is ..... A) Canva. B) Microsoft Excel. C) Microsoft Power Point. D) Microsoft Word. Show Answer Correct Answer: B) Microsoft Excel. 5. The column and row boxes can not be displayed on the worksheet, by removing the check mark on ..... A) Ruler. B) Formula Bar. C) Message Bar. D) Printout. E) Gridelines. Show Answer Correct Answer: E) Gridelines. 6. Which of the following functions are available in MS Excel? A) PRODUCT. B) SUM. C) AVERAGE. D) All of these. Show Answer Correct Answer: D) All of these. 7. A combination of numbers and symbols used to express a calculation. A) Label. B) Active Cell. C) Formula Bar. D) Formula. Show Answer Correct Answer: D) Formula. 8. The number processing application issued by the International Business Machines (IBM) is ..... A) Ms Excel. B) Abacus. C) Scenes. D) Lotus 123. Show Answer Correct Answer: D) Lotus 123. 9. What is the main function of the worksheet processing application? A) Edit images. B) Write documents. C) Manage data in the form of a table. D) Make a presentation. Show Answer Correct Answer: C) Manage data in the form of a table. 10. Jamboard is developed by ..... ? A) Safari. B) Apple. C) Google. D) None of those. Show Answer Correct Answer: C) Google. 11. A spreadsheet program helps you to perform calculations is known as ..... A) MS Powerpoint. B) MS Word. C) DTP. D) MS Excel. Show Answer Correct Answer: D) MS Excel. 12. The horizontal arrangement of cells is called A) Row. B) Spreadsheet. C) Worksheet. D) Column. Show Answer Correct Answer: D) Column. 13. Computer components that function to display the results of data processing before printing in the paper are ..... A) CPU. B) Monitor. C) Keyboard. D) Printer. E) Mouse. Show Answer Correct Answer: B) Monitor. 14. The cell where the cell pointer is positioned. A) Active Cell. B) Filtered Cell. C) Highlighted Cell. D) Normal Cell. Show Answer Correct Answer: A) Active Cell. 15. Using the ..... feature we can fill a range of cells with data automatically. A) Autoosum. B) Autofill. C) All the above. D) None of the above. Show Answer Correct Answer: B) Autofill. 16. Numeric processing application program commonly called ..... A) Word processor. B) Database. C) Spreadsheets. D) Presentation. Show Answer Correct Answer: C) Spreadsheets. 17. Which functionin Excel checks whether a condition is true or not? A) SUM. B) AVERAGE. C) COUNT. D) IF. Show Answer Correct Answer: D) IF. 18. The Text in Excel is by default, ..... aligned. A) Left. B) Right. C) Center. D) None of the above. Show Answer Correct Answer: A) Left. 19. Sorting data in Excel based on the cell title category using ..... A) Sort & Filter. B) Fill. C) Find & Select. D) Autoosum. Show Answer Correct Answer: A) Sort & Filter. 20. One of the advanced features in Ms.Excel that can be used to find commands only by typing the command name or command is ..... A) Ribbon. B) Tell me what you want to do. C) Smart Look Up. D) Search. Show Answer Correct Answer: B) Tell me what you want to do. 21. What do the letters URL stand for? A) Undergound Railway Line. B) Universal Resource Locator. C) Uniform Resource Locator. D) Unbelievable Resource Locator. Show Answer Correct Answer: C) Uniform Resource Locator. 22. It is known as the spreadsheet application. A) MS Publisher. B) MS Word. C) MS Excel. D) MS PowerPoint. Show Answer Correct Answer: C) MS Excel. 23. A file that contains one or more worksheets to organize data is known as ..... A) Workbook. B) Datasheet. C) Spreadsheet. D) Excelbook. Show Answer Correct Answer: A) Workbook. 24. To add up the total cost of the price, You use A) AutoSum Function. B) A divide Formula. C) All the above. D) None of the above. Show Answer Correct Answer: A) AutoSum Function. 25. Spreadsheet is used by accountant and teacher. A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: A) TRUE. 26. How many numbers of sheets contain a single spreadsheet? A) 100. B) 230. C) 255. D) 155. Show Answer Correct Answer: C) 255. 27. Columns are ..... A) Lettered. B) Numbered. C) All the above. D) None of the above. Show Answer Correct Answer: A) Lettered. 28. Last Column name in Excel 2016 A) XYZ. B) QHD. C) XFD. D) What. Show Answer Correct Answer: C) XFD. 29. Division in Mathematics Operators in MS Excel is symbolized by a sign ..... A) -. B) *. C) :. D) /. Show Answer Correct Answer: D) /. 30. A ..... is a visual representation of data A) Chart. B) Border. C) Spreadsheet. D) Table. Show Answer Correct Answer: A) Chart. 31. The right step to close the worksheet that is still active in MS Excel is ..... A) File-Close. B) Office Button-Exit. C) Click the close-no sign. D) File-Exit. Show Answer Correct Answer: C) Click the close-no sign. 32. What is function of Shift Cells Right option? A) It shifts the selected cells towards right leaving blank cells. B) It inserts a new row. The row with selected cells shifts right. C) It inserts a new column. The column with selected cells shifts right. D) None of the above. Show Answer Correct Answer: A) It shifts the selected cells towards right leaving blank cells. 33. Which of the following functions are available in consolidate window? A) MAX. B) MIN. C) COUNT. D) ALL OF THE ABOVE. Show Answer Correct Answer: D) ALL OF THE ABOVE. 34. The function in the excel used calculates the average of a group of values A) AVERAGE. B) MAX. C) SUM. D) IF. Show Answer Correct Answer: A) AVERAGE. 35. This is the file where data is stored in Excel. A) Folder. B) Worksheet. C) Workbook. D) Publisher. Show Answer Correct Answer: C) Workbook. 36. The spreadsheet program contains certain calculations used to analyze data in the form ..... A) Statistics, accounting and time scheduling. B) Graphics, presentations and letters. C) Time scheduling, disseminators of undqngan and email. D) Email, Letters and Sales Data. Show Answer Correct Answer: A) Statistics, accounting and time scheduling. 37. ..... allows you to create visual presentation of facts and information. A) Word. B) Excel. C) All the above. D) None of the above. Show Answer Correct Answer: B) Excel. 38. The most widely used word processing software in late 1970s was A) AppleWorks. B) Libre office. C) WordStar. D) MS Word. Show Answer Correct Answer: C) WordStar. 39. An Excel Sheet is made of ..... A) Lines and Dots. B) Rows and Columns. C) Header and Footer. D) None of the above. Show Answer Correct Answer: B) Rows and Columns. 40. For writing the number formula in B2 cells with the correct C2 cells below is A) +Sum(B2 C2). B) =Sum(B2:C2). C) =Sum(B2, C2). D) =Sum(B2;C2). E) =Sum(B2 C2). Show Answer Correct Answer: B) =Sum(B2:C2). 41. Sum, average, count, and maximum value are examples of what? A) Calculations. B) Formulas. C) Functions. D) Spreadsheet Data. Show Answer Correct Answer: C) Functions. 42. Which formula would subtract D12 from D13? A) = D13-D12. B) =sum(D12-D13). C) = D12-D13. D) =sum(D13-D12). Show Answer Correct Answer: A) = D13-D12. 43. Which bar show the used formula of selected active cell? A) Bar menu. B) Ribbon. C) Formula Bar. D) Title Bar. Show Answer Correct Answer: C) Formula Bar. 44. The rows are numbered from top or bottom starting from 1, 2, 3 ..... 10. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 45. Sum of 15 and 9 is ..... A) 24. B) 25. C) 26. D) None of the above. Show Answer Correct Answer: A) 24. 46. What is meant by cell? A) Meeting between rows and columns. B) Group from worksheets. C) A group of several cells. D) Collection of several columns. Show Answer Correct Answer: A) Meeting between rows and columns. 47. A) =Count("String") B) =Len("String") A) Both will give the same output. B) Both will give an error. C) A) is correct B) is wrong. D) A) is wrong B) is correct. Show Answer Correct Answer: D) A) is wrong B) is correct. 48. Rows are identified by what? A) Letters of the alphabet. B) Numbers. C) Roman numerals. D) None of the above. Show Answer Correct Answer: B) Numbers. 49. ..... are mini charts placed in single cells. A) Slicer. B) Timeline. C) Sparklines. D) Power View. Show Answer Correct Answer: C) Sparklines. 50. The text are used to show what values is A) Values. B) Labels. C) Title. D) None of the above. Show Answer Correct Answer: B) Labels. 51. ..... are equations that perform calculations on values in the worksheet A) Calc. B) Formulae. C) Calculator. D) None of the above. Show Answer Correct Answer: B) Formulae. 52. The first electronic spreadsheet software was Ms-Excel. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 53. In writing the MS Excel mathematics formula always begins with a sign ..... A) = (equal to). B) *(bintang). C) ?(question mark). D) -(strip). Show Answer Correct Answer: A) = (equal to). 54. What function was used to find the lowest data? A) AVERAGE. B) SUM. C) MAX. D) MIN. Show Answer Correct Answer: D) MIN. 55. The application program used for processing numbers is called ..... A) Microsoft Word. B) Microsoft Power Point. C) Microsoft Excel. D) Android. Show Answer Correct Answer: C) Microsoft Excel. 56. The extension produced by the MS Excel spreadsheet file is ..... A) .xls. B) .odt. C) .jpg. D) .txt. E) .doc. Show Answer Correct Answer: A) .xls. 57. Ms. Online ApplicationExcel from Google? A) Speedsheet. B) Spreadsheet. C) Spreadsheer. D) Spreadheet. Show Answer Correct Answer: B) Spreadsheet. 58. Each Excel file is called a workbook because A) It can contain text and data. B) It can be modified. C) It can contain many sheets including worksheets and chart sheets. D) You have to work hard to create it. Show Answer Correct Answer: C) It can contain many sheets including worksheets and chart sheets. 59. In Excel, Rows move in ..... direction A) Vertical. B) Diagonal. C) Horizontal. D) None of the above. Show Answer Correct Answer: C) Horizontal. 60. ..... software is used for the publication of a brochure or a newsletter? A) Desktop Publishing Software. B) MS Word. C) DBMS. D) Anti virus. Show Answer Correct Answer: A) Desktop Publishing Software. ← 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