This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 4 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 4 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. The application used to create a presentation is A) Microsoft Word. B) Microsoft Excel. C) Microsoft Powerpoint. D) Microsoft Visio. Show Answer Correct Answer: C) Microsoft Powerpoint. 2. The horizontal line on a graph A) Range. B) X-axis. C) Chart. D) Y-axis. Show Answer Correct Answer: B) X-axis. 3. Microsoft word is ..... software. A) Application. B) Compiler. C) System. D) Programming. Show Answer Correct Answer: A) Application. 4. What does a spreadsheet contains? A) Columns. B) Rows. C) Cells. D) All of these. Show Answer Correct Answer: D) All of these. 5. When we Get Backstage View A) By Clicking File Ribbon. B) By Clicking Home Ribbon. C) By Clicking Format Option. D) All of the above. Show Answer Correct Answer: A) By Clicking File Ribbon. 6. The cell reference for cell range of G2 to M12 is ..... A) G2.M12. B) G2;M12. C) G2:M12. D) G2-M12. Show Answer Correct Answer: C) G2:M12. 7. Rows go in what directions? A) Vertical. B) Horizontal. C) All the above. D) None of the above. Show Answer Correct Answer: B) Horizontal. 8. The funds left over after you pay all of your expenses is call ..... A) Savings. B) Debt. C) Income. D) Loan. Show Answer Correct Answer: A) Savings. 9. To lock the column and row is a function of A) Max. B) Average. C) SUM. D) Absolute. Show Answer Correct Answer: D) Absolute. 10. What function will result in the total number of entries in the cell range B5 to B14? A) COUNT. B) MAX. C) MIN. D) SUM. Show Answer Correct Answer: A) COUNT. 11. Which of the following will displays the contents of active cell? A) Name box. B) Formula bar. C) Bar menu. D) Status bar. Show Answer Correct Answer: B) Formula bar. 12. What is the shortcut to enable filtering of selected cells in MS Excel? A) Ctrl + F. B) Alt + Click + L. C) Ctrl + Shift + L. D) Shift + F. Show Answer Correct Answer: C) Ctrl + Shift + L. 13. When the highest value is at the top of the list. Also called Z to A order. A) Numbers. B) Merge. C) Filtering. D) Descending order. Show Answer Correct Answer: D) Descending order. 14. Microsoft Excel is an application ..... A) Spreadsheet. B) Presentation. C) Word Processing. D) Programming. Show Answer Correct Answer: A) Spreadsheet. 15. Through which method we can communicate with another person, both verbally and visually? A) Audio Conferencing. B) Video Conferencing. C) Chatting App. D) None of the above. Show Answer Correct Answer: B) Video Conferencing. 16. The order used to cancel the ordered order is A) Undo. B) Redo. C) Cut. D) Copy. Show Answer Correct Answer: A) Undo. 17. When creating a chart in Excel, what is the first thing you need to do? A) Select the data to be graphed. B) Select the Insert Tab. C) Choose a chart from the ribbon. D) Double click the active cell. Show Answer Correct Answer: A) Select the data to be graphed. 18. One example of an application is A) Windows. B) Unix. C) Power Point. D) Linux. Show Answer Correct Answer: C) Power Point. 19. To insert a new worksheet, press ..... key. A) Ctrl + S. B) Shift + F11. C) ALT + F4. D) Shift + F5. Show Answer Correct Answer: B) Shift + F11. 20. Words in the spreadsheets are called ..... A) Labels. B) Values. C) All the above. D) None of the above. Show Answer Correct Answer: A) Labels. 21. One of the number processing application programs is ..... A) Microsoft Word. B) Microsoft Excel. C) Microsoft Power Point. D) Paint. Show Answer Correct Answer: B) Microsoft Excel. 22. A column is represented by numbers. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 23. Use to create, edit, and manage 2D images. A) Graphic design and editing software. B) File Management Software. C) Desktop Publishing Software. D) None of the above. Show Answer Correct Answer: A) Graphic design and editing software. 24. Consider the following data:1) Type the name range in name box2) Block range that will be named 3) Enter The following are the steps to give the correct range name is ..... A) 2-1-3. B) 1-2-3. C) 3-2-1. D) 1-3-2. Show Answer Correct Answer: A) 2-1-3. 25. The name box contains A) Formula. B) Menu option. C) Cell address. D) Numbers. Show Answer Correct Answer: C) Cell address. ← 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 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 10Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books