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 15 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 15 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. It is an Excel tool used to combine 2 or more cells together A) Merge and Center. B) Center. C) Align Left. D) Justify. Show Answer Correct Answer: A) Merge and Center. 2. It refers to the colored row of letters which is used to identify each column. A) Select all button. B) Name box. C) Column header. D) Row header. Show Answer Correct Answer: C) Column header. 3. The formula used to multiply the number 8 multiplied 9 is ..... A) = 9 x 8. B) = 8 x 9. C) = 8 * 9. D) = 8 times 9. Show Answer Correct Answer: C) = 8 * 9. 4. An Excel file format extension is A) Doc. B) Txt. C) Csv. D) Xls. Show Answer Correct Answer: D) Xls. 5. What tool in Slides or PowerPoint allows pictures, text, shapes etc to move on the slide A) Animimation. B) Function. C) Design. D) Tranisitions. Show Answer Correct Answer: A) Animimation. 6. ..... refers to the rotation of the text at different angles inside the cell A) Alignment. B) Orientation. C) Indentation. D) Merging. Show Answer Correct Answer: B) Orientation. 7. Instructs the software to perform a calculation. A) Formula. B) Value. C) Label. D) Function. Show Answer Correct Answer: A) Formula. 8. By default/ automatically, worksheets in MS.The 2007 version of Excel will display ..... A) 4 sheet. B) 2 sheet. C) 1 sheet. D) 5 sheet. E) 3 sheet. Show Answer Correct Answer: E) 3 sheet. 9. What Home Ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style? A) Font. B) Editing. C) Styles. D) Alignment. Show Answer Correct Answer: C) Styles. 10. What is the max Zoom percentage in MS PowerPoint? A) 100%. B) 200%. C) 300%. D) 400%. Show Answer Correct Answer: D) 400%. 11. To make a report in the form of number data along with graphics, we can use the program ..... A) MS. Excel. B) MS. Publisher. C) MS. Power Point. D) MS. Paint. Show Answer Correct Answer: A) MS. Excel. 12. Macros are found in which Tab ..... A) Data. B) Formula. C) Developer. D) None of the above. Show Answer Correct Answer: B) Formula. 13. To insert a new worksheet, press ..... A) Shift+F2. B) Shift+1. C) Shift+F12. D) Shift+F11. Show Answer Correct Answer: D) Shift+F11. 14. Formatting feature improve the appearance of data A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: A) TRUE. 15. To calculate the column that contains the text we can use the formula ..... A) =DATE. B) = Hlookup. C) = Countif. D) =AVERAGE. E) =SUM. Show Answer Correct Answer: C) = Countif. 16. Document file management button on Microsof Office Excel is round with the office logo in the middle A) Ribbon. B) Toolbar. C) Tilate bar. D) Excel Options. E) Office Button. Show Answer Correct Answer: E) Office Button. 17. The basic unit of the spreadsheet A) Row. B) Column. C) Cell. D) None of the above. Show Answer Correct Answer: C) Cell. 18. Which option in Excel can help you to fully display longer text in a cell without it overflowing to other cells? A) Wrap Text. B) Merge Across. C) Merge & Center. D) Merge Cells. Show Answer Correct Answer: A) Wrap Text. 19. Scenarios are tools to test ..... questions. A) If else. B) What if. C) What else. D) If. Show Answer Correct Answer: B) What if. 20. The set of data that runs left to right in a spreadsheet A) Row. B) Column. C) Cell. D) Active cell. Show Answer Correct Answer: A) Row. 21. Address of the current cell is contained in A) Cell address. B) Status bar. C) Formula bar. D) Name box. Show Answer Correct Answer: D) Name box. 22. Which of the follois an example of page orientation? A) Landscape. B) Subscript. C) Superscript. D) Pink. Show Answer Correct Answer: A) Landscape. 23. If you click a number at the left of an Excel spreadsheet, what have you done? A) Selected a cell. B) Selected a row of data. C) Selected a column of data. D) Selected a range of cells. Show Answer Correct Answer: B) Selected a row of data. 24. The following is not a number processing application is ..... A) Open Office Calc. B) Google Slides. C) Google Sheet. D) Lotus. Show Answer Correct Answer: B) Google Slides. 25. What function will add up all the numbers in a column? A) = If (a1:a6). B) =SUM(E1:E5). C) =AVERAGE(E1:E5). D) =CONCAT(E1:E5). Show Answer Correct Answer: B) =SUM(E1:E5). 26. The data for a chart should be inserted in a cell in spreadsheet. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 27. All of the following are the uses of MS Excel, EXCEPT: A) Used for Calculations. B) Managing inventory. C) Presenting videos and audio. D) Collecting data from different sources. Show Answer Correct Answer: C) Presenting videos and audio. 28. What is the cell in the worksheet in which you can type data? A) Open Cell. B) Absolute Cell. C) Active Cell. D) Main Cell. Show Answer Correct Answer: C) Active Cell. 29. The worksheet in Excel is also called ..... A) Range. B) Worksheet. C) Area slide. D) Cell. Show Answer Correct Answer: B) Worksheet. 30. In Excel, what is a horizontal group of cells identified by numbers? A) Cells. B) Column. C) Row. D) Name Box. Show Answer Correct Answer: C) Row. 31. ..... command is used to draw lines in different directions. A) Screen. B) Circle. C) Colour. D) Draw. Show Answer Correct Answer: D) Draw. 32. In MS Excel spreadsheet, Data can be sorted using ..... A) Lookup function. B) Operator function. C) Filter function. D) ARRAY function. Show Answer Correct Answer: C) Filter function. 33. Which of the following features cannot be found in the Data ribbon? A) What-If Analysis. B) Text to Columns. C) Pivot Table. D) Data Validation. Show Answer Correct Answer: C) Pivot Table. 34. What does the VLOOKUP function do? A) Looks up text that contain V. B) Checks whether text is the same in one cell as in the next. C) Finds related records. D) All of above. Show Answer Correct Answer: C) Finds related records. 35. What is an example of a RANGE in MS Excel. A) Ba:Fear. B) Swollen. C) Trap:Ba. D) (Ba:A trap). Show Answer Correct Answer: D) (Ba:A trap). 36. In Excel, all formulae must begin with ..... sign. A) $. B) #. C) &. D) =. Show Answer Correct Answer: D) =. 37. Where to write a formula is called ..... A) Title Bar. B) Tab Ribbon. C) Formula bar. D) Tool bar. E) Bar menu. Show Answer Correct Answer: C) Formula bar. 38. Mircrosoft Excel can be used for working with ..... A) Tables. B) Chart. C) Both Charts & Tables. D) None of the above. Show Answer Correct Answer: C) Both Charts & Tables. 39. Which of the following is spreadsheet software? A) Notepad. B) MS Paint. C) MS Word. D) MS Excel. Show Answer Correct Answer: D) MS Excel. 40. Which of the following is an absolute cell reference? A) $ A$ 1. B) !A!1. C) A1. D) #a#1. Show Answer Correct Answer: A) $ A$ 1. 41. Title line in Ms.Excel is also called A) Bar menu. B) Tittle bar. C) Toolbar. D) All answers are wrong. Show Answer Correct Answer: B) Tittle bar. 42. You can check the conditions against ..... when applying conditional formatting A) Cell value. B) Formula. C) Both of above. D) None of above. Show Answer Correct Answer: A) Cell value. 43. By default, the number is ..... aligned in a cell. A) Left. B) Center. C) Right. D) None of the above. Show Answer Correct Answer: C) Right. 44. There are three types of data found in a spreadsheet. A) Numbers formulas, labels. B) Data, words, numbers. C) Equations, data, numbers. D) Words, numbers, labels. Show Answer Correct Answer: A) Numbers formulas, labels. 45. The columns in MS Excel are being labelled as: A) Roman numerals. B) English Alphabet. C) Symbols. D) Numbers. Show Answer Correct Answer: B) English Alphabet. 46. It is part of a spreadsheet software. It has boxes called cells. These cells are arranged in rows and columns. A) Spreadsheets. B) Workbooks. C) Worksheets. D) None of the above. Show Answer Correct Answer: C) Worksheets. 47. MS Excel is a component of ..... A) Adobe Suit software. B) Movie Maker Software. C) MS Office package. D) None of the above. Show Answer Correct Answer: C) MS Office package. 48. What image tool removes an unwanted portion of the image? A) Crop. B) Canvas. C) Stacking. D) Anchor. Show Answer Correct Answer: A) Crop. 49. What value would excel return for this formula? =(82-32)5+8*2 A) 30. B) 21. C) 37. D) 26. Show Answer Correct Answer: D) 26. 50. The sign of division in represented by the sign ..... A) /. B) =. C) +. D) -. Show Answer Correct Answer: A) /. 51. Which one is not included in the Mailing Menu A) Envelopes. B) Directory. C) Labels. D) Table of contens. Show Answer Correct Answer: D) Table of contens. 52. The following is a function of ms.word ..... A) Make images. B) Make a letter. C) Make posters. D) Create a database. E) Processing numbers. Show Answer Correct Answer: B) Make a letter. 53. What does the Average formula return? A) Returns the lowest argument. B) Returns the middle argument. C) Returns the three highest arguments. D) Returns the mean of all its arguments. Show Answer Correct Answer: D) Returns the mean of all its arguments. 54. ..... is a feature of MS Word used to represent hierarchy charts. A) WordArt. B) Smartart. C) All the above. D) None of the above. Show Answer Correct Answer: B) Smartart. 55. Social media is ..... A) Media to do online learning. B) Media to socialize with many people through online. C) Media to spread viral news. D) Media to spread gossip. Show Answer Correct Answer: B) Media to socialize with many people through online. 56. How to close MS-excel is ..... A) Edit-close. B) File-close. C) Edit-paste. D) File-new. E) File-open. Show Answer Correct Answer: B) File-close. 57. Joan wants to see her sales representatives in numerical order with the sales person who sold the least at the top. Which sorting option should she choose? A) Primary Sort. B) Customer Filter. C) Ascending. D) Descending. Show Answer Correct Answer: C) Ascending. 58. What Programming language is used in Excel A) Visual Basic. B) Fortran. C) Python. D) Basic. Show Answer Correct Answer: A) Visual Basic. 59. Can users move between various worksheets A) Yes. B) No. C) All the above. D) None of the above. Show Answer Correct Answer: A) Yes. 60. Every time writing the formula must begin with a sign ..... A) =. B) *. C) /. D) +. Show Answer Correct Answer: A) =. ← 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