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 21 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 21 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What symbol is used for multiplication (times)? A) +. B) -. C) *. D) /. Show Answer Correct Answer: C) *. 2. Distribute 10 dirhams between 2 kids. How much money each will get? A) 5. B) 10. C) All the above. D) None of the above. Show Answer Correct Answer: A) 5. 3. Task view button is available on the ..... A) Icons. B) Start menu. C) Notification Area. D) Taskbar. Show Answer Correct Answer: D) Taskbar. 4. In the format cell currency or currency to replace the symbol is on ..... A) Symbol. B) Category. C) Decimal. D) Region. Show Answer Correct Answer: A) Symbol. 5. Legends are added at the ..... of a chart by default. A) Right. B) Top. C) Bottom. D) Middle. Show Answer Correct Answer: C) Bottom. 6. Intial Name of the electronic spreadsheet is A) E Calculator. B) Lotus 123. C) Multi plan. D) Faces Calc. Show Answer Correct Answer: D) Faces Calc. 7. What function Is used to find the highest data? A) MAX. B) SUM. C) AVERAGE. D) MIN. Show Answer Correct Answer: A) MAX. 8. The sum( ) function is present under the ..... function category. A) Logical. B) Financial. C) Text. D) Maths and Trig. Show Answer Correct Answer: D) Maths and Trig. 9. To thicken letters can be done by pressing the icon A) Bold. B) Aligment. C) Under line. D) Font Size. E) Italic. Show Answer Correct Answer: A) Bold. 10. A Column goes ..... A) Across. B) Down. C) Cross. D) None of the above. Show Answer Correct Answer: B) Down. 11. The cell in your worksheet that has been selected. It will have bolder gridlines around it. A) Cell. B) Cell address. C) Active Cell. D) Formula. Show Answer Correct Answer: C) Active Cell. 12. Under which tab in PowerPoint can you add a image? A) Design. B) Insert. C) Format. D) File. Show Answer Correct Answer: B) Insert. 13. An Excel spreadsheet is primarily used for calculating which of the following options A) Data. B) Finances. C) Numbers. D) All of the above. Show Answer Correct Answer: D) All of the above. 14. Displays the name or location of the active cell A) Row. B) Column. C) Name box. D) Formula bar. Show Answer Correct Answer: C) Name box. 15. ..... type of chart is good for a single series of data. A) Line chart. B) Column chart. C) Pie chart. D) Cone chart. Show Answer Correct Answer: C) Pie chart. 16. 26-We cannot change the cell colour in the sheet A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: B) FALSE. 17. Which of the following language does the computer understand? A) Computer understands only C Language. B) Computer understands only Assembly Language. C) Computer understands only Binary Language. D) Computer understands only BASIC. Show Answer Correct Answer: C) Computer understands only Binary Language. 18. MS Excel column width can accommodate up to how many characters? A) 355. B) 555. C) 235. D) 255. Show Answer Correct Answer: D) 255. 19. The command to save data using the correct keyboard combination button is ..... A) Office Button-Save As. B) Ctrl + S. C) ALT + S. D) File-Save. E) F12. Show Answer Correct Answer: B) Ctrl + S. 20. These are programs that use multimedia sources. A) Multimedia software. B) Hypermedia. C) Interactive media. D) None of the above. Show Answer Correct Answer: A) Multimedia software. 21. Which feature automatically fills in values? A) Paste. B) Wrap Text. C) Merge and Center. D) Autofill. Show Answer Correct Answer: D) Autofill. 22. Which is included in the number processing program ..... A) Open Office Writer. B) Open Office Calc. C) MS. Word. D) Lotus Word Pro. Show Answer Correct Answer: B) Open Office Calc. 23. Completes previously typed words when you begin to repeat the typing. A) Column charts. B) #Name?. C) Pie Charts. D) Autofill. Show Answer Correct Answer: D) Autofill. 24. The numbers in Excel represent the ..... A) Cells. B) Data. C) Rows. D) Columns. Show Answer Correct Answer: C) Rows. 25. Worksheet of the MS.Power Point application is called ..... A) Page. B) Design. C) Slide. D) Layout. Show Answer Correct Answer: C) Slide. 26. The menu used to view the display before print is A) Print preview. B) Printer. C) Print. D) Copy. E) Paste. Show Answer Correct Answer: A) Print preview. 27. Who created Gmail first? A) Paul. B) Paul Buchet. C) Poul Buchht. D) None of the above. Show Answer Correct Answer: A) Paul. 28. Use to organize data in rows and columns in a worksheet. A) Spreadsheet software. B) Word and data processing software. C) Presentation software. D) None of the above. Show Answer Correct Answer: A) Spreadsheet software. 29. Which formula would you use to add all the cells from D4 to D12? A) =sum(D4*D12). B) =sum(D4+12). C) =sum(D4:D12). D) = (D4:D12). Show Answer Correct Answer: C) =sum(D4:D12). 30. We must ..... data to do operations on it. A) Select. B) Click. C) All the above. D) None of the above. Show Answer Correct Answer: A) Select. 31. MODEM stands for? A) Modulator Demodulator. B) Modulator DEModulation. C) Modulator DEModel. D) None of the above. Show Answer Correct Answer: A) Modulator Demodulator. 32. What is the default file name of Microsoft Excel file? A) Workbook.xlsx. B) Workbook1.xlsx. C) Worksheet.xlsx. D) Worksheet1.xlsx. Show Answer Correct Answer: B) Workbook1.xlsx. 33. Which options are used to move data from one place to another. A) Copy and Paste. B) Cut and Paste. C) All the above. D) None of the above. Show Answer Correct Answer: B) Cut and Paste. 34. The process of reverse calculation to achieve a desired result by using multiple variables. A) Goal seek. B) Solver. C) Data Table. D) What-if-analysis. Show Answer Correct Answer: B) Solver. 35. Cells that run vertically on a spreadsheet A) Column. B) Workbook. C) Row. D) Worksheet. Show Answer Correct Answer: A) Column. 36. Which is included in the input device, namely ..... A) CPU/processor. B) Printer. C) Hard drive. D) Keyboard. E) Power supply. Show Answer Correct Answer: D) Keyboard. 37. How many worksheets are contained in a new blank workbook? A) 4. B) 3. C) 1. D) 2. Show Answer Correct Answer: C) 1. 38. The advantage of using MS Excel is ..... A) Accurate calculation results. B) Do the calculation quickly. C) Improve and compile data quickly. D) All wrong. E) Everything is true. Show Answer Correct Answer: E) Everything is true. 39. Document that stores data in a grid of horizontal and vertical columns. Data can be used and calculated. A) Formula. B) Spreadsheet. C) Row. D) Active cell. Show Answer Correct Answer: B) Spreadsheet. 40. Screen display after the computer is perfectly called ..... A) Wallpaper. B) Background. C) Desktop. D) Screensaver. E) Quicklaunch. Show Answer Correct Answer: C) Desktop. 41. The squares are called? A) Excel. B) Cells. C) Active cells. D) None of the above. Show Answer Correct Answer: B) Cells. 42. Input devices that are useful for moving pointer on the monitor screen with a pointer that is moved based on the touch of a finger in a particular area is called ..... A) Mouse. B) Trackball. C) Mouse pad. D) Touch screen. E) Touchpad. Show Answer Correct Answer: E) Touchpad. 43. Which of the following best describes a website A) A collection of webpages relating to the one organisation. B) Any webpage. C) A collection of webpages. D) Anything viewed through the browser. Show Answer Correct Answer: A) A collection of webpages relating to the one organisation. 44. The average function on Microsoft Excel is ..... A) Determine the sum value. B) Determine the middle value. C) Determine the average value. D) Add up all data. Show Answer Correct Answer: C) Determine the average value. 45. The positive impact of social media today ..... A) Make it possible to ridicule each other through whatsapp. B) Can be committed various crimes. C) Easy to convey information. D) Easy-to-bulk. Show Answer Correct Answer: C) Easy to convey information. 46. A, AZ, BS, CR are the examples of ..... A) Row address. B) Column address. C) Home address. D) None of the above. Show Answer Correct Answer: B) Column address. 47. What symbol should be used to perform a division calculation? A) -. B) /. C) +. D) *. Show Answer Correct Answer: B) /. 48. Horizontal boxes in Excel are called ..... A) Line. B) Number. C) Column. D) Table. Show Answer Correct Answer: C) Column. 49. Which one is the search engine in internet A) Archie. B) WAIS. C) Speaker. D) Google. Show Answer Correct Answer: A) Archie. 50. To disable a toolbar you can ..... click on the taskbar. A) Left. B) Right. C) Centre. D) Both. Show Answer Correct Answer: B) Right. 51. A range is a group of contiguous cells, which form the shape of a ..... A) Sphere. B) Rectangle. C) Circle. D) Square. Show Answer Correct Answer: B) Rectangle. 52. What is the purpose of accepting/rejecting changes in a shared spreadsheet? A) To print the spreadsheet. B) To apply the changes permanently. C) To undo the changes made. D) To share the spreadsheet with others. Show Answer Correct Answer: B) To apply the changes permanently. 53. The first workbook opened in ms excel is named as ..... A) Book 1.xlsx. B) Sheet 1. C) Ironman. D) None of the above. Show Answer Correct Answer: A) Book 1.xlsx. 54. The name box or the address bar contains A) Cell address. B) Numbers. C) Formulas. D) Menu options. Show Answer Correct Answer: A) Cell address. 55. Which of the following keyboard shortcuts is used 'Autosum', a quick and easy way of adding multiple values? A) Alt + =. B) Ctrl + 1. C) Tab + =. D) Ctrl + =. E) Shift + =. Show Answer Correct Answer: A) Alt + =. 56. ..... is a database management system. A) MS OneNote. B) MS Excel. C) MS Access. D) MS Word. Show Answer Correct Answer: C) MS Access. 57. What symbol is used to multiply? A) /. B) -. C) +. D) *. Show Answer Correct Answer: D) *. 58. Which button is pressed to accept every change that has been made in the worksheet? A) Accept. B) Accept all. C) Accept Changes. D) Accepted. Show Answer Correct Answer: B) Accept all. 59. We can find Save, Open, and Close tools in the intercourse ..... A) Review. B) Insert. C) Home. D) File. Show Answer Correct Answer: D) File. 60. Randy decides to make a cake, all he need is 2 cups of sugar and 5 spoons of milk. What is the ratio of Milk to sugar A) 2/5. B) 2:7. C) 5/2. D) None of the above. Show Answer Correct Answer: C) 5/2. ← 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