2.How will you add the following chart elements in a chart?
a. Data legend
b. Gridlines
3. How can you format the Plot Area of a chart?
4. Write down the steps used to format the Data Series in a chart.
5. Write down the steps to format the legend.
6. What do you mean by Combination Chart? Explain with the help of example.
7. What is the purpose of Consolidating Data? Explain the steps with example.
8. How will you group and ungroup the worksheets? Explain in detail.
9. How can you add tiny charts in a cell? Explain in detail
10. What so you mean by Goal Seek? Explain with the help of example.
Answers
Answer:
answer of 2nd
(a) data legend
Answer of 3rd
The easiest way to select the chart area is to click just below the top edge of the chart. The Chart Elements menu on the Format tab of the ribbon, and the Format Task pane title will confirm the chart area is selected. Once the chart area is selected, you can make a variety of formatting changes
Answer of 4th
Step 1 − Right-click any of the data series of your chart and then click Format Data Series.
Step 2 − Select the required Series Options. You can edit the display of the series through these options.
Answer of 5th
Click the chart, and then click the Chart Layout tab. To change the position of the legend, under Labels, click Legend, and then click the legend position that you want. To change the format of the legend, under Labels, click Legend, click Legend Options, and then make the format changes that you want.
Answer of 6th
A Combination or dual Y-axis has multiple series and dual axes. For example, where two charts share a common category axis (region) and may have more than one quantitative axis (Y-axis), each representing a different scale of values (revenue and profit)
Answer of 7th
Data consolidation refers to the collection and integration of data from multiple sources into a single destination. During this process, different data sources are put together, or consolidated, into a single data store. Open all three workbooks
Answer of 8th
1st point ------ Select the first worksheet you want to include in the worksheet group.
2nd point --------- Press and hold the Ctrl key on your keyboard.
3rd point ----------- Select the next worksheet you want in the group.
4th point ------------ Release the Ctrl key. The worksheets are now grouped.
Answer of 9th
1st point ---------- Select the cell in which you want to insert these tiny charts
2nd point ----------- Go to Insert-->Sparkline-->
3rd point ------------ Click on the chart type you want.
4th point ------------ Create Sparkline dialog box will open. Select the data range. It should be one dimensional (horizontal or vertical).
5th point ------------ Hit OK.
Answer of 10th
Goal seeking is a general term used to describe the process involved in figuring out your input value based on an already known output value. The process involves using a specific operator in a formula, which can be calculated using computer software.
pls mark me as brainlist and pls follow me