This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 24 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 24 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Sorting data in Excel based on the cell title category using ..... A) Find & Select. B) Autoosum. C) Fill. D) Sort & Filter. Show Answer Correct Answer: D) Sort & Filter. 2. One of the advanced features in Ms.Excel that can be used to find commands only by typing the command name or command is ..... A) Search. B) Tell me what you want to do. C) Smart Look Up. D) Ribbon. Show Answer Correct Answer: B) Tell me what you want to do. 3. What do the letters URL stand for? A) Universal Resource Locator. B) Unbelievable Resource Locator. C) Uniform Resource Locator. D) Undergound Railway Line. Show Answer Correct Answer: C) Uniform Resource Locator. 4. It is known as the spreadsheet application. A) MS Word. B) MS Excel. C) MS PowerPoint. D) MS Publisher. Show Answer Correct Answer: B) MS Excel. 5. A file that contains one or more worksheets to organize data is known as ..... A) Workbook. B) Excelbook. C) Datasheet. D) Spreadsheet. Show Answer Correct Answer: A) Workbook. 6. To add up the total cost of the price, You use A) AutoSum Function. B) A divide Formula. C) All the above. D) None of the above. Show Answer Correct Answer: A) AutoSum Function. 7. Spreadsheet is used by accountant and teacher. A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: A) TRUE. 8. How many numbers of sheets contain a single spreadsheet? A) 100. B) 155. C) 230. D) 255. Show Answer Correct Answer: D) 255. 9. Columns are ..... A) Lettered. B) Numbered. C) All the above. D) None of the above. Show Answer Correct Answer: A) Lettered. 10. Last Column name in Excel 2016 A) XFD. B) What. C) QHD. D) XYZ. Show Answer Correct Answer: A) XFD. 11. Division in Mathematics Operators in MS Excel is symbolized by a sign ..... A) *. B) -. C) /. D) :. Show Answer Correct Answer: C) /. 12. A ..... is a visual representation of data A) Spreadsheet. B) Border. C) Chart. D) Table. Show Answer Correct Answer: C) Chart. 13. The right step to close the worksheet that is still active in MS Excel is ..... A) File-Close. B) Click the close-no sign. C) File-Exit. D) Office Button-Exit. Show Answer Correct Answer: B) Click the close-no sign. 14. What is function of Shift Cells Right option? A) It shifts the selected cells towards right leaving blank cells. B) It inserts a new row. The row with selected cells shifts right. C) It inserts a new column. The column with selected cells shifts right. D) None of the above. Show Answer Correct Answer: A) It shifts the selected cells towards right leaving blank cells. 15. Which of the following functions are available in consolidate window? A) MAX. B) MIN. C) COUNT. D) ALL OF THE ABOVE. Show Answer Correct Answer: D) ALL OF THE ABOVE. 16. The function in the excel used calculates the average of a group of values A) SUM. B) AVERAGE. C) MAX. D) IF. Show Answer Correct Answer: B) AVERAGE. 17. This is the file where data is stored in Excel. A) Workbook. B) Folder. C) Worksheet. D) Publisher. Show Answer Correct Answer: A) Workbook. 18. The spreadsheet program contains certain calculations used to analyze data in the form ..... A) Statistics, accounting and time scheduling. B) Graphics, presentations and letters. C) Time scheduling, disseminators of undqngan and email. D) Email, Letters and Sales Data. Show Answer Correct Answer: A) Statistics, accounting and time scheduling. 19. ..... allows you to create visual presentation of facts and information. A) Word. B) Excel. C) All the above. D) None of the above. Show Answer Correct Answer: B) Excel. 20. The most widely used word processing software in late 1970s was A) MS Word. B) Libre office. C) AppleWorks. D) WordStar. Show Answer Correct Answer: D) WordStar. 21. An Excel Sheet is made of ..... A) Lines and Dots. B) Rows and Columns. C) Header and Footer. D) None of the above. Show Answer Correct Answer: B) Rows and Columns. 22. For writing the number formula in B2 cells with the correct C2 cells below is A) +Sum(B2 C2). B) =Sum(B2:C2). C) =Sum(B2;C2). D) =Sum(B2 C2). E) =Sum(B2, C2). Show Answer Correct Answer: B) =Sum(B2:C2). 23. Sum, average, count, and maximum value are examples of what? A) Formulas. B) Functions. C) Calculations. D) Spreadsheet Data. Show Answer Correct Answer: B) Functions. 24. Which formula would subtract D12 from D13? A) = D13-D12. B) = D12-D13. C) =sum(D12-D13). D) =sum(D13-D12). Show Answer Correct Answer: A) = D13-D12. 25. Which bar show the used formula of selected active cell? A) Formula Bar. B) Ribbon. C) Bar menu. D) Title Bar. Show Answer Correct Answer: A) Formula Bar. ← 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