This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 67 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 67 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. The bar which contains the value of active cells: A) Title bar. B) Formula bar. C) Status bar. D) Bar menu. Show Answer Correct Answer: B) Formula bar. 2. Which of the following formulas show the correct use of the SUM function? A) -Sum (H3-H10). B) = Sum (H3:H10). C) = Sum (H3 H10). D) +Sum (H3:H10). Show Answer Correct Answer: B) = Sum (H3:H10). 3. After entering data in a cell, press: A) Shift. B) Enter. C) Spacebar. D) Category. Show Answer Correct Answer: B) Enter. 4. The example of the application below that is not a number processing application program is ..... A) Lotus 123. B) Open Office Calc. C) Star Office Writer. D) Microsoft Excel. E) Kingsoft Spreadsheet. Show Answer Correct Answer: C) Star Office Writer. 5. The web pages are joined together by ..... ..... A) Web browser. B) Hyperlinks. C) Lists. D) Linkwork. Show Answer Correct Answer: B) Hyperlinks. 6. True or FalseWe can change the text in a cell A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: A) TRUE. 7. Which below is an example of writing the correct country formula? A) =COUNTIFS(Soto; Madura; "B2:B9"; "C2:C9"). B) =COUNTIFS(B2:B9; "Soto"; "C2:C9"; "Madura"). C) =COUNTIFS("Soto"; "Madura"; B2:B9; C2:C9). D) =COUNTIFS(B2:B9; C2:C9; "Soto"; "Madura"). Show Answer Correct Answer: B) =COUNTIFS(B2:B9; "Soto"; "C2:C9"; "Madura"). 8. The word processing program is called ..... A) Word Processing. B) Spreadsheet. C) Database. D) Multimedia. E) Programming. Show Answer Correct Answer: A) Word Processing. 9. Office 2010 is a successor of: A) Office 2009. B) Office 2008. C) Office 2007. D) Office XP. Show Answer Correct Answer: C) Office 2007. 10. A program using a table comprising of rows, columns and cells. A) MS Word. B) MS PowerPoint. C) MS Outlook. D) MS Excel. Show Answer Correct Answer: D) MS Excel. 11. A definite step by step procedure to solve a problem is called ..... A) Step. B) Program. C) Process. D) Algorithm. Show Answer Correct Answer: D) Algorithm. 12. A 2-year degree is called an "Associate's" degree. A 4-year degree is called a ..... degree A) Doctoral. B) Honors Degree. C) Associate's. D) Bachelor's. Show Answer Correct Answer: D) Bachelor's. 13. The group from the active cell is named ..... A) Column. B) Row. C) Range. D) Workbook. E) Sheet. Show Answer Correct Answer: C) Range. 14. Function from Ms.Excel used to calculate the number of an interval with the desired condition is A) Countif. B) DCOUNT. C) SUMIF. D) SUM. Show Answer Correct Answer: A) Countif. 15. The rectangular shaped area on a worksheet that is created by the intersection of columns and rows. A) Cell Address. B) Cell Grid. C) Cell. D) Active Cell. Show Answer Correct Answer: C) Cell. 16. What is the shortcut key to insert a new Row/Column in Excel? A) Ctrl + '+'. B) Ctrl + '-'. C) Shift + '+'. D) Shift + '-'. Show Answer Correct Answer: A) Ctrl + '+'. 17. The formula used to add up data on Microsoft Excel is ..... A) =COUNT( ). B) = Countif ( ). C) =SUM( ). D) = Sumif ( ). Show Answer Correct Answer: C) =SUM( ). 18. Father of electronic spreadsheet ..... A) Eric Thompson. B) And Beats. C) And Bricklin. D) None of the above. Show Answer Correct Answer: C) And Bricklin. 19. A worksheet in Excel contains only 100 rows. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 20. In Excel, Columns are labelled as ..... A) A, B, C, etc. B) 1, 2, 3 etc. C) A1, A2, etc. D) $ A$ 1, $ A$ 2, etc. Show Answer Correct Answer: A) A, B, C, etc. 21. The ..... feature is used to arrange aseries of values alphabetically and numerically. A) Sort. B) Filter. C) All the above. D) None of the above. Show Answer Correct Answer: A) Sort. 22. A calculation that is performed on one or more variables. Must always start with an = sign A) Formula. B) Cell. C) Spreadsheet. D) Worksheet. Show Answer Correct Answer: A) Formula. 23. Collection of worksheets is called A) Sheet tab. B) Active cell. C) Workbook. D) Cells. Show Answer Correct Answer: C) Workbook. 24. To set the writing in the column so that in the middle position of a column is A) Center + Top Align. B) Center + Middle Align. C) Center + Bottom Align. D) Align Text Left. E) Align Text Right. Show Answer Correct Answer: B) Center + Middle Align. 25. To insert text objects on the word in the form of images using commands ..... A) Insert$\rightarrow$ Picture. B) Insert$\rightarrow$ Table. C) Insert$\rightarrow$ Shape. D) Insert$\rightarrow$ Chart. E) Insert$\rightarrow$ SmartArt. Show Answer Correct Answer: A) Insert$\rightarrow$ Picture. ← 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