This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 65 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 65 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What do we call the currently selected cell with thick green borders? A) Active cell. B) Name box. C) Rows. D) None of the above. Show Answer Correct Answer: A) Active cell. 2. Rolling one screen to the right on Ms.Excel we can use the command via the keyboard that is the button ..... A) Ctrl + home. B) Ctrl + end. C) ALT + PGDN. D) ALT + PGUP. Show Answer Correct Answer: C) ALT + PGDN. 3. Status bar shows the name of the currently selected command or current activity. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 4. You can only work in one cell at a time. The actual cell that you are working in is called what? A) Column. B) Name Box. C) Active Cell. D) Row. Show Answer Correct Answer: C) Active Cell. 5. What kind of tools do we choose to make diagrams on ms.word? A) Insert Table. B) Insert Shapes. C) Insert Chart. D) Insert Illustration. Show Answer Correct Answer: B) Insert Shapes. 6. One of the functions of Mail Merge is, making a letter with a format ..... but the variable is ..... A) The same, different. B) You're welcome. C) Different, the same. D) Different, different. Show Answer Correct Answer: A) The same, different. 7. This data type can be any type like whole integers or with decimals. A) Numbers. B) Date and Time. C) Text. D) Currency. Show Answer Correct Answer: A) Numbers. 8. ..... are predefined formulas thatperform calculations using specific values in a particular order. A) Functions. B) Variables. C) All the above. D) None of the above. Show Answer Correct Answer: A) Functions. 9. A collection of web pages is called a ..... A) Web server. B) Web browser. C) Website. D) WiFi. Show Answer Correct Answer: C) Website. 10. What is the pictorial representation of worksheet data? A) Chart. B) Clip Art. C) WordArt. D) All of these. Show Answer Correct Answer: A) Chart. 11. A worksheet contains ..... columns. A) 16384. B) 15384. C) Infinity. D) Or it was wiped up by Thanos snap, So its 0. Show Answer Correct Answer: A) 16384. 12. How is the COLUMN in a MS Excel Spreadsheet named? A) Numbers. B) Letters. C) Cells. D) Columns. Show Answer Correct Answer: B) Letters. 13. What function do you press to center a title in 5 cells in one row? A) Title YES. B) Merge and Center. C) A1+B1+C1+D1+E1. D) Center. Show Answer Correct Answer: B) Merge and Center. 14. Combining cells in Excel using ..... A) Formula. B) Format Cells. C) Custom. D) Merge & Center. Show Answer Correct Answer: D) Merge & Center. 15. What feature is particularly useful when you want to add all numbers in a row or column A) Autoosum. B) Product. C) Operators. D) Hierarchy. Show Answer Correct Answer: A) Autoosum. 16. A word processing software developed by Microsoft. A) MS Excel. B) MS Word. C) MS PowerPoint. D) None of the above. Show Answer Correct Answer: B) MS Word. 17. The commands that belong to the quick access toolbar are Save, Undo and ..... A) Reef. B) File. C) Table. D) Pagelayout. Show Answer Correct Answer: A) Reef. 18. If you don't want a cell reference to change when copied to other cells, use ..... references A) Absolute. B) Relative. C) Mixed. D) None of the above. Show Answer Correct Answer: A) Absolute. 19. Apart from the Mailings itself, we can create a database in other programs, namely A) Photoshop. B) Mozila Firefox. C) Microsoft Excel. D) Microsoft Powerpoint. Show Answer Correct Answer: C) Microsoft Excel. 20. What is a formulas in excel sheet A) The address of the cells. B) The defined expression that contains values, constants, Call reference, functions and operators. C) Numbers or text values that can be entered directly in a formula. D) None of the above. Show Answer Correct Answer: B) The defined expression that contains values, constants, Call reference, functions and operators. 21. Title bar displays the address of the active cell. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 22. In addition to the MS.OnFice application to make a chain letter we can use the application from Google, namely ..... A) Gmail and Slide. B) Slide dan spreadsheed. C) Sites and classrome. D) Documents and sites. E) Docs dan spreadsheed. Show Answer Correct Answer: E) Docs dan spreadsheed. 23. What is one way to ADD a Range of rows and columns in MS EXCEL other than using the + symbol. A) SUMMING. B) SUM. C) ALL. D) None at all. Show Answer Correct Answer: B) SUM. 24. Cooper is creating a spreadsheet for FBLA and wants to be able to put the spreadsheet in alphabetical order by last name. What should Cooper apply to the spreadsheet? A) Filter. B) Formula. C) Macro. D) Sort. Show Answer Correct Answer: D) Sort. 25. To count both numbers and text based data's, ..... function is used. A) COUNT. B) Countif. C) Counta. D) COUNTBLANK. Show Answer Correct Answer: C) Counta. ← 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