FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

John wants to be able to view his monthly sales chart as well as his dataon the same worksheet. What type of chart should he create?

A	PivotChart
B	LineChart
C	Embedded Chart
D	Linked Chart

Explanation:

Detailed explanation-1: -A PivotTable is an interactive way to quickly summarize large amounts of data. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data. A PivotTable is especially designed for: Querying large amounts of data in many user-friendly ways.

Detailed explanation-2: -To move the chart to a new worksheet, click New sheet, and then in the New sheet box, type a name for the worksheet. To move the chart as an object in another worksheet, click Object in, and then in the Object in box, select the worksheet in which you want to place the chart.

Detailed explanation-3: -A chart sheet is an Excel chart that is displayed on its own sheet in the workbook.

There is 1 question to complete.