USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
PivotChart
|
|
|
PivotTable
|
|
|
plot area
|
|
|
axis
|
Detailed explanation-1: -A highly configurable table that condenses large amounts of data. A PivotTable is used to analyze and display numerical data in detail and to answer unforeseen questions about data.
Detailed explanation-2: -Scatter charts show the relationships among the numeric values in several data series, or plot two groups of numbers as one series of xy coordinates. Scatter charts are typically used for displaying and comparing numeric values, such as scientific, statistical, and engineering data.
Detailed explanation-3: -Column charts are useful for showing data changes over a period of time or for illustrating comparisons among items.
Detailed explanation-4: -Area charts are useful for emphasizing the magnitude of change over time. Stacked area charts are also used to show the relationship of parts to the whole.
Detailed explanation-5: -The Sum function is used by default for numeric value fields you place in your PivotTable, but here’s how to choose a different summary function: In the PivotTable, right-click the value field you want to change, and then click Summarize Values By. Click the summary function you want.