This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 40 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 40 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the correct order for the parts that make up a Cell Reference? A) Letter then Number. B) Number then Letter. C) All the above. D) None of the above. Show Answer Correct Answer: A) Letter then Number. 2. What function was used to find the highest data? A) AVERAGE. B) MIN. C) SUM. D) MAX. Show Answer Correct Answer: D) MAX. 3. What is the extension of spreadsheet? A) .html. B) .doc. C) .pptx. D) .xls. Show Answer Correct Answer: D) .xls. 4. The Filter function icon can be found in ..... tab. A) Home. B) Insert. C) Data. D) View. Show Answer Correct Answer: C) Data. 5. Consider the following statement! (1) Microsoft Word (2) Microsoft Excel (3) Microsoft Power Point (4) Open Office Calcprogram The number processing application from the statement above is ..... A) , (2). B) , (4). C) , (3). D) , (4). E) , (4). Show Answer Correct Answer: B) , (4). 6. Under which tab on the Excel 2016 Ribbon will you find the Spelling checker option? A) Under the Data tab. B) Under the View tab. C) Under the Formulas tab. D) Under the Review tab. Show Answer Correct Answer: D) Under the Review tab. 7. ..... appear at the bottom of the Excel window. A) Title bar. B) Formula bar. C) Work sheet tabs. D) Name box. Show Answer Correct Answer: C) Work sheet tabs. 8. Which component of MS Excel displays the address of the active cell? A) Formula bar. B) Name box. C) Row header. D) Column header. Show Answer Correct Answer: B) Name box. 9. The function used to calculate the biggest value of the number data A) Sum. B) Max. C) Average. D) Min. Show Answer Correct Answer: B) Max. 10. The type of a networking specific to only users of an organization is called A) Infranet. B) Internet. C) Intranet. D) Net and net. Show Answer Correct Answer: C) Intranet. 11. Internet stands for? A) Internet Network. B) International Network. C) Internet Net. D) Internet Networknet. Show Answer Correct Answer: B) International Network. 12. Concatenation (joins text) A) /. B) &. C) *. D) None of the above. Show Answer Correct Answer: B) &. 13. MS-Excel-2013 Having ..... Rows & ..... Column A) 10, 48, 576 & 16, 384. B) 10, 16, 384 & 10, 48, 576. C) 10, 38, 586 & 16, 383. D) None of the above. Show Answer Correct Answer: A) 10, 48, 576 & 16, 384. 14. Can you enter images into Google Sheets? A) Can. B) Can't. C) All the above. D) None of the above. Show Answer Correct Answer: A) Can. 15. The intersection of a column and row is a A) Connection Point. B) Cell. C) Box. D) Insertion Point. Show Answer Correct Answer: B) Cell. 16. EACH TAB IS DIVIVDED INTO NUMBER OF SECTIONS CALLED ..... A) FILES. B) BUTTONS. C) GROUPS. D) RIBBON. Show Answer Correct Answer: C) GROUPS. 17. What is meant by spreadsheet ..... A) Number processing program. B) Word processing program. C) Graphic processing program. D) Voice processing program. Show Answer Correct Answer: A) Number processing program. 18. Error in your formula A) #div/0!. B) Autofill. C) #name?. D) Columns. Show Answer Correct Answer: C) #name?. 19. What kind of software is Excel? A) Word processing software. B) Spreadsheet Software. C) Data Base Software. D) None of the above. Show Answer Correct Answer: B) Spreadsheet Software. 20. Typed text showed in active cell and also in ..... A) Formula Bar. B) Ribbon. C) Scroll Bar. D) Title Bar. Show Answer Correct Answer: A) Formula Bar. 21. Benefits of ICT? A) Fashion. B) Type. C) Effectiveness & efficiency. D) Join the trend. Show Answer Correct Answer: C) Effectiveness & efficiency. 22. The basic unit of a worksheet into which you enter data in Excel is called a A) Cell. B) Table. C) Box. D) Column. Show Answer Correct Answer: A) Cell. 23. What do we call the horizontal line of cells labeled using numbers? A) Horizontal. B) Rows. C) Column. D) None of the above. Show Answer Correct Answer: B) Rows. 24. In Excel, F12 key is used for A) SAVE. B) RENAME. C) CLOSE. D) OPEN. Show Answer Correct Answer: A) SAVE. 25. If I want to find an average of cells A1 through A25, which formula would I use? A) =average(A1:A25). B) =avg(A1:A25). C) =average(A1-A25). D) =avg(A1-A25). Show Answer Correct Answer: A) =average(A1:A25). ← 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