This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 45 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 45 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What does the mouse look like in a spreadsheet? A) Arrow. B) Pointer. C) Two headed arrow. D) Selection cross. Show Answer Correct Answer: D) Selection cross. 2. The function used to get a value of a table vertically is called function ..... A) VLOOKUP. B) HLOOKUP. C) AVERAGE. D) Countif. Show Answer Correct Answer: A) VLOOKUP. 3. Which function can find the highest value in a cell range? A) MAXVALUE. B) HIGHEST. C) TOP. D) MAX. Show Answer Correct Answer: D) MAX. 4. How to open a workbook that has been saved in the way ..... A) Ctrl + O. B) Ctrl + P. C) Ctrl + B. D) Ctrl + D. E) Ctrl + E. Show Answer Correct Answer: A) Ctrl + O. 5. Using the ..... feature, sum of the numbers can be calculated easily. A) Autofill. B) Autoosum. C) All the above. D) None of the above. Show Answer Correct Answer: B) Autoosum. 6. Row headings are represented by ..... A) Alphabets. B) Numbers. C) Alphanumeric. D) None of the above. Show Answer Correct Answer: B) Numbers. 7. In MS Excel, Rows are labeled 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: B) 1, 2, 3 etc. 8. Below that includes the MS-Excel Worksheet is, except ..... A) Menubar. B) Toolbar. C) Titlebar. D) Excelbar. E) All wrong. Show Answer Correct Answer: D) Excelbar. 9. Which menu tab contains the font option in excel 2016? A) File. B) Insert. C) Home. D) View. Show Answer Correct Answer: C) Home. 10. Spreadsheet can perform calculations. A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: A) TRUE. 11. What type of chart will you use to compare performance of two employees in the year 2016? A) Column Chart. B) Line Chart. C) Pie Chart. D) Dot Chart. Show Answer Correct Answer: B) Line Chart. 12. Steps A) Input $\rightarrow$ Process $\rightarrow$ Output. B) Input $\rightarrow$ Output $\rightarrow$ Process. C) Output $\rightarrow$ Process $\rightarrow$ Input. D) None of the above. Show Answer Correct Answer: A) Input $\rightarrow$ Process $\rightarrow$ Output. 13. In spreadsheet, the formula starts with an equal sign. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 14. Where can we find the tabs, groups, and commands in the MS Excel window? A) Ribbon. B) Quick access toolbar. C) Name box. D) None of the above. Show Answer Correct Answer: A) Ribbon. 15. The number of rows and columns in Microsoft Excel 2013 is ..... A) 1, 048, 576 and 16, 384. B) 16, 384 and 1, 048, 576. C) 16, 333 and 10, 048. D) 65, 576 and 253. Show Answer Correct Answer: A) 1, 048, 576 and 16, 384. 16. Multiple Worksheet makes a ..... A) Sheet Tab. B) Work book. C) Spreadsheet. D) None of the above. Show Answer Correct Answer: B) Work book. 17. Each box in the spreadsheet is called? A) Kotak. B) Line. C) Column. D) Sel. Show Answer Correct Answer: D) Sel. 18. Short key to save as on an excel worksheet is A) F12. B) ALT + F4. C) Fg. D) FZ. Show Answer Correct Answer: A) F12. 19. The function in the excel used calculates the number of a group of values ..... A) AVERAGE. B) MIN. C) SUM. D) COUNT. E) MAX. Show Answer Correct Answer: C) SUM. 20. ..... function is used to find the maximum value A) Min. B) Max. C) Average. D) Percentage. Show Answer Correct Answer: B) Max. 21. Paying your bills on time will help you increase your credit score A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 22. Which formula would you use to calculate how many sales are over $ 20 from a series. A) Sum. B) SUMIF. C) Count. D) Countif. Show Answer Correct Answer: D) Countif. 23. What do you call the document created using spreadsheet program? A) WORKBOOK. B) DOCUMENT. C) All the above. D) None of the above. Show Answer Correct Answer: A) WORKBOOK. 24. Ctrl + S button, functioning for A) Keep files. B) Doubling the data. C) Open files. D) Move data. Show Answer Correct Answer: A) Keep files. 25. (*) The sign is a sign of the calculation operation ..... A) Addition. B) Reduction. C) Multiplication. D) Distribution. Show Answer Correct Answer: C) Multiplication. ← 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