This quiz works best with JavaScript enabled. Home > Class 7 > 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 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. The feature to center text across several cells is called: A) Wrap Text. B) Merge and Center. C) Shrink to Fit. D) Number Formatting. Show Answer Correct Answer: B) Merge and Center. 2. A document consisting of several sheets in MS.Excel is called ..... A) Worksheet. B) Sheet. C) Spreadsheet. D) Workbook. Show Answer Correct Answer: D) Workbook. 3. Which function calculates the average of a given set of numbers? A) SUM(). B) Average(). C) AVG(). D) All. Show Answer Correct Answer: B) Average(). 4. In a cell reference, for example B2, what does the letter refer to? A) The row the cell is in. B) The worksheet the cell is in. C) The column the cell is in. D) The spreadsheet the cell is in. Show Answer Correct Answer: C) The column the cell is in. 5. A formula in a spreadsheet always starts with which symbol? A) (. B) =. C) +. D) /. Show Answer Correct Answer: B) =. 6. What is the keyboard shortcut to save a workbook in Excel? A) Ctrl + S. B) Ctrl + N. C) Ctrl + P. D) Ctrl + O. Show Answer Correct Answer: A) Ctrl + S. 7. How can we type special number in cell A) Using colon. B) Using apostrophe. C) Using caps lock. D) Type hulk the strongest avenger. Show Answer Correct Answer: B) Using apostrophe. 8. Which option in Excel allows you to make better decisions and create beautiful, interactive reports? A) Pivot Table. B) Pivot Chart. C) Power View. D) Sparklines. Show Answer Correct Answer: C) Power View. 9. Cells that run horizontally on a spreadsheet are know as A) Row. B) Column. C) Workbook. D) Range. Show Answer Correct Answer: A) Row. 10. What is a sheet in Excel? A) A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data. B) A single document that typically contains labels, values, formulas, functions, and graphical representations of data. C) A single file that typically contains labels, values, formulas, functions, and graphical representations of data. D) None of the above. Show Answer Correct Answer: A) A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data. 11. Which function is used to count the numeric values in a range? A) Count numbers( ). B) Count( ). C) Total ( ). D) Add( ). Show Answer Correct Answer: B) Count( ). 12. What symbol is used to divide? A) *. B) +. C) /. D) -. Show Answer Correct Answer: C) /. 13. MS EXCEL IS A SPREADSHEET PROGRAM THAT ALLOWS YOU TO ..... , ..... AND ..... INFORMATION. A) EDIT-DELETE-FORMAT. B) STORE-ORGANIZE-ANALYZE. C) PRESENT-STORE-EDIT. D) ANALYZE-FORMAT-STORE. Show Answer Correct Answer: B) STORE-ORGANIZE-ANALYZE. 14. No. of Columns in Excel 2016 A) 256. B) 16384. C) 65636. D) 16000. Show Answer Correct Answer: B) 16384. 15. A line chart is consists of a circle divided with a number of segments which represent the value of the data A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 16. The area where the writing excel formula is called ..... A) Bar menu. B) Tittle bar. C) Formula bar. D) Toolbar. Show Answer Correct Answer: C) Formula bar. 17. The predefined keywords to do mathematical calculations are A) The cell address. B) Formula. C) Functions. D) Formatting. Show Answer Correct Answer: C) Functions. 18. Which of the following is a FORMULA that will add cells c9 and c10? A) =c9+c10. B) C9+c10. C) Sum(c9:c10). D) =sum(c9:c10). Show Answer Correct Answer: A) =c9+c10. 19. When we are working with Excel, descriptions of pages, lines, columns and others can be seen on ..... A) Status Bar. B) Men's menu. C) Format Bar. D) Toolbar. Show Answer Correct Answer: A) Status Bar. 20. In MS-Excel, how many rows per sheet? A) One million forty-eight thousand four hundred seventy-six. B) One million forty-eight thousand five hundred seventy-six. C) One million forty-eight thousand six hundred seventy-six. D) One million forty-eight thousand seven hundred seventy-six. Show Answer Correct Answer: B) One million forty-eight thousand five hundred seventy-six. 21. A header is printed in the ..... margin A) Top. B) Bottom. C) Right. D) Left. Show Answer Correct Answer: A) Top. 22. Group of cells that runs horizontally. A) Column. B) Row. C) Cell. D) Cell address. Show Answer Correct Answer: B) Row. 23. No. of Rows in Excel 2016 A) 65636. B) 256. C) 1048576. D) 104856. Show Answer Correct Answer: C) 1048576. 24. This symbol must be typed first to use a formula. A) Plus Sign. B) Equal Sign. C) FX. D) Function. Show Answer Correct Answer: B) Equal Sign. 25. The following is a way that we can use to integrate Word and Excel applications, except ..... A) Cut, Copy, Paste. B) Insert Chart. C) Object Linking. D) Clipboard. Show Answer Correct Answer: D) Clipboard. ← 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