This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 71 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 71 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Kenyon would like to convert the cell range A1:F20 to a Medium 18 style. Which formatting style should he select? A) Cell Style. B) Conditional Formatting. C) Fill Color. D) Format as Table. Show Answer Correct Answer: D) Format as Table. 2. Click ..... tab to create a chart. A) CREATE. B) INSERT. C) FORMAT. D) HOME. Show Answer Correct Answer: B) INSERT. 3. A spreadsheet is like a filing system or a calculator? A) /. B) X. C) All the above. D) None of the above. Show Answer Correct Answer: A) /. 4. The Merge and Center icon will combine the contents of the selected cells into one larger cell. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 5. Combine multiple cells into a single cell. A) Range. B) Active cell. C) Merge. D) Filtering. Show Answer Correct Answer: C) Merge. 6. The basic unit of a worksheet in which you enter the Data in Excel is called the basic unit of the worksheet in which you enter the data in Excel. A) Cell. B) Table. C) Box. D) Column. Show Answer Correct Answer: A) Cell. 7. Each Excel file can hold many ..... A) Sheets. B) Workbooks. C) Documents. D) None of the above. Show Answer Correct Answer: A) Sheets. 8. What is the shortcut key to save an Excel file? A) Ctrl + C. B) Ctrl + S. C) Ctrl + F. D) Ctrl + W. Show Answer Correct Answer: B) Ctrl + S. 9. Input hardware is also called the term ..... A) Output devices. B) Input devices. C) Proses devices. D) Storage devices. E) Devices. Show Answer Correct Answer: B) Input devices. 10. .Which one amongst the following is Spreadsheet based Software- A) MS excel. B) Google Spreadsheet. C) Both. D) None of the above. Show Answer Correct Answer: C) Both. 11. Press ..... to select the entire worksheet. A) Ctrl+A. B) Ctrl+C. C) Ctrl + V. D) None of the above. Show Answer Correct Answer: A) Ctrl+A. 12. Known the contents of cell a1 = 10. in cell b1 = ab.In cell C1 there is the number 15. If the cell D1 is written the formula = C1*B1, the result that will come out is ..... A) 10. B) C1*B1. C) #NAME?. D) 15. E) #VALUE!. Show Answer Correct Answer: E) #VALUE!. 13. Anita wants to do some calculation. Which symbol should she use at the beginning of her formula? A) /. B) *. C) =. D) ". Show Answer Correct Answer: C) =. 14. Each cell has a different name. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 15. Floating point number data type. A) Numbers. B) Text. C) Fraction. D) Percentage. Show Answer Correct Answer: A) Numbers. 16. Which of the following keys is pressed in order to move between the cells in MS-Excel? A) Tab key. B) Enter key. C) Arrow key. D) All of these. Show Answer Correct Answer: D) All of these. 17. Key combination to move to the adjacent cell on the left A) Shift + Tab. B) Ctrl + Home. C) Ctrl + G. D) None of the above. Show Answer Correct Answer: A) Shift + Tab. 18. Hiran needs to move all excel files on his computer to a folder. Which extension should he search for? A) .DOCX. B) .Excl. C) .XLSX. D) .XLXS. Show Answer Correct Answer: C) .XLSX. 19. The following are the steps to make a diagram by integrating between MS Power Point and MS Excel1.Click the Insert2 menu.Diagram and Excel3 display will appear.Open the MS PowerPoint4 application.Select Chart5.Change the data in excel as needed6.CLOSE EXCEL7.Choose Diagram Type What is the right sequence of steps? A) 3-2-5-4-7-6-1. B) 3-1-4-7-2-5-6. C) 3-4-1-2-5-6-7. D) 3-7-5-6-4-2-1. E) 3-2-1-5-7-4-6. Show Answer Correct Answer: B) 3-1-4-7-2-5-6. 20. Included in the simple statistical formula is ..... A) SUM, MAX, MIN. B) COUNT, MAX, DATE. C) COUNT, IF, LOOKUP. D) AVERAGE, LOOKUP, DATE. E) TIME, DATE, COUNT. Show Answer Correct Answer: A) SUM, MAX, MIN. 21. ..... changes the appearance of cells on the basis of conditions that we specify. A) Conditional Formatting. B) Data Validation. C) All the above. D) None of the above. Show Answer Correct Answer: A) Conditional Formatting. 22. In Ms.Excel To turn Cell data into graphics, the selected menu is ..... A) Home. B) Insert. C) Page Layout. D) Formula. E) View. Show Answer Correct Answer: B) Insert. 23. A worksheet range is a A) A command used for data modeling. B) A range of values such as from 23 to 234. C) A group of cells. D) A group of worksheets. Show Answer Correct Answer: C) A group of cells. 24. Maximize and Minimize icons are part of A) Title Bar. B) Formula Bar. C) Tool Bar. D) All wrong. Show Answer Correct Answer: A) Title Bar. 25. Which one is not a function in MS Excel? MS Excel does not have a function? A) SUM. B) AVG. C) MAX. D) MIN. Show Answer Correct Answer: B) AVG. ← 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