1. Which of these is known as the horizontal axis of a chart?
Ans-X-axis
2. Which of these display data in the form of a circle?
Ans-pie chart.
3. Which of these is used to insert a chart instantly in a worksheet?
Ans-F11
4. Which of these are the miniature that fit into a single cell?
Ans-Sparklines
5. Which key is used to group multiple worksheet?
Ans-ctrl
B. Fill in the blanks.
1.The chart indicate the aim and contain of a chart.
2. The y-axis is also known as value axis.
3.The doughnutchart shows the relationship of proportions part to a whole.
4. After inserting a chart the design and format Tab appear on the ribbon under thesparkline contexual tab.
5. The ad chart element option is available in theinsert tab tab.
C. Write to and false statements.
1. A is pictorial representation of data false
2. Once a charts is inserted in a worksheet it cannot be modified.false.
3. In most of the chart type value are plotted on the y axis true.
4. A pi chart can represent multiple data series.false.
5. Consolidation help in combining the data of multiple worksheets true.
D. Answer the following questions.
1. What is a chat? Describe any two component of a chart.
Ans- The different components of charts are as follows: 1) Chart area: This is the area where the chart is inserted. 2) Data series: This comprises of the various series which are present in a chart i.e., the row and column of numbers present. 3) Axes: There are two axes present in a chart.
2. Differentiate between a column chart and a bar chart.
Ans- Column and Bar charts are effectively the same. The difference is that Column charts display vertical columns and Bar charts display horizontal bars. On a Column chart, the values are on the vertical (y) axis, while on a Bar chart, the values are on the horizontal (x) axis.
3. What is a combo chart? Name the most popular type of combo chat.
Ans- a combo chart refer to a single chart that is a combination of two different chart. To create a combo chart you need multiple value access. The most popular example of combo chart is a combination of the line and column chart.
4. Define the term is sparkline.
Ans- A sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values.
5. Explain the utility of grouping the worksheet.
Ans- You can quickly perform tasks on multiple worksheets at the same time by grouping worksheets together. If you group a set of worksheets, any changes you make on one worksheet are made in all the other worksheets in the group in the exact same location on the worksheets.
Ok sirr
ReplyDeleteThanks sir
ReplyDeleteThanks Sir
ReplyDeleteMy work is done