This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 6 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 6 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Where we use () in excel A) Formula. B) Work book. C) Cell. D) Row. Show Answer Correct Answer: A) Formula. 2. The function used to take the left of the text data as much as certain characters A) Left. B) Right. C) Mid. D) Value. Show Answer Correct Answer: A) Left. 3. The function that allows you to combine text from different cells into one cell A) CONCAT. B) Combine. C) Counta. D) Countif. Show Answer Correct Answer: A) CONCAT. 4. What symbol is used for addition? A) *. B) /. C) +. D) -. Show Answer Correct Answer: C) +. 5. All formulae must begin with an ..... sign. A) +. B) /. C) =. D) *. Show Answer Correct Answer: C) =. 6. To see web pages on the World Wide Web you need special software called a ..... A) Web worm. B) Web browser. C) URL. D) Web space. Show Answer Correct Answer: B) Web browser. 7. Displays the content (text, value, date, or formula) in the active cell. A) Active cell. B) Input area. C) Output area. D) Formula bar. Show Answer Correct Answer: D) Formula bar. 8. If you copy the formula =$ B38 into another cell, the result will be: A) The column part will remain the same. B) The row part will remain the same. C) Both the column and row will remain the same. D) Both will change. Show Answer Correct Answer: A) The column part will remain the same. 9. Can you format text with Excel A) Yes. B) No. C) All the above. D) None of the above. Show Answer Correct Answer: A) Yes. 10. An excel workbook is a collection of A) Workbooks. B) Worksheets. C) Charts. D) Worksheets and charts. Show Answer Correct Answer: D) Worksheets and charts. 11. What is a file which contains one or more spreadsheets? A) Spreadsheet. B) Workbook. C) Cell. D) Cell range. Show Answer Correct Answer: B) Workbook. 12. You can create a basic chart by clicking the chart type that you want on the insert tab in the charts group. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 13. It is at the top of the work area in Office applications which contains of the main tabs with group of commands. A) Tool tip. B) Ribbon. C) Tab. D) None of the above. Show Answer Correct Answer: B) Ribbon. 14. It means "many media. A) Multimedia. B) Medium. C) Multimedia computing. D) None of the above. Show Answer Correct Answer: A) Multimedia. 15. Which sign is used for absolute addressing? A) @. B) $. C) &. D) *. Show Answer Correct Answer: B) $. 16. Below this is not the function of Microsoft Excel is ..... A) Make graphics. B) Creating a table. C) Make a paper. D) Calculate data. E) Financial function. Show Answer Correct Answer: C) Make a paper. 17. Which of the following formulas is not entered correctly? A) =10+50. B) =B7+B8. C) = Bs+14. D) 10+50. Show Answer Correct Answer: D) 10+50. 18. A chart ..... identifies which data series each color represents. A) Legend. B) Vertical axis. C) Title. D) Horizontal axis. Show Answer Correct Answer: A) Legend. 19. Open source software is a type of software whose source code is open and can be studied, changed, developed, improved, and can also be disseminated A) Close Source. B) Open Source. C) Malware. D) Shareware. Show Answer Correct Answer: B) Open Source. 20. When you key a formula in a spreadsheet what do you key in first? A) Subtraction sign. B) Equal Sign. C) Addition sign. D) Division sign. Show Answer Correct Answer: B) Equal Sign. 21. Workbook is a collection of A) Work file. B) Worksheet. C) Work records. D) None of the above. Show Answer Correct Answer: B) Worksheet. 22. Shortkey to display words like this is ..... A) (Ctrl + U) + (Ctrl+ I). B) (Ctrl+ B) + (Ctrl+ I). C) (Ctrl + S) + (Ctrl+J). D) (Ctrl + B) + (Ctrl + U). E) (Ctrl + A) + (Ctrl + B). Show Answer Correct Answer: B) (Ctrl+ B) + (Ctrl+ I). 23. What function is used to find the lowest data? A) MIN. B) MAX. C) SUM. D) AVERAGE. Show Answer Correct Answer: A) MIN. 24. The ..... button is used to cancel data entry before pressing enter key. A) Undo. B) Redo. C) None of the above. D) None of the above. Show Answer Correct Answer: A) Undo. 25. Statistical calculations and preparation of tables and graphs can be done using A) Excel. B) Power point. C) Word. D) None of the above. Show Answer Correct Answer: A) 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 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 10Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books