This document is a reinforcement worksheet for Class 9 Computer Applications focused on MS Excel. It includes multiple-choice questions, fill-in-the-blank statements, and short answer questions covering various Excel functionalities such as chart creation, formulas, functions, and data representation. The worksheet aims to enhance students' understanding and application of Excel tools and features.
This document is a reinforcement worksheet for Class 9 Computer Applications focused on MS Excel. It includes multiple-choice questions, fill-in-the-blank statements, and short answer questions covering various Excel functionalities such as chart creation, formulas, functions, and data representation. The worksheet aims to enhance students' understanding and application of Excel tools and features.
This document is a reinforcement worksheet for Class 9 Computer Applications focused on MS Excel. It includes multiple-choice questions, fill-in-the-blank statements, and short answer questions covering various Excel functionalities such as chart creation, formulas, functions, and data representation. The worksheet aims to enhance students' understanding and application of Excel tools and features.
This document is a reinforcement worksheet for Class 9 Computer Applications focused on MS Excel. It includes multiple-choice questions, fill-in-the-blank statements, and short answer questions covering various Excel functionalities such as chart creation, formulas, functions, and data representation. The worksheet aims to enhance students' understanding and application of Excel tools and features.
Set 1: MS EXCEL 1. Steve is working on excel sheet. He wants to add pie chart in his sheet. Which one of the following steps Steve needs to performs to open Chart Wizard? A) Insert -> Picture -> Chart B) Insert -> Chart C) File -> Chart D) Tools -> Chart 2. MS Excel enables you to perform complex calculations easily. Which of the following calculations you can perform in excel sheet? A) Average B) Add C) Count D) All of these 3. .......................... short cut keys allow to quickly select the entire range of cells. A) CTRL + SHIFT + * B) CTRL + SHIFT + A C) SHIFT + A D) CTRL + A 4. Which one of the following options allows you to edit the styles of text, numbers and pages based on conditions in MS Excel? A) Style formatting B) Conditional formatting C) Editing D) Conditional designing 5. Which of the following functions are available in MS Excel? A) PRODUCT B) SUM C) AVERAGE D) All of these 6. Data represented in a worksheet can be easily understood by: A) Database B) Letter C) Chart D) Symbol 7. Which one of the following charts generated from a football statistics spreadsheet could compare the performance of the team from year to year? A) Bar B) Area C) Pie D) Scattergram 8. The AutoFill can apply from A) left to right B) right to left C) up to down D) All of these 9. The default page orientation in Excel is A) Landscape B) Horizontal C) Portrait D) None of these 10. Cell address $B$5 in a formula means A) it is a mixed reference B) it is an absolute reference C) it is a relative reference D) None of the above
Fill in the blanks:
11. Excel is a ………………. software package. 12. When you …………. or ……………. , the selected range gets surrounded by a moving border. 13. The …………. and …………… operations copies data from source range to target range and erases it from the source range. 14. Address of the cell at 10th column and 30th row is ……………… 15. The cell having bold boundary is the …………….. 16. Any formula in Excel starts with an …………….. 17. The keyboard shortcut for copy is ……………. and for paste is ………………..
Answer the following:
18. In a spreadsheet software, the formula =A1 +$A$2 was entered in cell A3 and then copied into cell B3. What is the formula copied into B3? 19. Write down the formula for adding values of cells A1 to A5. 20. State difference between COUNT() and COUNTA() function. 21. Hansika wants to apply MIN function on a cell range, but all the values in that range are of Boolean. What value will be returned by the MIN function? 22. Why we cannot add titles to an embedded chart once chart is ready? 23. Write down the importance of legend in charts. 24. Define the meaning of formula. 25. Suggest the appropriate functions for the following situations: For returning the minimum value out of a range A1 to C5. For determining whether the customer is eligible for discount or not from the bill amount stored in cell D5. A customer is eligible for discount if bill amount >5,000. 26. Suggest the appropriate function for the following situations: Selecting the maximum value out of a range A1 to B20. Calculating average of marks entered in cells E5, F5, G5, H5 and 15. Determining whether the student has passed (if scored > = 40) or not from the marks stored in cell J10. 27. Explain the concept of cell referencing along with its various types. 28. Explain any five functions that can be used in a worksheet. 29. Write down the name and purpose of various components of a chart.
