This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 19 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 19 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Based on the following formula:= 8*3 The results are ..... A) 11. B) 2.25. C) 5. D) 24. Show Answer Correct Answer: D) 24. 2. Mathematical operator sign used to start a calculation function in Excel ..... A) @. B) #. C) ?. D) =. Show Answer Correct Answer: D) =. 3. Press Ctrl + Home to go to cell A1. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 4. Which of the following is a valid function? A) = am (A1:Ash). B) Am = (a1:Ash). C) = Sum1:Ashst. D) = am (A1, Ash). Show Answer Correct Answer: A) = am (A1:Ash). 5. Spreadsheet is a ..... A) Program. B) Hardware. C) All the above. D) None of the above. Show Answer Correct Answer: A) Program. 6. How must a cell containing a formula start? A) SUM. B) =. C) +. D) ( ). Show Answer Correct Answer: B) =. 7. Spreadsheets consists of ..... and ..... A) Rows and Tables. B) Rows and Columns. C) Tables and chairs. D) Columns and tables. Show Answer Correct Answer: A) Rows and Tables. 8. Absolute cell reference uses which sign A) $. B) +. C) =. D) &. Show Answer Correct Answer: A) $. 9. Files that have been removed and available on Recycle Bin, can be called back by order ..... A) Rename. B) Restore. C) File, Open. D) Delete. E) Back. Show Answer Correct Answer: B) Restore. 10. What returns a position of a cell? A) Index. B) Match. C) Column. D) Lookup. Show Answer Correct Answer: B) Match. 11. It is Productivity Suite created by the Microsoft Corporation. A) Microsoft Office Suite. B) Microsoft office 2013. C) Productivity tools. D) None of the above. Show Answer Correct Answer: B) Microsoft office 2013. 12. To print any worksheet you need to click on A) File > Print. B) Home >Print. C) INsert > Print. D) None of the above. Show Answer Correct Answer: A) File > Print. 13. The number are used in calculations A) Labels. B) Values. C) Numbers. D) None of the above. Show Answer Correct Answer: B) Values. 14. In Excel, Rows are labelled as ..... A) A, B, C, etc. B) 1, 2, 3 etc. C) A1, A2, etc. D) $ A$ 1, $ A$ 2, etc. Show Answer Correct Answer: B) 1, 2, 3 etc. 15. The following is not an office application is ..... A) Ms. Word. B) Ms. Excel. C) Ms. Power Point. D) Corel. E) Google Docs. Show Answer Correct Answer: D) Corel. 16. Individual pieces of information typed into the spreadsheet. A) Workbook. B) Spreadsheet. C) Cell. D) Entry. Show Answer Correct Answer: D) Entry. 17. Microsoft Excel is one of the number processing applications, also called ..... A) Spreadsheet. B) Graphic Design. C) Drawing. D) Word Processor. Show Answer Correct Answer: A) Spreadsheet. 18. Which option will you click from borders drop-down list to see more borders? A) Thick Border. B) More Borders. C) Outside Borders. D) Thick Box Border. Show Answer Correct Answer: B) More Borders. 19. The advantage of using a spreadsheet is: A) Calculations can be done automatically. B) Changing data automatically updates calculations. C) More flexibility. D) All of the above. Show Answer Correct Answer: D) All of the above. 20. A formula in the spreadsheet should always start with A) A plus sign. B) An asterisk. C) An equals sign. D) A capital letter. Show Answer Correct Answer: C) An equals sign. 21. Each excel formula / function should begin with ..... symbol. A) -. B) . C) *. D) =. Show Answer Correct Answer: D) =. 22. In Microsoft Excel or Spreadsheets there are 2 elements namely ..... and ..... A) Column and table. B) Row and column. C) Tables and lines. D) Everything is wrong. Show Answer Correct Answer: B) Row and column. 23. Which of the following is not an MS Excel data type? A) Money. B) Date and Time. C) Number. D) Text. Show Answer Correct Answer: A) Money. 24. In Excel, numbers automatically align to ..... ? A) The left. B) The centre. C) The right. D) The Top. Show Answer Correct Answer: C) The right. 25. What is Microsoft PowerPoint used for? A) Create and deliver presentations. B) Watch movies. C) Create documents. D) Create spreadsheets. Show Answer Correct Answer: A) Create and deliver presentations. ← 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