This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 56 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 56 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. To select all the cells in a worksheet, press ..... A) Ctrl + A. B) Ctrl + B. C) Ctrl + Z. D) Ctrl + Z. Show Answer Correct Answer: A) Ctrl + A. 2. What function will calculate the AVERAGE of all the numbers in a column? A) = If (a1:a6). B) =SUM(E1:E5). C) =AVERAGE(E1:E5). D) =CONCAT(E1:E5). Show Answer Correct Answer: C) =AVERAGE(E1:E5). 3. ROM is? A) Non-volatile. B) Volatile. C) Both the above. D) None of above. Show Answer Correct Answer: A) Non-volatile. 4. To use the Merge and Center feature, we can ..... A) Select the cells to merge. B) Click the Home tab. C) Click the merge and center option. D) None of the above. Show Answer Correct Answer: C) Click the merge and center option. 5. The cell in which you are working, outlined in a darker color than the rest of the cells A) Last Cell. B) Next Cell. C) Active Cell. D) Inactive Cell. Show Answer Correct Answer: C) Active Cell. 6. Table of Contents are used for ..... A) Creating a table. B) Make graphics. C) Make a diagram. D) Create an automatic contents. Show Answer Correct Answer: D) Create an automatic contents. 7. It is an application that will allow you to create professional-looking documents using various themes, visual designs, formatting tools and more. A) MS Word. B) MS PowerPoint. C) MS Excel. D) None of the above. Show Answer Correct Answer: B) MS PowerPoint. 8. When we want to make a general arrangement without a specific format, we choose ..... A) Currency. B) Accounting. C) Percent. D) Number. E) General. Show Answer Correct Answer: E) General. 9. Shows content of the active cell A) Formula Bar. B) Status Bar. C) Task Bar. D) None of the above. Show Answer Correct Answer: A) Formula Bar. 10. The function used to add numbers in Microsoft Excel is ..... A) AVERAGE. B) COUNT. C) SUM. D) MIN. E) MAX. Show Answer Correct Answer: C) SUM. 11. The function that is used to check a condition A) If. B) S u m. C) Average. D) None of the above. Show Answer Correct Answer: A) If. 12. Excel allows you to A) Read stories. B) Invent ideas. C) Work with data. D) Helps in coding. Show Answer Correct Answer: C) Work with data. 13. A ..... is an intersection of a row and a column. A) Row. B) Column. C) Cell. D) Sheet tab. Show Answer Correct Answer: C) Cell. 14. What symbol is used for formulas? A) =. B) !. C) £. D) \{. Show Answer Correct Answer: A) =. 15. A single worksheet in excel-2007 has a maximum of ..... rows. A) 1, 048, 575. B) 1, 048, 576. C) 1, 048, 577. D) 1, 048, 578. Show Answer Correct Answer: B) 1, 048, 576. 16. Which tab of the ribbon should you go to for removing gridlines on a worksheet? A) Formulas. B) View. C) Review. D) Developer. Show Answer Correct Answer: B) View. 17. What is the column header name for the 18th Column? A) M. B) Q. C) R. D) N. Show Answer Correct Answer: C) R. 18. Sheet-Worksheet on Microsoft Office Excel When opened first consisting of Sheet 1, Sheet 2 is called ..... A) Sheet. B) Worksheet. C) Sel. D) Workbook. E) Range. Show Answer Correct Answer: B) Worksheet. 19. Calculating the average is a function of ..... A) Sum. B) Average. C) Min. D) Function. E) Vlookup. Show Answer Correct Answer: B) Average. 20. What is action of Tab key in Excel? A) One cell down in the column. B) Next cell in the row. C) Previous cell in the row. D) One cell up in the column. Show Answer Correct Answer: B) Next cell in the row. 21. How do you select an entire column? A) Select Edit > Select > Column from the menu. B) Click the column heading letter. C) Hold down the shift key as you click anywhere in the column. D) Hold down the Ctrl key as you click anywhere in the column. Show Answer Correct Answer: B) Click the column heading letter. 22. The initial command to set the page (layaout) is ..... A) File $\rightarrow$ page setup. B) File $\rightarrow$ print. C) View $\rightarrow$ print layout. D) View $\rightarrow$ page layoaut. E) Format $\rightarrow$ cells. Show Answer Correct Answer: A) File $\rightarrow$ page setup. 23. The ..... option let you select the shape of the brush. A) Brush. B) Pencil. C) Tools. D) Pen. Show Answer Correct Answer: A) Brush. 24. The function that lets you add up a range of cells or values A) AVERAGE. B) SUM. C) MIN. D) MAX. Show Answer Correct Answer: B) SUM. 25. By default a workbook consists of ..... worksheets A) Two. B) Five. C) One. D) Unlimited. Show Answer Correct Answer: C) One. ← 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