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 3 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 3 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. One of the office processing applications is ..... A) Ms. Excel. B) Google Slide. C) Google Docs. D) Spreadsheet. E) Ms. Power Point. Show Answer Correct Answer: C) Google Docs. 2. Where we use () in excel A) Row. B) Cell. C) Work book. D) Formula. Show Answer Correct Answer: D) Formula. 3. The function used to take the left of the text data as much as certain characters A) Mid. B) Left. C) Value. D) Right. Show Answer Correct Answer: B) Left. 4. The function that allows you to combine text from different cells into one cell A) Combine. B) CONCAT. C) Counta. D) Countif. Show Answer Correct Answer: B) CONCAT. 5. What symbol is used for addition? A) +. B) /. C) *. D) -. Show Answer Correct Answer: A) +. 6. All formulae must begin with an ..... sign. A) +. B) =. C) *. D) /. Show Answer Correct Answer: B) =. 7. To see web pages on the World Wide Web you need special software called a ..... A) Web space. B) Web browser. C) Web worm. D) URL. Show Answer Correct Answer: B) Web browser. 8. Displays the content (text, value, date, or formula) in the active cell. A) Output area. B) Input area. C) Formula bar. D) Active cell. Show Answer Correct Answer: C) Formula bar. 9. If you copy the formula =$ B38 into another cell, the result will be: A) The column part will remain the same. B) The row part will remain the same. C) Both the column and row will remain the same. D) Both will change. Show Answer Correct Answer: A) The column part will remain the same. 10. Can you format text with Excel A) Yes. B) No. C) All the above. D) None of the above. Show Answer Correct Answer: A) Yes. 11. An excel workbook is a collection of A) Workbooks. B) Worksheets. C) Charts. D) Worksheets and charts. Show Answer Correct Answer: D) Worksheets and charts. 12. What is a file which contains one or more spreadsheets? A) Cell. B) Cell range. C) Spreadsheet. D) Workbook. Show Answer Correct Answer: D) Workbook. 13. You can create a basic chart by clicking the chart type that you want on the insert tab in the charts group. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 14. It is at the top of the work area in Office applications which contains of the main tabs with group of commands. A) Tool tip. B) Ribbon. C) Tab. D) None of the above. Show Answer Correct Answer: B) Ribbon. 15. It means "many media. A) Multimedia. B) Medium. C) Multimedia computing. D) None of the above. Show Answer Correct Answer: A) Multimedia. 16. Which sign is used for absolute addressing? A) @. B) $. C) *. D) &. Show Answer Correct Answer: B) $. 17. Below this is not the function of Microsoft Excel is ..... A) Financial function. B) Calculate data. C) Creating a table. D) Make graphics. E) Make a paper. Show Answer Correct Answer: E) Make a paper. 18. Which of the following formulas is not entered correctly? A) =B7+B8. B) 10+50. C) =10+50. D) = Bs+14. Show Answer Correct Answer: B) 10+50. 19. A chart ..... identifies which data series each color represents. A) Title. B) Horizontal axis. C) Vertical axis. D) Legend. Show Answer Correct Answer: D) Legend. 20. Open source software is a type of software whose source code is open and can be studied, changed, developed, improved, and can also be disseminated A) Malware. B) Shareware. C) Close Source. D) Open Source. Show Answer Correct Answer: D) Open Source. 21. When you key a formula in a spreadsheet what do you key in first? A) Subtraction sign. B) Equal Sign. C) Addition sign. D) Division sign. Show Answer Correct Answer: B) Equal Sign. 22. Workbook is a collection of A) Work file. B) Worksheet. C) Work records. D) None of the above. Show Answer Correct Answer: B) Worksheet. 23. Shortkey to display words like this is ..... A) (Ctrl + S) + (Ctrl+J). B) (Ctrl+ B) + (Ctrl+ I). C) (Ctrl + U) + (Ctrl+ I). D) (Ctrl + B) + (Ctrl + U). E) (Ctrl + A) + (Ctrl + B). Show Answer Correct Answer: B) (Ctrl+ B) + (Ctrl+ I). 24. What function is used to find the lowest data? A) SUM. B) AVERAGE. C) MAX. D) MIN. Show Answer Correct Answer: D) MIN. 25. The ..... button is used to cancel data entry before pressing enter key. A) Undo. B) Redo. C) None of the above. D) None of the above. Show Answer Correct Answer: A) Undo. 26. Statistical calculations and preparation of tables and graphs can be done using A) Excel. B) Power point. C) Word. D) None of the above. Show Answer Correct Answer: A) Excel. 27. In what tools can we set the size of a font? A) Italic. B) Fonts color. C) Bold. D) Fonts size. Show Answer Correct Answer: D) Fonts size. 28. Tabs you see at the bottom of your workbook file, labeled Sheet 1, Sheet 2, and so on. You can rename the tabs. They represent worksheets within the workbook. A) Sheet Tabs. B) Drag. C) Workbook. D) Function. Show Answer Correct Answer: A) Sheet Tabs. 29. What kind of referencing uses $ to keep the cell the same? A) Heart. B) Relative. C) Magic. D) Absolute. Show Answer Correct Answer: D) Absolute. 30. In Microsoft Excel, the file you create and edit is called: A) A form. B) A table. C) A workbook. D) A record. E) A ledger. Show Answer Correct Answer: C) A workbook. 31. I can find the lowest number in a range with the ..... function A) MAX. B) COUNT. C) MIN. D) AVERAGE. Show Answer Correct Answer: C) MIN. 32. Serves to show the number of pages, number of words, language that we write (type), etc., is a function of ..... A) Scroll bar. B) Tool bar. C) Status bar. D) Bar menu. Show Answer Correct Answer: C) Status bar. 33. In an Excel spreadsheet, what is the correct formula to multiply the value in B6 by the value in C12? A) = Bsh*12. B) (C12 X B6). C) (12*bsh). D) Bsh*12. Show Answer Correct Answer: A) = Bsh*12. 34. Making a graph is one of the functions of ..... A) Ms-word. B) Ms-power point. C) Ms-excel. D) All answers are wrong. E) OF THE. Show Answer Correct Answer: A) Ms-word. 35. The intersection of a row and column forms a small rectangular area called cell. A) False. B) True. C) All the above. D) None of the above. Show Answer Correct Answer: B) True. 36. Place where you can rename each worksheet. Located at the bottom of the worksheet window. A) Chart. B) Sheet tab. C) Formula. D) Name Box. Show Answer Correct Answer: B) Sheet tab. 37. ..... tab allows you to correct spelling and grammar issues as well as security portion A) Data. B) View. C) Review. D) None of the above. Show Answer Correct Answer: C) Review. 38. Below that is not an arithmetic function is ..... A) ?. B) /. C) -. D) +. Show Answer Correct Answer: A) ?. 39. Which error is obtained when a formatted number does not fit within a cell? A) #DIV@. B) #DIV/0. C) #####. D) #VALUE!. Show Answer Correct Answer: C) #####. 40. What is MS Excel? A) Database Management. B) Presentation. C) Workbook. D) Spreadsheet. Show Answer Correct Answer: D) Spreadsheet. 41. Allows you to create clear and defined boundaries for different sections of your worksheet. A) Cell Borders and Fill Colors. B) Headings. C) Font Size. D) Font Color. Show Answer Correct Answer: A) Cell Borders and Fill Colors. 42. The lines on your worksheet that separate the columns and rows. A) Functions. B) Sheet Tabs. C) Cell Grid. D) Formula Bar. Show Answer Correct Answer: C) Cell Grid. 43. Cells that run horizontally on a spreadsheet A) Column. B) Row. C) Range. D) Workbook. Show Answer Correct Answer: B) Row. 44. The symbol used to make absolute reference is ..... A) %. B) #. C) $. D) @. Show Answer Correct Answer: C) $. 45. The statistical function to find the highest value is ..... A) MIN. B) COUNT. C) SUM. D) MAX. Show Answer Correct Answer: D) MAX. 46. Division symbol in spreadsheet. A) /. B) +. C) =. D) None of the above. Show Answer Correct Answer: A) /. 47. The type of data that can be calculated mathematically is ..... A) Alphanumeric. B) Text. C) Symbol. D) Numeric. Show Answer Correct Answer: D) Numeric. 48. The file extension for Excel: A) .pptx. B) .docx. C) .xlsx. D) None of the above. Show Answer Correct Answer: C) .xlsx. 49. What application can you use to create emails? A) Excel. B) Outlook. C) PowerPoint. D) Word. Show Answer Correct Answer: B) Outlook. 50. Besides being able to help users in the number calculation process, spreadsheet is also able to help in the following aspects, except ..... A) Data management. B) Time management. C) Analyze data. D) Make graphics. Show Answer Correct Answer: B) Time management. 51. Which of the followings can not be performed in Microsoft Excel? A) Creating chart, making mathematical calculations. B) Inserting pictures, creating table. C) Making graphic design. D) Using formulas and functions. Show Answer Correct Answer: C) Making graphic design. 52. What button will add up a group of numbers? A) Equals button. B) Auto sum button. C) Plus symbol button. D) None of the above. Show Answer Correct Answer: B) Auto sum button. 53. In a worksheet, the vertical spaces with the headings A, B, C and so on A) Column. B) Cell address. C) Label. D) Row. Show Answer Correct Answer: A) Column. 54. In Microsoft Excel spreadsheets, COLUMNS are labelled as ..... A) 1, 2, 3, . B) A, B, C, . C) A1, B1, C1 . D) I, II, III and . Show Answer Correct Answer: B) A, B, C, . 55. It displays the cell address of the active cell. A) Formula bar. B) Cell. C) Row and Column. D) Name box. Show Answer Correct Answer: D) Name box. 56. In ribbon of ms excel each tab contains A) Home, Insert, Page Layout,. B) Data, Review and View. C) Home, Insert, Page Layout, Formulas, Data, Review and View. D) Layout, Formulas, Data, Review. Show Answer Correct Answer: C) Home, Insert, Page Layout, Formulas, Data, Review and View. 57. ..... is the process of giving movement to drawings, models, or inanimate objects A) Games design. B) Story writing. C) Animation. D) Video editing. Show Answer Correct Answer: C) Animation. 58. Short key to thicken letters in excel is ..... A) CTRL + C. B) CTRL + E. C) CTRL + B. D) CTRL + A. E) CTRL + D. Show Answer Correct Answer: C) CTRL + B. 59. Which of the following is not a function of MS-Excel? A) AVERAGE. B) Min. C) ADD. D) MAX. Show Answer Correct Answer: C) ADD. 60. The number processing application issued by Microsoft is ..... A) Abacus. B) Ms.Excel. C) OpenOffice Calc. D) Xxl. E) Scenes. Show Answer Correct Answer: B) Ms.Excel. ← 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 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