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 9 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 9 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. The number processing application is also called ..... A) Word Processor. B) Word Presentation. C) Spreadsheet. D) Word Programming. Show Answer Correct Answer: C) Spreadsheet. 2. This menu basically has a function that is almost the same as a storage.However, this menu has more specific functions such as selecting storage locations and changing file types. A) Save. B) Open. C) Save as. D) Paste. Show Answer Correct Answer: C) Save as. 3. Small input box on the left A) Formula Bar. B) Status Bar. C) Name box. D) None of the above. Show Answer Correct Answer: C) Name box. 4. Excel is what type of software? A) Word Processing. B) Presentation. C) Spreadsheets. D) Database. Show Answer Correct Answer: C) Spreadsheets. 5. The extension of the Microsoft Excel file is ..... A) *.html. B) *.ppt. C) *.xls. D) *.doc. E) *.pdf. Show Answer Correct Answer: C) *.xls. 6. Examples of word processing programs below, except ..... A) Notepad. B) Wordpad. C) MS Word 2010. D) Ms Access 2003. E) MS Word 2007. Show Answer Correct Answer: D) Ms Access 2003. 7. How will you graphically represent expenditure in different departments? A) Dot Chart. B) Column Chart. C) Line Chart. D) Pie Chart. Show Answer Correct Answer: D) Pie Chart. 8. The line is symbolized by ..... A) Number. B) Letter. C) Numbers and letters. D) White. Show Answer Correct Answer: A) Number. 9. In Excel, columns are identified by the use of this? A) Letters. B) Numbers. C) All the above. D) None of the above. Show Answer Correct Answer: A) Letters. 10. When inserting a formula, always start with A) Equals symbol. B) Plus symbol. C) Minus symbol. D) None of the above. Show Answer Correct Answer: A) Equals symbol. 11. Excel sheet can use ..... Fonts A) 512. B) 1024. C) 256. D) 100. Show Answer Correct Answer: A) 512. 12. To multiply items in Excel, you would use: A) *. B) /. C) X. D) -. E) =. Show Answer Correct Answer: A) *. 13. Macros option is avalable under: A) View. B) Tools. C) Review. D) Insert. Show Answer Correct Answer: B) Tools. 14. A SINGLE ..... BOX IS CALLED A ..... IN A WORKSHEET. A) COLUMN-RECTANGULAR. B) RECTANGULAR-CELL. C) COLUMN-ROW. D) CELL-RECTANGULAR. Show Answer Correct Answer: B) RECTANGULAR-CELL. 15. Mathematical ..... can be easily inserted in a word document. A) Equations. B) Orientation. C) All the above. D) None of the above. Show Answer Correct Answer: A) Equations. 16. Multiplatform and freeware numeric processing programs are ..... A) WingZ. B) Gnumeric. C) Xxl. D) Ms. Excel. Show Answer Correct Answer: A) WingZ. 17. It is not possible to name the worksheet as A) Temp. B) Default. C) Excel. D) History. Show Answer Correct Answer: D) History. 18. You can present your data graphically, using a A) Sort. B) Font. C) Chart. D) Print. Show Answer Correct Answer: C) Chart. 19. For multiplying numbers in A1 AND B1, you use the following formula A) = A1*B1. B) A1*b1. C) A1%B1. D) = A1/B1. Show Answer Correct Answer: A) = A1*B1. 20. Name of MS office and Google's spreadsheet programs. A) Google Slides/MS PowerPoint. B) Google Sheets/MS Excel. C) Google Docs/MS Word. D) Google Forms/Access. Show Answer Correct Answer: B) Google Sheets/MS Excel. 21. A powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, and graph data. A) Word. B) Publisher. C) Outlook. D) Excel. Show Answer Correct Answer: D) Excel. 22. Ways to see the final results on the advanced Mail Merge feature on MS Word by clicking ..... A) Mailings. B) Select recipients. C) Existing List. D) Insert. E) Finish and merge. Show Answer Correct Answer: E) Finish and merge. 23. Which component of Excel window allows you to type formulae? A) Title bar. B) Formula bar. C) Name box. D) Bar menu. Show Answer Correct Answer: B) Formula bar. 24. What are the uses of Paste tools? A) To choose the type of letter. B) To improve/replace, edit a document. C) Copy the Format of the Worksheet Pages to Use on Other Pages. D) Attach a good text or image / table object that was previously copied for use. Show Answer Correct Answer: D) Attach a good text or image / table object that was previously copied for use. 25. What is the correct term for the area where you can view the contents of the active cell in Excel? A) Formula Bar. B) Name Box. C) Title Bar. D) Men's menu. Show Answer Correct Answer: A) Formula Bar. 26. Which feature of Calc helps to see the changes made in the shared worksheet? A) Solver. B) Subtotal. C) Record Changes. D) None. Show Answer Correct Answer: C) Record Changes. 27. The number of worksheets in Microsoft Excel workbooks consists of ..... A) 256 columns and 65356 rows. B) 256 columns and 65536 rows. C) 256 columns and 63536 rows. D) 256 columns and 65536 rows. E) 265 columns and 65256 rows. Show Answer Correct Answer: B) 256 columns and 65536 rows. 28. A Worksheet contains ..... rows. A) 1049786. B) 1048576. C) Infinity. D) 1058786. Show Answer Correct Answer: B) 1048576. 29. The cell with a dark boundary around it is called the ..... A) Active cell. B) Present cell. C) None of the above. D) None of the above. Show Answer Correct Answer: A) Active cell. 30. Which of the following option is a formula? A) Subtract the numbers. B) =SUM(A1:A5). C) Add A1-A5. D) A1 = A5. Show Answer Correct Answer: B) =SUM(A1:A5). 31. A small box that holds data A) Row. B) Column. C) Cell. D) None of the above. Show Answer Correct Answer: C) Cell. 32. MS Excel is a ..... A) Database Management software. B) Presentation software. C) Workbook software. D) Spreadsheet software. Show Answer Correct Answer: D) Spreadsheet software. 33. Ms. Worksheet Section.Excel which displays the name of the workbook that is being active or opened A) Title Bar. B) Status Bar. C) Quick Accsess. D) Men's menu. Show Answer Correct Answer: A) Title Bar. 34. In Excel, the heading "boxes" going from left to right are called ..... A) Columns. B) Letters. C) Rows. D) Headers. Show Answer Correct Answer: A) Columns. 35. How would you write a cell reference formula for cell A1 subtracted by Cell C3? A) = A1-kz. B) A1-kz =. C) = KZ-A1. D) A1-kz. Show Answer Correct Answer: A) = A1-kz. 36. The intersection point of row and column is called? A) Track. B) Cell. C) Pixel. D) Pointer. Show Answer Correct Answer: B) Cell. 37. Once a type of graph is chosen it cannot be changed to other type A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 38. The Hyperlink function is used to create links to ..... A) Workbook locations. B) Pages on the internet. C) Files on network servers. D) All of the above. Show Answer Correct Answer: D) All of the above. 39. Which of the following would NOT be stored in a cell? A) Text. B) Chart. C) Formula. D) Number. Show Answer Correct Answer: B) Chart. 40. We can add charts in a way ..... A) Click the Home Menu Select Table. B) Click the Insert menu select chart. C) Click the Mailings menu select Table. D) Click the Design Menu Select Chart. E) Click the References menu select Design. Show Answer Correct Answer: B) Click the Insert menu select chart. 41. The following is a function of Ms.excel, except A) Perform mathematical operations. B) Making financial reporting. C) Make a financial bill. D) Make an attendance report. Show Answer Correct Answer: C) Make a financial bill. 42. Workbook is a collection of worksheets. A) Worksheets. B) Sheets. C) None of the above. D) None of the above. Show Answer Correct Answer: A) Worksheets. 43. Which function can be used to convert a text string to a date format in Excel? A) TEXT. B) VALUE. C) CONVERT. D) DATE VALUE. Show Answer Correct Answer: B) VALUE. 44. ..... programs perform specific tasks usually related to managing a computer, its devices and programs. A) DTP. B) Utility. C) Application. D) DBMS. Show Answer Correct Answer: B) Utility. 45. Nine dot grid is otherwise known as ..... A) Waffle iron. B) INBOX. C) OF THE. D) WINDOWS. Show Answer Correct Answer: A) Waffle iron. 46. MS Excel application is a processing application ..... A) Symbol. B) Number. C) Letter. D) Character. Show Answer Correct Answer: B) Number. 47. Pivot Table feature introduced by A) Multi plan. B) MS Office. C) Open Office. D) Lotus 123. Show Answer Correct Answer: D) Lotus 123. 48. What is meant by active cells is ..... A) Cells containing data. B) The cells that appear in the worksheet. C) Cells that contain formulas or formulas. D) Cells containing the results of calculations. E) The cell used at that time. Show Answer Correct Answer: E) The cell used at that time. 49. In a company, making financial statements will be easier to make using the application ..... A) Ms. Excel. B) Ms. Word. C) Ms. Publisher. D) Ms. Outlook. E) Ms. PowerPoint. Show Answer Correct Answer: A) Ms. Excel. 50. A spreadsheet program that allows you to store, organize, and analyze information. A) MS Word. B) MS Excel. C) MS PowerPoint. D) MS Access. Show Answer Correct Answer: B) MS Excel. 51. The bar where information appears as you input data is called ..... A) Formula bar. B) File bar. C) Window bar. D) Help bar. Show Answer Correct Answer: A) Formula bar. 52. Which of the following is an example of a cell reference? A) A5. B) =SUM. C) Column C. D) Row 1. Show Answer Correct Answer: A) A5. 53. Program groups to process specific data used for specific needs such as helping employment A) Application. B) Utility. C) Sisem operated. D) Programming language. Show Answer Correct Answer: A) Application. 54. 44 ..... tab shows backstage view. A) Home. B) Edit. C) File. D) None of the above. Show Answer Correct Answer: C) File. 55. When you enter text in a cell in MS Excel. It is also appears in the A) Name Box. B) Status Bar. C) Formula Bar. D) Row Heading. Show Answer Correct Answer: C) Formula Bar. 56. The other name of X-axis is ..... A) Value axis. B) Blocks. C) Axes title. D) Category axis. Show Answer Correct Answer: D) Category axis. 57. When we want to make a letter, we can use the program ..... A) MS. Word. B) Photoshop. C) Lotus 123. D) MS. Excel. Show Answer Correct Answer: A) MS. Word. 58. A single worksheet in excel-2007 has a maximum of ..... columns. A) 18, 278. B) 18, 276. C) 18, 275. D) 18, 277. Show Answer Correct Answer: A) 18, 278. 59. MS Word is ..... software. A) Web browser. B) Operating system. C) Antivirus. D) Word processing. Show Answer Correct Answer: D) Word processing. 60. In Word Processing text formatting is available A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. ← 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