USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -To do so, he can click on the following: Sparkline chart > Design > Styke (choose a style). Binay wants to create an X-Y scatter plot. To do so, he should select the data he wants to plot in the scatter chart, then click the Insert Tab, and then click Insert Scatter (X, Y) or Bubble Chart.
Detailed explanation-2: -Select “Scatter” from the options in the “Recommended Charts” section of your ribbon. Excel will automatically create a scatter plot for you in the same sheet as your data, using the first column of your dataset as the horizontal (X) axis, and the second column as your vertical (Y) axis.
Detailed explanation-3: -A scatter chart, also called a scatter plot, is a chart that shows the relationship between two variables.
Detailed explanation-4: -Select the data you want to plot in the chart. Click the Insert tab, and then click X Y Scatter, and under Scatter, pick a chart. With the chart selected, click the Chart Design tab to do any of the following: Click Add Chart Element to modify details like the title, labels, and the legend.