This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 13 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 13 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What does the Countif formula return? A) Counts the number of cells within a range that meets the given condition. B) Counts the number of words within a range that meets the given condition. C) Counts the number of columns within a range that meets the given condition. D) Counts the number of letters within a range that meets the given condition. Show Answer Correct Answer: A) Counts the number of cells within a range that meets the given condition. 2. What does HTML stand for A) Hyper Typed Markup Language. B) HyperText Markup Language. C) HyperTenson Markup Language. D) HyperTense Markup Language. Show Answer Correct Answer: B) HyperText Markup Language. 3. MS Word's advanced features that can be used to make the same letter, but have several different components such as names and addresses are ..... A) Mail merge. B) Object linking. C) Copy paste. D) Cut paste. E) Embedding. Show Answer Correct Answer: A) Mail merge. 4. In MS Excel a formula should always start with ..... sign. A) +. B) /. C) =. D) X. Show Answer Correct Answer: C) =. 5. Which tab in Excel has charts and tables? A) Review. B) Home. C) File. D) Insert. Show Answer Correct Answer: D) Insert. 6. Which part displays the location of a cell in a worksheet? A) Title bar. B) Name box. C) Ribbon. D) None of the above. Show Answer Correct Answer: B) Name box. 7. One way to store WordBook in Excel is to use ..... A) Ctrl+B. B) Ctrl+P. C) Ctrl+C. D) Ctrl+V. E) Ctrl+S. Show Answer Correct Answer: E) Ctrl+S. 8. What is used to C10 ..... A) Baris S Kolom 10. B) Kolom S Baris 10. C) Brother Jean 10. D) Cell C. Show Answer Correct Answer: B) Kolom S Baris 10. 9. MS Excel stands for ..... A) Micromax Excel. B) Management Excel. C) Microsoft Excel. D) Microsoft Excess. Show Answer Correct Answer: C) Microsoft Excel. 10. Excel allows you to work with? A) Sentences. B) Paragraphs. C) Data. D) None of the above. Show Answer Correct Answer: C) Data. 11. Writing the formula in Excel using the sign "=" on ..... sentence A) Middle. B) Back. C) Early. D) End. Show Answer Correct Answer: C) Early. 12. Which formula gets the biggest value of a range of cells? A) MAX. B) MIN. C) LARGE. D) SUM. Show Answer Correct Answer: A) MAX. 13. What is meant by Range in Excel? A) Group from worksheets. B) A group of several cells. C) Meeting between rows and columns. D) Meeting between cells and range. Show Answer Correct Answer: B) A group of several cells. 14. What is the symbol for division when using MS EXCEL. A) /. B) +. C) *. D) -. Show Answer Correct Answer: A) /. 15. Google Sheets is a desktop program. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 16. To make a diagram on PowerPoint, the command used is ..... A) Insert$\rightarrow$ Table. B) Insert$\rightarrow$Shape. C) Insert$\rightarrow$ Chart. D) Insert$\rightarrow$SmartArt. E) Insert$\rightarrow$Picture. Show Answer Correct Answer: C) Insert$\rightarrow$ Chart. 17. The tool to run the Microsoft Excel or Spreadsheet application is ..... A) Tv. B) Computer. C) Keyboard. D) Radio. Show Answer Correct Answer: B) Computer. 18. The spreadsheet worksheet section identified using the numbers 1-1048576 is called ..... A) Line. B) Cell. C) Sheet. D) Column. Show Answer Correct Answer: A) Line. 19. What alternative key is used as paste function in Excel? A) Tab. B) CTRL. C) Shift. D) Enter. Show Answer Correct Answer: D) Enter. 20. Google Sheets is free and easy to use. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 21. ..... is an international network of computers. A) Network. B) WWW. C) Internet. D) Local Area Network. Show Answer Correct Answer: C) Internet. 22. ..... is money owed to a lender (loans etc) A) Debt. B) Credit. C) Savings. D) Expense. Show Answer Correct Answer: A) Debt. 23. The function COUNTA is specific for ..... A) Counting text. B) Counting cells. C) Counting number. D) Counting tables. Show Answer Correct Answer: A) Counting text. 24. When using a formula to subtract cell B7 from cell C7 which formula is correct? LOOK closely at the answer choices! A) = (BT/CNTA). B) (BNT-Tsst). C) = (BT-Dost). D) = BTA-DOCT. Show Answer Correct Answer: C) = (BT-Dost). 25. What type of device is a computer monitor? A) Input. B) Output. C) Software. D) Storage. Show Answer Correct Answer: B) Output. ← 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