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 6 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 6 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. One way to store WordBook in Excel is to use ..... A) Ctrl+C. B) Ctrl+B. C) Ctrl+V. D) Ctrl+P. E) Ctrl+S. Show Answer Correct Answer: E) Ctrl+S. 2. What is used to C10 ..... A) Kolom S Baris 10. B) Brother Jean 10. C) Cell C. D) Baris S Kolom 10. Show Answer Correct Answer: A) Kolom S Baris 10. 3. MS Excel stands for ..... A) Micromax Excel. B) Microsoft Excess. C) Microsoft Excel. D) Management Excel. Show Answer Correct Answer: C) Microsoft Excel. 4. Excel allows you to work with? A) Sentences. B) Paragraphs. C) Data. D) None of the above. Show Answer Correct Answer: C) Data. 5. Writing the formula in Excel using the sign "=" on ..... sentence A) End. B) Back. C) Early. D) Middle. Show Answer Correct Answer: C) Early. 6. Which formula gets the biggest value of a range of cells? A) LARGE. B) SUM. C) MAX. D) MIN. Show Answer Correct Answer: C) MAX. 7. What is meant by Range 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: B) A group of several cells. 8. What is the symbol for division when using MS EXCEL. A) *. B) +. C) /. D) -. Show Answer Correct Answer: C) /. 9. Google Sheets is a desktop program. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 10. To make a diagram on PowerPoint, the command used is ..... A) Insert$\rightarrow$Picture. B) Insert$\rightarrow$Shape. C) Insert$\rightarrow$ Chart. D) Insert$\rightarrow$SmartArt. E) Insert$\rightarrow$ Table. Show Answer Correct Answer: C) Insert$\rightarrow$ Chart. 11. The tool to run the Microsoft Excel or Spreadsheet application is ..... A) Keyboard. B) Computer. C) Tv. D) Radio. Show Answer Correct Answer: B) Computer. 12. The spreadsheet worksheet section identified using the numbers 1-1048576 is called ..... A) Line. B) Column. C) Sheet. D) Cell. Show Answer Correct Answer: A) Line. 13. What alternative key is used as paste function in Excel? A) Shift. B) Tab. C) Enter. D) CTRL. Show Answer Correct Answer: C) Enter. 14. Google Sheets is free and easy to use. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 15. ..... is an international network of computers. A) Internet. B) Local Area Network. C) Network. D) WWW. Show Answer Correct Answer: A) Internet. 16. ..... is money owed to a lender (loans etc) A) Debt. B) Credit. C) Expense. D) Savings. Show Answer Correct Answer: A) Debt. 17. The function COUNTA is specific for ..... A) Counting number. B) Counting cells. C) Counting tables. D) Counting text. Show Answer Correct Answer: D) Counting text. 18. When using a formula to subtract cell B7 from cell C7 which formula is correct? LOOK closely at the answer choices! A) = (BT-Dost). B) (BNT-Tsst). C) = BTA-DOCT. D) = (BT/CNTA). Show Answer Correct Answer: A) = (BT-Dost). 19. What type of device is a computer monitor? A) Software. B) Input. C) Storage. D) Output. Show Answer Correct Answer: D) Output. 20. Data can be entered into a cell as a numeric label (used to identify or name information) by first entering which character? A) $ (dollar sign). B) ' (apostrophe). C) + (plus sign). D) :(colon). Show Answer Correct Answer: B) ' (apostrophe). 21. Excel documents are stored as files called A) Workgroup. B) Workforce. C) Worksheets. D) Worktable. Show Answer Correct Answer: C) Worksheets. 22. To add Rp.Cell can automatically use the submenu? A) Windows. B) Format cell. C) Home. D) Insert. Show Answer Correct Answer: B) Format cell. 23. Formula in MS Excel starts with ..... A) =. B) -. C) *. D) ?. Show Answer Correct Answer: A) =. 24. What do you use to create a chart? A) Excel Wizard. B) Chart Wizard. C) Data Wizard. D) Pie Wizard. Show Answer Correct Answer: B) Chart Wizard. 25. The right step is to create a new file in Ms.Excel is ..... A) File-New-Blank Workbook-Create. B) Office Button-Blank Workbook-Ok. C) Office Button-New-Create. D) File-New-Ok. Show Answer Correct Answer: A) File-New-Blank Workbook-Create. 26. The Intersection of rows and columns is known as ..... A) Header. B) Cell. C) Footer. D) Grid lines. Show Answer Correct Answer: B) Cell. 27. ..... controls the overall activities of a computer. A) Output. B) Presentation. C) Input. D) Operating system. Show Answer Correct Answer: D) Operating system. 28. In Excel, the heading "boxes" going from top to bottom are called ..... A) Rows. B) Numbers. C) Columns. D) Headers. Show Answer Correct Answer: A) Rows. 29. The name of the cell located at the intersection of column F and row 223 is: A) Superior. B) Lucid. C) Scare. D) Scatter. Show Answer Correct Answer: B) Lucid. 30. Every MS Excel function starts with a A) Bracket. B) Number. C) Equal =. D) Letter. Show Answer Correct Answer: C) Equal =. 31. The default file extension of an excel file is A) .xlsx. B) .xslx. C) .LSX. D) .xls. Show Answer Correct Answer: A) .xlsx. 32. An Excel file/Google sheet that contains individual worksheets. Also called a spreadsheet file. A) File. B) Workbook. C) Headings. D) Drag. Show Answer Correct Answer: B) Workbook. 33. What application can you use to create letters and reports? A) PowerPoint. B) Excel. C) Outlook. D) Word. Show Answer Correct Answer: D) Word. 34. Having a good credit score helps you save money on loan interest rates A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 35. What is the green bar at the top of Excel referred to as? A) The function bar. B) The data bar. C) The ribbon. D) The row. Show Answer Correct Answer: C) The ribbon. 36. Devices on a computer that is physical (touched) and function well because of the software as a system that runs it, called ..... A) Flash Disk. B) Hard Disk. C) Hardware. D) Software. E) Touch Pad. Show Answer Correct Answer: C) Hardware. 37. A formula in Excel always begins with an ..... A) Space. B) Equal sign. C) Comma. D) Colon. Show Answer Correct Answer: B) Equal sign. 38. ..... is a area that holds all the elements of a chart. A) Chart Title. B) Legends. C) Plot Area. D) Chart Area. Show Answer Correct Answer: D) Chart Area. 39. There are three worksheets with every new workbook. You can change that automatic number if you want to A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 40. EVERY WORKSHEET IS DIVIDED INTO ..... AND ..... A) WORKSHEETS-WORKBOOKS. B) TABS-GROUPS. C) FOLDERS-FILES. D) COLUMNS-ROWS. Show Answer Correct Answer: D) COLUMNS-ROWS. 41. Combination of column letter and row number that identifies a cell. A) Cell Address. B) Cell Range. C) All the above. D) None of the above. Show Answer Correct Answer: A) Cell Address. 42. David only wants to view the employees in the Marketing department who earn a salary of more than $ 25, 000. What command should he use to complete this task? A) Autofill. B) Filter. C) Find and Replace. D) Sort. Show Answer Correct Answer: B) Filter. 43. You can use the spreadsheet for:Analyze information and produce graphs. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 44. C1:C10 represents a ..... A) Formula. B) Calculation. C) Range. D) None of the above. Show Answer Correct Answer: C) Range. 45. Which one is not a Function in MS Excel? A) AVG. B) MIN. C) SUM. D) MAX. Show Answer Correct Answer: A) AVG. 46. The spreadsheet can be used by? A) Finance Professionals. B) Engineers. C) Stock Brokers. D) All the above. Show Answer Correct Answer: D) All the above. 47. Comparative operators on MS-Excel that say they are not the same as ..... A) Not. B) <>. C) ><. D) =/. Show Answer Correct Answer: B) <>. 48. To make more filling, what is clicked is ..... A) Manual Table. B) Table Random. C) Insert. D) Paste. Show Answer Correct Answer: A) Manual Table. 49. C4 cells contain 90, D4 cells contain 80 then the right formula to calculate the average and correct results is ..... A) =(C4+D4)/2; hasil 85. B) = (95+80):2;Results 85. C) =average(95 80); hasil 85. D) =C4+(D4/2); hasil 170. E) =C4+D4/2; hasil 85. Show Answer Correct Answer: A) =(C4+D4)/2; hasil 85. 50. Below that is not a number processing software (spreadsheet) is ..... A) Open Office. B) Star Office. C) Lotus 1-2-3. D) Microsoft Outlook. E) Microsoft Exel. Show Answer Correct Answer: D) Microsoft Outlook. 51. How are rows designated? A) Circles. B) Letters. C) Numbers. D) Stars. Show Answer Correct Answer: C) Numbers. 52. A group of neighboring cells that touch each other is called ..... A) Autifill. B) Range of Cells. C) Neibhouring cells. D) None of the above. Show Answer Correct Answer: B) Range of Cells. 53. Two or more cells in the sheet are often referred to as ..... A) Workbook. B) Worksheet. C) Range. D) Sheet. E) Sel. Show Answer Correct Answer: C) Range. 54. Which is a formula using MS Excel using addition. A) 2 + 3 =. B) AA+. C) = A+sold. D) = A + B. Show Answer Correct Answer: C) = A+sold. 55. A vertical line of cells A) Column. B) Minimum. C) Maximum. D) Formulas. Show Answer Correct Answer: A) Column. 56. Excel refers to files as A) Documents. B) Workbooks. C) Data bases. D) None of the above. Show Answer Correct Answer: B) Workbooks. 57. The extension of MS Excel file: A) .bitmap. B) .xlsx. C) .jpeg. D) .doc. Show Answer Correct Answer: B) .xlsx. 58. The right way to activate MS-Excel is ..... A) Start-program-ms office-ms word. B) Star-program-ms office-ms excel. C) Ms excel-start-program-ms office. D) Program-ms excel-start-ms office. Show Answer Correct Answer: B) Star-program-ms office-ms excel. 59. MS Excel is a ..... software. A) Worksheet. B) Spreadsheet. C) All the above. D) None of the above. Show Answer Correct Answer: B) Spreadsheet. 60. Cell value changes as the formula is copied A) Relative Reference. B) Absolute Reference. C) Mixed Reference. D) None of the above. Show Answer Correct Answer: A) Relative Reference. ← 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 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