This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 54 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 54 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Geogebra used for ..... subject. A) Science. B) Math. C) Language. D) Geography. Show Answer Correct Answer: B) Math. 2. Samantha needs to total the values in cells A1 to A10. Which should she enter to find the answer? A) SUM(A1+A10). B) =SUM(A1:A10). C) =TOTAL(A1:A10). D) =TOTAL(A1+A10). Show Answer Correct Answer: B) =SUM(A1:A10). 3. The section of excel that has horizontal rows are identified by A) Numbers. B) Letters. C) None. D) None of the above. Show Answer Correct Answer: A) Numbers. 4. Formulas can be copied to adjacent cells with the ..... A) Fill handle. B) PgDn Key. C) Function key F4. D) None of the above. Show Answer Correct Answer: A) Fill handle. 5. The function of the exit file is ..... A) End the program. B) Open the program. C) Mainformat program. D) Run the program. E) Delete programs. Show Answer Correct Answer: A) End the program. 6. A software commonly used by accountants and other people involved in businesses. A) MS Excel. B) MS Accounting. C) MS Business. D) MS Calculator. Show Answer Correct Answer: A) MS Excel. 7. Explain the usefulness of the Ify formula in Excel! A) The IF formula is used to produce a true/false value of certain criteria. B) The IF formula is used to produce a true/false value of a particular range. C) The IF formula is used to produce a true/false value of a particular logic test. D) None of the above. Show Answer Correct Answer: C) The IF formula is used to produce a true/false value of a particular logic test. 8. The one which has embedded spreadsheet A) Twitter. B) You tube. C) Google. D) None of the above. Show Answer Correct Answer: C) Google. 9. Which one of the following alignment option is not available in excel? A) Left. B) Middle. C) Right. D) Justify. Show Answer Correct Answer: D) Justify. 10. If B3:J8 is given, what is it referring to? A) Range of cells B3 through J8. B) Only cell J8. C) Only cells B3 and J8. D) Only cell B3. Show Answer Correct Answer: A) Range of cells B3 through J8. 11. The "Undo" icon works ..... A) Print documents. B) Save documents. C) Cancel the workmanship. D) Open files. E) Cutting part of the document. Show Answer Correct Answer: C) Cancel the workmanship. 12. There are number 3, 6, 7 then for the sum function is A) 16. B) 10. C) 4. D) 5. E) 6. Show Answer Correct Answer: A) 16. 13. What is the formula for =sum(B2:B9) A) B 1+Ba+Baa+B 4. B) = Ba++B+B 4+ Square+Duck++Bulle. C) Ba+Baa+B 4+ Square+Duck+Bald+Blind. D) = B 1+Ba+Baa+B 4. Show Answer Correct Answer: B) = Ba++B+B 4+ Square+Duck++Bulle. 14. Located on the left side or the entry bar, displays the active cell reference: A) Entry bar. B) Cell reference. C) Name box. D) None of the above. Show Answer Correct Answer: C) Name box. 15. Which of the following is an example of an addition formula? A) = Bc+ns. B) 2+3+6=11. C) Fz*. D) = Bass/duck. Show Answer Correct Answer: A) = Bc+ns. 16. Which of the following is a selected cell? A) Current command. B) Default option. C) Active cell. D) Default cell. Show Answer Correct Answer: C) Active cell. 17. 22-Each Cell has two names (e.g. B3 or 3B) A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: B) FALSE. 18. The ..... feature of ms excel quickly completes a series of data. A) Car filter. B) Auto Complete. C) Auto Fill. D) Auto Sum. Show Answer Correct Answer: C) Auto Fill. 19. Space between vertical grid lines. A) Row. B) Column. C) Range. D) Cell. Show Answer Correct Answer: B) Column. 20. SHORT CUT FOR CUT A) CTRL+C. B) CTRL+V. C) CTRL+D. D) CTRL+X. Show Answer Correct Answer: D) CTRL+X. 21. Applications that is only accessed over the internet are called? A) Online app. B) Virtual application. C) Web application. D) All of the above. Show Answer Correct Answer: C) Web application. 22. By default, how many worksheet Availble when You create a New Excel Sheet A) 3. B) 4. C) 2. D) 1. Show Answer Correct Answer: A) 3. 23. A formula begins with an EQUAL SIGN. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 24. What function will produce results that indicate whether a student has passed or failed a course by enter the text "Pass" or "Fail" ? A) Count. B) Counta. C) IF. D) SUM. Show Answer Correct Answer: C) IF. 25. An individual box within a worksheet is known as? A) Square. B) Range. C) Referencing. D) Cell. Show Answer Correct Answer: D) Cell. ← 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