This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 64 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 64 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. One terabyte (1 TB) is equal to A) 1028gb. B) 1024gb. C) 1000. D) 1020. Show Answer Correct Answer: B) 1024gb. 2. On an Excel sheet the active cell is indicated by: A) A dotted border. B) A blinking border. C) A dark border. D) By italic text. Show Answer Correct Answer: C) A dark border. 3. What do you call a statement that requires a computation? A) Formula. B) Label. C) Value. D) Cell Reference. Show Answer Correct Answer: A) Formula. 4. The source of the data is ..... A) Mail Merge. B) Ms. Word. C) Ms. Excel. D) All answers are correct. Show Answer Correct Answer: C) Ms. Excel. 5. What is the name of a computer program used for organising information in rows and columns? A) Spreadsheet. B) Presentation. C) Publisher. D) Browser. Show Answer Correct Answer: A) Spreadsheet. 6. To calculate the average using the formula A) Average. B) Max. C) Min. D) Sum. Show Answer Correct Answer: A) Average. 7. WWW stands for ..... A) World Wide Web. B) World Wild Web. C) Web Word Wide. D) Word Wide Web. Show Answer Correct Answer: A) World Wide Web. 8. Spreadsheet Software is a program that lets you organize data in rows and columns. A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: A) TRUE. 9. Which is the correct symbol to use when multiplying in a spreadsheet? A) -. B) +. C) =. D) *. Show Answer Correct Answer: D) *. 10. The function used to take several characters in the middle of the text data A) Left. B) Right. C) Mid. D) Value. Show Answer Correct Answer: C) Mid. 11. Numbers in Excel is automatically aligned ..... A) Right. B) Left. C) Center. D) Justify. Show Answer Correct Answer: A) Right. 12. Formula = Count (50:50:50:50:50:50) is A) 300. B) 60. C) 6. D) 0. Show Answer Correct Answer: C) 6. 13. The usefulness of the number processing application is ..... A) Make a presentation slide. B) Creating a text document (letter). C) Send email. D) Calculating Sales Profit. Show Answer Correct Answer: D) Calculating Sales Profit. 14. Microsoft Excel has a worksheet called ..... A) Test Area. B) Worksheet. C) Workbook. D) Screen Saver. Show Answer Correct Answer: B) Worksheet. 15. A "page" within an Excel workbook that contains columns, rows, and cells. A) Workbook. B) Worksheet. C) Label. D) Cell. Show Answer Correct Answer: B) Worksheet. 16. Toolbar which contains several groups and consists of several commands such as home, insert, view, etc. A) Tab Ribbon. B) Group. C) Tittle Bar. D) Formula Bar. Show Answer Correct Answer: A) Tab Ribbon. 17. Toolbar icons that work to combine cells are ..... A) Merge and center. B) View merge. C) Bulleted and numbering. D) Insert field. E) Sort ascending. Show Answer Correct Answer: A) Merge and center. 18. Formula =A3+B4 is copied from C1 to D1. The changed formula in D1 is A) = A4+B5. B) = I+BC. C) = BC+B5. D) = BZ+CSK. Show Answer Correct Answer: D) = BZ+CSK. 19. The sum function A) Add two cells. B) Add values in two cells. C) Add two or more cells. D) Add values of two or more cells. Show Answer Correct Answer: D) Add values of two or more cells. 20. Audio visual presentation A) MS Word. B) MS PowerPoint. C) MS Excel. D) None of the above. Show Answer Correct Answer: B) MS PowerPoint. 21. MS Program.Excel is more suitable for ..... A) Draw. B) Edit photos. C) Processing numbers. D) Taping a letter of application. Show Answer Correct Answer: C) Processing numbers. 22. The command to insert the column is ..... A) Entire column. B) Entire row. C) Shift cells left. D) Shift cells right. E) Sift cells down. Show Answer Correct Answer: A) Entire column. 23. Shortcut key to insert new worksheet is A) Ctrl+F10. B) Shift+F11. C) ALT+F9. D) Shift+F10. Show Answer Correct Answer: B) Shift+F11. 24. You accidentally erased a record in the sheet. What command can be used to restore it immediately? A) Insert. B) Copy. C) Undo. D) Replace. Show Answer Correct Answer: C) Undo. 25. The process of joining text values in a sequence within a formula is called ..... A) Concatenation. B) Joining. C) Preparation. D) Admiration. Show Answer Correct Answer: A) Concatenation. ← 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