This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 12 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 12 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Gridlines and formula bar which tab in MS Excel? A) Home Tab. B) Insert Tab. C) Data Tab. D) View Tab. E) Page Layout. Show Answer Correct Answer: D) View Tab. 2. Which symbol must you use to begin a formula? A) +. B) =. C) /. D) *. Show Answer Correct Answer: B) =. 3. Intersection of a row and a column in excel is called a ..... A) Value. B) Address. C) Cell. D) None of the above. Show Answer Correct Answer: C) Cell. 4. Which is NOT a term used in Excel? A) Workbook. B) Worksheet. C) Cell. D) Document. Show Answer Correct Answer: D) Document. 5. Tables can be made using the format command, Cells followed by ..... A) Font. B) Border. C) Pattern. D) Protection. E) Number. Show Answer Correct Answer: B) Border. 6. Absolute references are created by using A) $. B) #. C) @. D) %. Show Answer Correct Answer: A) $. 7. Which is not included in the components in MS.Excel is ..... A) Ribbon menu. B) Sel. C) Column. D) Subscribe. Show Answer Correct Answer: D) Subscribe. 8. What is name of last column? A) XFD. B) XDF. C) XZ. D) XF. Show Answer Correct Answer: A) XFD. 9. What type of chart is useful for showing trends or changes over time? A) Pie Chart. B) Column Chart. C) Line Chart. D) Dot Graph. Show Answer Correct Answer: C) Line Chart. 10. In Ms Excel you can change the colour of the cell using fill colour tool. A) False. B) True. C) All the above. D) None of the above. Show Answer Correct Answer: B) True. 11. Samantha needs to total the values in cells A1 to A10. What is the most efficient method to find the answer? A) Formula. B) Function. C) Label. D) Value. Show Answer Correct Answer: B) Function. 12. Numbers in Excel are known as ..... A) Values. B) Labels. C) Numbers. D) None of the above. Show Answer Correct Answer: A) Values. 13. What is meant by the basic formula in Excel? A) The formula used to do mathematical calculations or data manipulation in Excel cells. B) The formula used to delete data in Excel. C) The formula used to change the appearance of cells in Excel. D) The formula used to combine cells in Excel. Show Answer Correct Answer: A) The formula used to do mathematical calculations or data manipulation in Excel cells. 14. ..... is an another name of spreadsheet. A) Worksheet. B) Workbook. C) Cell. D) Both (a) and (b). Show Answer Correct Answer: A) Worksheet. 15. To carry on the data over the coloumn we use A) Fill it now feature. B) Fill Handle feature. C) All the above. D) None of the above. Show Answer Correct Answer: B) Fill Handle feature. 16. Which of the following is not a correct cell address? A) May. B) Ah. C) BB15. D) All of the above. Show Answer Correct Answer: A) May. 17. You can select the current row in MS-Excel Worksheet by pressing? A) Ctrl + Space bar. B) F8 + arrow key. C) Shift + arrow key. D) Shift + Space bar. Show Answer Correct Answer: D) Shift + Space bar. 18. Various programs that contain related instructions to operate computers or related hardware are ..... A) Software. B) Hard Disk. C) Touch Pad. D) Flash Disk. E) Hardware. Show Answer Correct Answer: A) Software. 19. What is the default justification for cells formatted as labels? A) Right aligned. B) Left aligned. C) Center. D) 1 inch. Show Answer Correct Answer: B) Left aligned. 20. Full form of URL is? A) Uniform Resource Locator. B) Uniform Resource Link. C) Uniform Registered Link. D) Unified Resource Link. Show Answer Correct Answer: A) Uniform Resource Locator. 21. Excel Function Addition Using Formula ..... A) SUM. B) MAX. C) AVERAGE. D) MIN. Show Answer Correct Answer: A) SUM. 22. What specific format would change 2.5 to £2.50? A) Currency. B) Date. C) Number. D) Time. Show Answer Correct Answer: A) Currency. 23. A range always ..... in shape A) Square. B) Rectangle. C) Triangle. D) I don't care. Show Answer Correct Answer: B) Rectangle. 24. Computer hardware is also called ..... A) Hardware. B) Software. C) Brainware. D) Malware. Show Answer Correct Answer: A) Hardware. 25. Animated ..... are the images that move. A) Movie. B) GIF. C) Image. D) Video. Show Answer Correct Answer: B) GIF. ← 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