Q: 2 Fill in the blanks [10] 1. __________ feature of excel can be used to display only selected data out of the worksheet. 2. In excel conditional formatting tool is available on the ________ group of the Home tab on the ribbon. 3. ____ key from the keyboard is used to selected multiple ranges of cell. 4. A _______________ chart compares trends in data at equal intervals. 5. A __________ chart helps when you want to represent data as percentage of the whole. 6. The keyboard short cut to paste copied text is ______________ 7. When a formula is copied to another cell the cell address adjust automatically with the help of the ________ feature of excel. 8. The arithmetic operator used for exponentiation is _________ 9. __________function in Excel counts the number of cell containing numeric data. 10. ___________refers to arranging data in an order.
Answers
Answer:
Q: 2 Fill in the blanks [10] 1. __________ feature of excel can be used to display only selected data out of the worksheet. 2. In excel conditional formatting tool is available on the ________ group of the Home tab on the ribbon. 3. ____ key from the keyboard is used to selected multiple ranges of cell. 4. A _______________ chart compares trends in data at equal intervals. 5. A __________ chart helps when you want to represent data as percentage of the whole. 6. The keyboard short cut to paste copied text is ______________ 7. When a formula is copied to another cell the cell address adjust automatically with the help of the ________ feature of excel. 8. The arithmetic operator used for exponentiation is _________ 9. __________function in Excel counts the number of cell containing numeric data. 10. ___________refers to arranging data in an order.
1. Data filter
2. format key
3. CTRL
4. bar key
5. A pie chart
6. Ctrl+v
7. relative refrence
9. count function
10. sorting