Page 49 - 2619_PlusGPT V2.1_C-8
P. 49
c. Chart area includes all objects and elements in a chart. ____________
d. You cannot sort more than one columns at a time in a selected range of cells. ____________
e. We cannot create Bar chart in Excel. ____________
4. Short answer type questions.
a. What are gridlines?
_________________________________________________________________________________
b. Define legend.
_________________________________________________________________________________
c. What is Bar chart?
_________________________________________________________________________________
d. What is Area chart?
_________________________________________________________________________________
e. How do you remove filters?
_________________________________________________________________________________
_________________________________________________________________________________
5. Long answer type questions.
a. What are the differences between line chart and XY scatter chart?
_________________________________________________________________________________
_________________________________________________________________________________
_________________________________________________________________________________
b. Explain any 5 components of a chart.
_________________________________________________________________________________
_________________________________________________________________________________
_________________________________________________________________________________
c. Write the steps to change the chart type.
_________________________________________________________________________________
_________________________________________________________________________________
_________________________________________________________________________________
d. What is the difference between sorting data and filtering data?
_________________________________________________________________________________
_________________________________________________________________________________
_________________________________________________________________________________
Google Sheets (Advanced- Sorting, Filtering & Charts) 47

