DATABASE FUNDAMENTALS
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
NOW
|
|
|
Recommended Charts
|
|
|
thumbnail
|
|
|
Greater than
|
Detailed explanation-1: -If you’re exploring charts in Excel and having a hard time figuring out which one is right for you, then you can try the Recommended Charts command on the Insert tab. Excel will analyze your data and make suggestions for you. Select the data you want to use for your chart. Click Insert > Recommended Charts.
Detailed explanation-2: -Selecting the right chart type Ask yourself how many variables do you want to show, how many data points you want to display and how you want to scale your axis. Line, bar and column charts represent change over time. Pyramids and pie charts display parts-of-a-whole.
Detailed explanation-3: -Donut and pie charts are great choices to show composition when simple proportions are useful. Area charts put the composition of data within the context of trends over time. Stacked bar, percent, and column charts show an overview of the data’s composition.
Detailed explanation-4: -Line Chart: The line chart is one of the most frequently used chart types, typically used to show trends over a period of time. If you need to chart changes over time, consider using a line chart.