FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
If you want Microsoft Excel to suggest a chart for your data, use the ____ feature.
A
Chart Dialog Square
B
Pivot Chart
C
Sample Chart
D
Recommended Chart
E
None
Explanation: 

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: -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.

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: -To review a set of recommend charts for your data, press R and then C. The Recommended Charts pane opens showing a list of charts customized to showcase your data. Use the Down and Up arrow keys to browse the list and then press Enter to select the recommended chart type.

There is 1 question to complete.