This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 43 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 43 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. A formula and a function are the same thing A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 2. In Microsoft Excel the part used to fill in the formula or calculation is A) Formula Bar. B) Tittle bar. C) Name Box. D) Tool Bar. Show Answer Correct Answer: A) Formula Bar. 3. Cell reference ..... A) The column number and row letter for one cell. B) The column letter and column number for one cell. C) The column letter and row number for one cell. D) The column letter and row number for two cells. Show Answer Correct Answer: C) The column letter and row number for one cell. 4. When is a MS Excel Spreadsheet used? A) Making a Drawing. B) When Reading. C) For Collecting Information. D) For Baking a Cake. Show Answer Correct Answer: C) For Collecting Information. 5. The first version of Ms.Office Excel is released what year? A) 1990. B) 1987. C) 1985. D) 1992. Show Answer Correct Answer: B) 1987. 6. To edit something on a worksheet you need to select this first? A) Columns. B) Rows. C) Cell Range. D) None of the above. Show Answer Correct Answer: C) Cell Range. 7. What is a rectangular box in a MS EXCEL Spreadsheet called? A) Row. B) Column. C) Cell. D) None of the above. Show Answer Correct Answer: C) Cell. 8. Rows are ..... A) Lettered. B) Numbered. C) All the above. D) None of the above. Show Answer Correct Answer: B) Numbered. 9. Google doc is much similar to which application? A) MS-powerpoint. B) MS-outlook. C) MS-Excel. D) MS-word. Show Answer Correct Answer: D) MS-word. 10. In Excel it means Add A) Plus sign. B) Sort. C) Forward slash. D) Asterisk. Show Answer Correct Answer: A) Plus sign. 11. One of its important features is the use of formulas to make computations. A) MS Excel. B) MS Word. C) MS Powerpoint. D) None of the above. Show Answer Correct Answer: A) MS Excel. 12. Combination of an absolute and a relative cell A) Relative Reference. B) Absolute Reference. C) Mixed Reference. D) None of the above. Show Answer Correct Answer: C) Mixed Reference. 13. Excel would be the ideal program to type out a book report. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 14. The extension of Microsoft Excel is ..... A) *.png. B) *.ppt. C) *.doc. D) *.xls. Show Answer Correct Answer: D) *.xls. 15. A combination of numbers and symbols used to express a calculation. Always begins with an = sign. A) Cell Address. B) Worksheet. C) Formula. D) None of the above. Show Answer Correct Answer: C) Formula. 16. ..... is composed of rows and columns. A) Spreadsheet. B) Worksheet. C) Tracking Sheet. D) Transaction Sheet. Show Answer Correct Answer: B) Worksheet. 17. What is the extension of the MS-Excel 2016 file? A) .xlsx. B) .xls. C) .doc. D) .docx. Show Answer Correct Answer: A) .xlsx. 18. Which character is used in a spreadsheet formula to represent division? A) !. B) -. C) /. D) *. Show Answer Correct Answer: C) /. 19. To save youe excel sheet you need to click on A) File >Save as. B) File >Print. C) Inser >Save as. D) None of the above. Show Answer Correct Answer: A) File >Save as. 20. IT LETS YOU ENTER OR EDIT DATA, FORMULA OR A FUNCTION IN ANY CELL. A) FORMULA TAB. B) FORMULA GROUP. C) FORMULA BAR. D) FORMULA RIBBON. Show Answer Correct Answer: C) FORMULA BAR. 21. We use this to 'lock in' a value in a cell so that replicating formula is accurate. A) Named cell. B) Cell reference. C) Same cell. D) The cell. Show Answer Correct Answer: A) Named cell. 22. What symbol should be used to perform an adding calculation? A) +. B) -. C) *. D) /. Show Answer Correct Answer: A) +. 23. All functions on Google Sheet begin with symbols? A) +. B) -. C) =. D) %. Show Answer Correct Answer: C) =. 24. Which shows the beginning and end of a flowchart, is ..... A) Decision. B) Data. C) Terminator. D) Process. Show Answer Correct Answer: C) Terminator. 25. Sort the contents of the cell from small up or a-z called A) Ascending. B) Descending. C) Sorting. D) Format. Show Answer Correct Answer: A) Ascending. ← 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