DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Chart Dialog Square
|
|
|
Pivot Chart
|
|
|
Sample Chart
|
|
|
Recommended Chart
|
|
|
None
|
Detailed explanation-1: -Go to Insert > Recommended Charts, and Excel will load the Recommended Charts pane. Select the Try sample data button. Excel will add some sample data to your worksheet, analyze it, then add recommended charts to the pane.
Detailed explanation-2: -Excel displays recommended charts based on the data in the cells selected. You can hover over each one to see what looks good for your data.
Detailed explanation-3: -Excel Column Charts. One of the most common charts used in presentations, column charts are used to compare values to one another. Usually, these are values that have been categorized in some way. The most common subset of column charts is one set of data broken up into categories.
Detailed explanation-4: -Depending on the data you have, you can create a column, line, pie, bar, area, scatter, or radar chart. Click anywhere in the data for which you want to create a chart. To plot specific data into a chart, you can also select the data. Select Insert > Charts > and the chart type you want.