This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 51 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 51 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the shortcut key to hide entire column? A) CTRL +-. B) CTRL + 0. C) CTRL + H. D) CTRL + C. Show Answer Correct Answer: B) CTRL + 0. 2. When we want to lock in capital letters, then the pressed button is ..... A) Tab. B) Shift. C) Ctrl. D) Capslock. E) Numlock. Show Answer Correct Answer: D) Capslock. 3. A spreadsheet software developed by Microsoft. A) MS Excel. B) MS Word. C) MS PowerPoint. D) None of the above. Show Answer Correct Answer: A) MS Excel. 4. ..... is a rectangular area where a column and row intersect. A) Cell. B) Column. C) Row. D) Sheet tab. Show Answer Correct Answer: A) Cell. 5. What is the output of the function =if(A1=A2, "Unequal", "Equal") when A1=10 A2 = 11 A) Equal. B) Unequal. C) Error. D) None of these. Show Answer Correct Answer: A) Equal. 6. What symbol is used for multiplication (times)? A) *. B) /. C) +. D) -. Show Answer Correct Answer: A) *. 7. 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. 8. Task view button is available on the ..... A) Icons. B) Start menu. C) Taskbar. D) Notification Area. Show Answer Correct Answer: C) Taskbar. 9. In the format cell currency or currency to replace the symbol is on ..... A) Symbol. B) Region. C) Decimal. D) Category. Show Answer Correct Answer: A) Symbol. 10. Legends are added at the ..... of a chart by default. A) Top. B) Bottom. C) Middle. D) Right. Show Answer Correct Answer: B) Bottom. 11. The third process in making mail merge is ..... A) The process of choosing a data source. B) The process of making data sources. C) The process of choosing a master document. D) The process of making master documents. Show Answer Correct Answer: A) The process of choosing a data source. 12. Intial Name of the electronic spreadsheet is A) Lotus 123. B) Faces Calc. C) Multi plan. D) E Calculator. Show Answer Correct Answer: B) Faces Calc. 13. What function Is used to find the highest data? A) SUM. B) MIN. C) MAX. D) AVERAGE. Show Answer Correct Answer: C) MAX. 14. 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. 15. To thicken letters can be done by pressing the icon A) Bold. B) Italic. C) Under line. D) Aligment. E) Font Size. Show Answer Correct Answer: A) Bold. 16. A Column goes ..... A) Across. B) Down. C) Cross. D) None of the above. Show Answer Correct Answer: B) Down. 17. The cell in your worksheet that has been selected. It will have bolder gridlines around it. A) Active Cell. B) Formula. C) Cell. D) Cell address. Show Answer Correct Answer: A) Active Cell. 18. Under which tab in PowerPoint can you add a image? A) Design. B) File. C) Format. D) Insert. Show Answer Correct Answer: D) Insert. 19. 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. 20. Displays the name or location of the active cell A) Formula bar. B) Name box. C) Column. D) Row. Show Answer Correct Answer: B) Name box. 21. ..... type of chart is good for a single series of data. A) Column chart. B) Cone chart. C) Line chart. D) Pie chart. Show Answer Correct Answer: D) Pie chart. 22. 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. 23. 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. 24. MS Excel column width can accommodate up to how many characters? A) 355. B) 255. C) 555. D) 235. Show Answer Correct Answer: B) 255. 25. The command to save data using the correct keyboard combination button is ..... A) Office Button-Save As. B) Ctrl + S. C) File-Save. D) ALT + S. E) F12. Show Answer Correct Answer: B) Ctrl + S. ← PreviousNext →Related 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 8Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 9Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books