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 16 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 16 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Intersections of rows and column A) Box. B) Cell. C) All the above. D) None of the above. Show Answer Correct Answer: B) Cell. 2. Which symbol means to multiply? A) SUM. B) /. C) ( ). D) *. Show Answer Correct Answer: D) *. 3. In the formula =MAX(G4:G19), the cell references are an example of which term? A) Value. B) Label. C) Range. D) Numeric label. Show Answer Correct Answer: C) Range. 4. By default, the Excel workbook contains: A) 5 worksheets. B) 4 worksheets. C) 3 worksheets. D) 2 worksheets. Show Answer Correct Answer: C) 3 worksheets. 5. Total Income amount of money received before taxes A) Net Income. B) Gross Income. C) Savings. D) Income. Show Answer Correct Answer: B) Gross Income. 6. The following is an office application, except ..... A) Google Docs. B) Ms power point. C) Adobe Reader. D) Ms excell. E) Ms word. Show Answer Correct Answer: C) Adobe Reader. 7. What is meant by cells (cells) in Excel? A) Group from worksheets. B) A group of several cells. C) Meeting between rows and columns. D) Meeting between cells and range. Show Answer Correct Answer: C) Meeting between rows and columns. 8. Below that is not a number processing application program is ..... A) Microsoft Excel. B) Lotus 123. C) Open Office Calc. D) Star Office Writer. Show Answer Correct Answer: D) Star Office Writer. 9. Ctrl+P is a Shortcut Key works to feature A) Customize. B) Heater. C) Print. D) Page setup. Show Answer Correct Answer: C) Print. 10. The process of reverse calculation to achieve a desired result by using a single variable and a single cell. A) Goal Seek. B) Solver. C) Scenario manager. D) Data Table. Show Answer Correct Answer: A) Goal Seek. 11. What is the name of the first cell of a spreadsheet? A) AA. B) Aa. C) B1. D) A1. Show Answer Correct Answer: D) A1. 12. The ..... is your workspace. A) Icons. B) Desktop. C) Start Menu. D) Taskbar. Show Answer Correct Answer: B) Desktop. 13. Individual locations on a spreadsheet. A) Spreadsheet. B) Cell. C) Entry. D) Workbook. Show Answer Correct Answer: B) Cell. 14. Each rectangular grid in a spreadsheet is a A) Sheet tab. B) Work sheet. C) Cell. D) None of the above. Show Answer Correct Answer: C) Cell. 15. Letters across the top, run vertically and from top to bottom A) Row. B) Column. C) Cell. D) None of the above. Show Answer Correct Answer: B) Column. 16. What is the last argument for the MATCH function? A) Lookup value. B) Lookup array. C) Match type. D) Area num. Show Answer Correct Answer: C) Match type. 17. ..... displays the contents of active cell. A) Alignment bar. B) Formula bar. C) Address bar. D) Tool bar. Show Answer Correct Answer: B) Formula bar. 18. Signs of the star (*) is a symbol in ..... A) Reduction. B) Multiplication. C) Distribution. D) Addition. Show Answer Correct Answer: B) Multiplication. 19. Select the correct example of a cell address: A) Brother. B) 901. C) 98A. D) 3611. Show Answer Correct Answer: A) Brother. 20. The site which is the biggest online encyclopedia in the world is ..... A) Wikipedia. B) Web Hosting. C) Blogger. D) Google. Show Answer Correct Answer: A) Wikipedia. 21. To format numbers using accounting rules is ..... A) Accounting. B) Percent. C) Number. D) General. E) Currency. Show Answer Correct Answer: A) Accounting. 22. Numeric data is composed of numbers that can add, subtract, multiply, divide and use of formulas A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 23. Numeric data used in calculations is called ..... A) Numeric. B) Value. C) Formula. D) Text. Show Answer Correct Answer: B) Value. 24. The following are the calculation operations used in Microsoft Office, except A) :. B) +. C) -. D) *. Show Answer Correct Answer: A) :. 25. The following is the address of the cell, namely ..... A) 84. B) BB. C) Pardon. D) B5. Show Answer Correct Answer: D) B5. 26. The function of the home button is ..... A) Rolling one screen up. B) Pindah satu sel ke bawah. C) Move to Cell A1. D) Rolling one sentence down. E) Move to column A. Show Answer Correct Answer: E) Move to column A. 27. Collection of commands in Excel consisting of several menu tabs and each tab consists of command buttons in a particular group called A) Title bar. B) Ribbon. C) Control Box. D) Men's menu. Show Answer Correct Answer: B) Ribbon. 28. Numeric processing applications that require small memory, namely ..... A) Abacus. B) Xxl. C) WingZ. D) Gnumeric. Show Answer Correct Answer: A) Abacus. 29. Once you have a bad credit score, you can never improve it A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 30. Google Sheets and MS Excel are similar in many ways. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 31. 27-Spreadsheets (Excel) are used by Teachers to calculate marks and grades. A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: A) TRUE. 32. To combine several cells using commands ..... A) Split Cell. B) Wrap Text. C) Orientation. D) Merge & Center. Show Answer Correct Answer: D) Merge & Center. 33. A single page in Excel is called a: A) Worksheet. B) Workbook. C) Spreadsheet. D) None of the above. Show Answer Correct Answer: A) Worksheet. 34. To collaborate on working on Excel online on Google, the application used is ..... A) Google drive. B) Google document. C) Google spreadsheet. D) Google groups. Show Answer Correct Answer: C) Google spreadsheet. 35. The function COUNTA is used for counting cells that contain A) Numbers and logical values only. B) Text, numbers and logical values only. C) Text, numbers, logical values and error values only. D) Text, numbers, logical values, error values, and empty text (" "). Show Answer Correct Answer: D) Text, numbers, logical values, error values, and empty text (" "). 36. What is the correct order for the parts that make up a Cell Reference? A) Letter then Number. B) Number then Letter. C) All the above. D) None of the above. Show Answer Correct Answer: A) Letter then Number. 37. What function was used to find the highest data? A) MAX. B) AVERAGE. C) MIN. D) SUM. Show Answer Correct Answer: A) MAX. 38. What is the extension of spreadsheet? A) .xls. B) .doc. C) .html. D) .pptx. Show Answer Correct Answer: A) .xls. 39. The Filter function icon can be found in ..... tab. A) Home. B) Data. C) Insert. D) View. Show Answer Correct Answer: B) Data. 40. Consider the following statement! (1) Microsoft Word (2) Microsoft Excel (3) Microsoft Power Point (4) Open Office Calcprogram The number processing application from the statement above is ..... A) , (3). B) , (4). C) , (2). D) , (4). E) , (4). Show Answer Correct Answer: B) , (4). 41. Under which tab on the Excel 2016 Ribbon will you find the Spelling checker option? A) Under the Formulas tab. B) Under the View tab. C) Under the Data tab. D) Under the Review tab. Show Answer Correct Answer: D) Under the Review tab. 42. ..... appear at the bottom of the Excel window. A) Name box. B) Work sheet tabs. C) Formula bar. D) Title bar. Show Answer Correct Answer: B) Work sheet tabs. 43. Which component of MS Excel displays the address of the active cell? A) Column header. B) Row header. C) Formula bar. D) Name box. Show Answer Correct Answer: D) Name box. 44. The function used to calculate the biggest value of the number data A) Sum. B) Max. C) Min. D) Average. Show Answer Correct Answer: B) Max. 45. The type of a networking specific to only users of an organization is called A) Infranet. B) Internet. C) Intranet. D) Net and net. Show Answer Correct Answer: C) Intranet. 46. Internet stands for? A) International Network. B) Internet Network. C) Internet Net. D) Internet Networknet. Show Answer Correct Answer: A) International Network. 47. Concatenation (joins text) A) /. B) &. C) *. D) None of the above. Show Answer Correct Answer: B) &. 48. MS-Excel-2013 Having ..... Rows & ..... Column A) 10, 48, 576 & 16, 384. B) 10, 16, 384 & 10, 48, 576. C) 10, 38, 586 & 16, 383. D) None of the above. Show Answer Correct Answer: A) 10, 48, 576 & 16, 384. 49. Can you enter images into Google Sheets? A) Can. B) Can't. C) All the above. D) None of the above. Show Answer Correct Answer: A) Can. 50. The intersection of a column and row is a A) Insertion Point. B) Cell. C) Connection Point. D) Box. Show Answer Correct Answer: B) Cell. 51. EACH TAB IS DIVIVDED INTO NUMBER OF SECTIONS CALLED ..... A) BUTTONS. B) GROUPS. C) FILES. D) RIBBON. Show Answer Correct Answer: B) GROUPS. 52. Error in your formula A) #name?. B) Autofill. C) Columns. D) #div/0!. Show Answer Correct Answer: A) #name?. 53. What kind of software is Excel? A) Word processing software. B) Spreadsheet Software. C) Data Base Software. D) None of the above. Show Answer Correct Answer: B) Spreadsheet Software. 54. Typed text showed in active cell and also in ..... A) Ribbon. B) Formula Bar. C) Title Bar. D) Scroll Bar. Show Answer Correct Answer: B) Formula Bar. 55. Benefits of ICT? A) Effectiveness & efficiency. B) Type. C) Fashion. D) Join the trend. Show Answer Correct Answer: A) Effectiveness & efficiency. 56. The basic unit of a worksheet into which you enter data in Excel is called a A) Column. B) Box. C) Cell. D) Table. Show Answer Correct Answer: C) Cell. 57. What do we call the horizontal line of cells labeled using numbers? A) Horizontal. B) Rows. C) Column. D) None of the above. Show Answer Correct Answer: B) Rows. 58. In Excel, F12 key is used for A) SAVE. B) OPEN. C) CLOSE. D) RENAME. Show Answer Correct Answer: A) SAVE. 59. If I want to find an average of cells A1 through A25, which formula would I use? A) =average(A1-A25). B) =avg(A1:A25). C) =avg(A1-A25). D) =average(A1:A25). Show Answer Correct Answer: D) =average(A1:A25). 60. What is the column header name for 14th Column A) E. B) D. C) N. D) X. Show Answer Correct Answer: C) N. ← 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