This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 61 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 61 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the first thing you have to do in a spreadsheet before you can create a chart/graph? A) Click insert charts/graphs. B) Go to file, print. C) Highlight the data with your mouse. D) Bold all the information. Show Answer Correct Answer: C) Highlight the data with your mouse. 2. What does every formula in MS EXCEL start with? A) +. B) -. C) =. D) *. Show Answer Correct Answer: C) =. 3. In the spreadsheet, the meeting between the row and the column is called ..... A) Line. B) Column. C) Sel. D) Range. Show Answer Correct Answer: C) Sel. 4. This function adds the range of cells A) =SUM( ). B) =AVERAGE( ). C) =MAX( ). D) =MIN( ). Show Answer Correct Answer: A) =SUM( ). 5. Excel file. A) Worksheet. B) Range. C) Spreadsheet. D) Workbook. Show Answer Correct Answer: D) Workbook. 6. 2 or more cells that are selected to create a source to be used in a formula A) Range. B) Max. C) Filter. D) Colums. Show Answer Correct Answer: A) Range. 7. What is a vertical group of cells identified by letters in Excel? A) Cells. B) Name Box. C) Row. D) Column. Show Answer Correct Answer: D) Column. 8. Which of the following is an example of page orientation? A) Landscape. B) Subscript. C) Superscript. D) Rivet. Show Answer Correct Answer: A) Landscape. 9. Used to compare two or more conditions to produce true/false value is a function of ..... A) Text. B) Lookup. C) OR. D) AND. Show Answer Correct Answer: C) OR. 10. We can add or modify the chart elements by using ..... button present in the Chart Layout group. A) Quick Layout. B) Add chat Element. C) Select data. D) Change data. Show Answer Correct Answer: B) Add chat Element. 11. What is meant by the integration of office application content? A) Combine applications with games. B) Linking data or features between applications. C) Create a new application. D) Delete unused applications. Show Answer Correct Answer: B) Linking data or features between applications. 12. Currently selected cell in which cell pointer lies is called ..... A) Cell Pointer. B) Active Cell. C) All the above. D) None of the above. Show Answer Correct Answer: B) Active Cell. 13. All the formulas and functions in MS Excel must be with this sign A) @. B) #. C) =. D) None of the above. Show Answer Correct Answer: C) =. 14. A cell's location is expressed by its column letter and row number such as A1. A) Name box. B) Formula bar. C) Cell address. D) None of the above. Show Answer Correct Answer: C) Cell address. 15. File extension from Ms. documentExcel is ..... A) . docx. B) . xlsx. C) .pptx. D) . pdf. Show Answer Correct Answer: B) . xlsx. 16. Excel Function on average uses a formula ..... A) SUM. B) MAX. C) AVERAGE. D) MIN. Show Answer Correct Answer: C) AVERAGE. 17. Contains the name of the application and the document name. A) Title Bar. B) Bar menu. C) Tool Bar. D) Name Box. Show Answer Correct Answer: A) Title Bar. 18. Columns are identified by what? A) Letters of the alphabet. B) Numbers. C) Roman numerals. D) None of the above. Show Answer Correct Answer: A) Letters of the alphabet. 19. Ms.Word works to be ..... A) Mail Merge. B) Master document. C) Data source. D) All answers are correct. Show Answer Correct Answer: B) Master document. 20. Order to store the first data made called ..... A) Save. B) Print. C) Quit. D) Save As. E) Format. Show Answer Correct Answer: D) Save As. 21. Which symbol is used to start a formula in Excel? A) =. B) +. C) @. D) #. Show Answer Correct Answer: A) =. 22. The number of columns and rows in Microsoft Office Excel 2007 is A) 16, 383 and 1, 048, 567. B) 16, 384 and 1, 048, 576. C) 16, 385 and 1, 048, 579. D) 16, 386 and 1, 048, 567. Show Answer Correct Answer: B) 16, 384 and 1, 048, 576. 23. In a worksheet, there are ..... rows. A) 16384. B) 104850. C) 1048576. D) None of the above. Show Answer Correct Answer: C) 1048576. 24. 18 ..... is used to move to the beginning of current row. A) Home key. B) End key. C) Up arrow. D) Down arrow. Show Answer Correct Answer: A) Home key. 25. Spreadsheet is a program ..... A) Microsoft Excel. B) Microsoft PowerPoint. C) Microsoft Acces. D) Microsoft Publisher. E) Microsoft Word. Show Answer Correct Answer: A) Microsoft Excel. ← 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