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 20 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 20 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. When we will create a Google account, on the login page, the button that we have to press is ..... A) Login. B) Next. C) Create an account. D) Forgot Sandi. Show Answer Correct Answer: C) Create an account. 2. Excel displays the current cell address in the ..... A) Formula bar. B) Name box. C) Title bar. D) Menu bar. Show Answer Correct Answer: B) Name box. 3. A3 is an example of a cell's address A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 4. State whether the statements are True or False.The latest version of MS Office is Microsoft Office 2013. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 5. In Ms Excel you can change the colour of the cell using? A) Font Colour. B) Fill Colour. C) All the above. D) None of the above. Show Answer Correct Answer: B) Fill Colour. 6. The small part of the worksheet which is a meeting of rows and columns is ..... A) Column. B) Range. C) Cell. D) Table. Show Answer Correct Answer: C) Cell. 7. One of the application programs in Microsoft Office, except A) Ms. Word. B) Adobe Photoshop. C) Ms. Excell. D) Ms. Power Point. Show Answer Correct Answer: B) Adobe Photoshop. 8. In Excel, text entered into a cell automatically aligns to ..... ? A) The right. B) The left. C) The Top. D) The centre. Show Answer Correct Answer: B) The left. 9. Full form of E-mail is? A) Electronic Mail. B) Electric Mail. C) Electronic Male. D) None of the above. Show Answer Correct Answer: A) Electronic Mail. 10. The first spreadsheet application for personal computers was ..... A) Cars Calc. B) Vishual calc. C) VISICALC. D) None of the above. Show Answer Correct Answer: C) VISICALC. 11. What are the horizontal ranges of cells that are labeled by numbers? A) Column. B) Row. C) Menu. D) None of the above. Show Answer Correct Answer: B) Row. 12. The extension used in Microsoft Office Excel 2007 is A) *.ppt. B) *.cdr. C) *.xlsx. D) *.exlx. Show Answer Correct Answer: C) *.xlsx. 13. An MS Excel file is synonymous with ..... A) A work table. B) A book sheet. C) A cell. D) A worksheet. E) A workbook. Show Answer Correct Answer: E) A workbook. 14. MS Excel is widely used for ..... , financial application, statistics and engineering calculations. A) Accounting. B) Video editing. C) Photo editing. D) Word processing. Show Answer Correct Answer: A) Accounting. 15. Which ofthe following is not the correct method of editing the cell content? A) Press the F2 key. B) Press the Alt key. C) Double click the cell. D) Click the formula bar. Show Answer Correct Answer: B) Press the Alt key. 16. What format should I save my work as? A) Lonely. B) JPEG. C) Webp. D) MPP. Show Answer Correct Answer: B) JPEG. 17. What term describes explanatory text attached to a cell? A) Context. B) Callout. C) Comment. D) Dialog. Show Answer Correct Answer: C) Comment. 18. ..... are the combination of column letter and row number. A) Formula. B) Cell address. C) Operators. D) None of the above. Show Answer Correct Answer: B) Cell address. 19. What should be clicked to move on next cell A) Tab key. B) Arrow keys. C) Using the mouse pointer. D) All of the above. Show Answer Correct Answer: D) All of the above. 20. Which is the correct example for formula data A) =5+10. B) A1+B1 =. C) = A1B1. D) None of the above. Show Answer Correct Answer: A) =5+10. 21. Explain the difference between Sumif and Sumifs! A) Sumif is only used for numbers, Sumifs for text. B) Sumif add up all data, Sumifs did not add up at all. C) Sumif adds up data with one criterion, Sumifs adds up data with several criteria. D) Sumif and Sumifs have the same function. Show Answer Correct Answer: C) Sumif adds up data with one criterion, Sumifs adds up data with several criteria. 22. This classification indicates that the data has the potential to be used in calculations. A) Function. B) Label. C) Value. D) Formula. Show Answer Correct Answer: C) Value. 23. The excel window part used to move the work sheet in horizontal direction is ..... A) Task Pane. B) Costumize. C) Scroll Bar Horizontal. D) Scroll Bar Vertical. Show Answer Correct Answer: C) Scroll Bar Horizontal. 24. In Excel, a row is denoted by ..... A) Letters. B) Numbers. C) Symbols. D) Colors. Show Answer Correct Answer: B) Numbers. 25. Getting data from a cell located in a different worksheet is called? A) Functioning. B) Referencing. C) Updating. D) Accessing. Show Answer Correct Answer: B) Referencing. 26. Each Excel file is known as a ..... A) Worksheet. B) Tab. C) Workbook. D) Document. Show Answer Correct Answer: C) Workbook. 27. A ..... is a faded text or image behind the text in a document. A) Page orientation. B) Header. C) Watermark. D) None of the above. Show Answer Correct Answer: C) Watermark. 28. How many sheets does an excel window displays by default? A) 4. B) 1. C) 3. D) 2. Show Answer Correct Answer: C) 3. 29. Which function returns the current date? A) THEN. B) TIME. C) NOW. D) DATE. Show Answer Correct Answer: C) NOW. 30. ..... is description of the task that gives you information to design a spreadsheet. A) Structure brief. B) Summary design. C) Briefcase. D) Design brief. Show Answer Correct Answer: D) Design brief. 31. ..... tells you what type of organization is operating the network. A) Browser. B) Website. C) Suffix. D) GIF. Show Answer Correct Answer: C) Suffix. 32. Which is the right below which is the display of Microsoft Excel ..... A) Office Button. B) Tab Ribbon. C) Insert Function. D) All answers are correct. Show Answer Correct Answer: D) All answers are correct. 33. Word/Docs is a ..... program. A) Spreadsheets. B) Internet. C) Presentation. D) Document. Show Answer Correct Answer: D) Document. 34. The meeting between columns and rows in Microsoft Excel is known as A) Range. B) Sheet. C) Cell. D) Clipboard. Show Answer Correct Answer: C) Cell. 35. In spreadsheet what we can do? A) We can enter data. B) We can not draw charts. C) We can not edit data. D) We can not create worksheets. Show Answer Correct Answer: A) We can enter data. 36. The Document area is the blank document for MS Excel. A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: B) FALSE. 37. What is the name of the blank Google Sheet? A) Blank Sheet. B) New Spreadsheet. C) Untitled Spreadsheet. D) None of the above. Show Answer Correct Answer: A) Blank Sheet. 38. What is the name for a line of cells that go across the spreadsheet? A) Field. B) Row. C) Record. D) Column. Show Answer Correct Answer: B) Row. 39. What does CTRL Z do? A) Undo. B) Paste. C) Cut. D) Copy. Show Answer Correct Answer: A) Undo. 40. What type of chart will you use to compare performance of sales of two products? A) Column Chart. B) Line Chart. C) Pie Chart. D) Both A and B. Show Answer Correct Answer: A) Column Chart. 41. To change the font, font size, color, or style:Select the ..... you want to modify. A) Column Headings. B) Cells. C) All the above. D) None of the above. Show Answer Correct Answer: B) Cells. 42. A1:A10 is an example of ..... A) Formula. B) Cell Address. C) Function. D) Cell Range. Show Answer Correct Answer: D) Cell Range. 43. Group of cells that runs from the left of the page to the right. In Excel, these are identified by numbers. A) Worksheet. B) Formula Bar. C) Row. D) Column. Show Answer Correct Answer: C) Row. 44. To open the Ms. windowExcel via desktop is by means ..... A) Double klik shortcut Ms. Exel. B) Klik icon Ms. Exel. C) Klik Kanan Shortcut MS.Excel. D) Ms. Shortcut Left Click.Excel. Show Answer Correct Answer: B) Klik icon Ms. Exel. 45. Manages data files in a computer system. A) Graphic design and editing software. B) File Management Software. C) Desktop Publishing Software. D) None of the above. Show Answer Correct Answer: B) File Management Software. 46. A ..... is a document that stores data in a grid of horizontal rows and vertical columns. A) Plus. B) Row. C) Minus. D) Spreadsheet. Show Answer Correct Answer: D) Spreadsheet. 47. What is the purpose of Excel? A) Creating presentations. B) Managing databases. C) Analyzing data. D) None of the above. Show Answer Correct Answer: C) Analyzing data. 48. What symbol should be used to perform a multiplying calculation? A) *. B) /. C) -. D) +. Show Answer Correct Answer: A) *. 49. Table of Contents make a table of contents automatically ..... A) Creative. B) Damaged. C) Neat. D) Increase. Show Answer Correct Answer: C) Neat. 50. What function is used to add more than 2 cells? A) +. B) =. C) ( ). D) SUM. Show Answer Correct Answer: D) SUM. 51. Name of the workbook is displayed in the A) Title bar. B) Bar menu. C) Tool bar. D) Option bar. Show Answer Correct Answer: A) Title bar. 52. Automatic information system via WA abbreviated ..... A) OWL. B) Sore. C) Saaw. D) Shiva. Show Answer Correct Answer: B) Sore. 53. The way to save the file is ..... A) File-Save As-Browse. B) Save As. C) File-Save. D) File-Save As. Show Answer Correct Answer: A) File-Save As-Browse. 54. Microsoft Excel is categorized as a ..... software. A) Database. B) Presentation. C) Word Processing. D) Spreadsheet. Show Answer Correct Answer: D) Spreadsheet. 55. The first electronic spreadsheet was ..... A) Spreadsheet. B) Visycalk. C) ViciCalc. D) VISICALC. Show Answer Correct Answer: D) VISICALC. 56. What is the shortcut key to hide entire column? A) CTRL +-. B) CTRL + C. C) CTRL + H. D) CTRL + 0. Show Answer Correct Answer: D) CTRL + 0. 57. When we want to lock in capital letters, then the pressed button is ..... A) Ctrl. B) Numlock. C) Shift. D) Capslock. E) Tab. Show Answer Correct Answer: D) Capslock. 58. A spreadsheet software developed by Microsoft. A) MS Excel. B) MS Word. C) MS PowerPoint. D) None of the above. Show Answer Correct Answer: A) MS Excel. 59. ..... is a rectangular area where a column and row intersect. A) Row. B) Sheet tab. C) Column. D) Cell. Show Answer Correct Answer: D) Cell. 60. What is the output of the function =if(A1=A2, "Unequal", "Equal") when A1=10 A2 = 11 A) Equal. B) Unequal. C) Error. D) None of these. Show Answer Correct Answer: A) Equal. ← 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