I need help for those problems.

1.You need to make a chart showing the past year sales results for the university bookstore. Your chartwillshowthetotalsalesbymonthfortwelvemonths.Whichofthefollowingisthebestchart type?

Select one:

a.piechart

b.linechart

c.scatterchart

d.either line or columnchart

2.WhichofthefollowingshouldyoudofirsttocreateaneffectivechartinExcel?

Select one:

a.Identify a charttype.

b.Define the message you need tocommunicate.

c.Determine which values belong on the Yaxis.

d.Highlight all the data on yourworksheet.

3.Whichofthefollowingisthemostefficientmethodforaddinglabelstoeachsectionofa piechart?

Select one:

a.Select a Layout from the Quick Layout button in the Chart Layout tab of theRibbon.

b.ClicktheTextBoxbuttonintheLayouttaboftheRibbonandaddlabelsnexttoeachsectionof thechart.

c.UsetheLegendbuttonintheLayouttaboftheRibbontorepositionthelegendaroundeach section of the chart.

d.ClicktheSelectDatabuttonintheDesigntaboftheRibbontoselectandarrangespecific data points to be placed on thechart.

4.You have established a personal budget for your household. The spending section of the budget is broken down into five major categories. To show how the percent of total for each spend category has changed over a three-year period of time, it would be best to use which of the following chart types?

Select one:

a.column chart

b.line chart

c.stacked column chart

d.pie chart

5.You need to format the numbers along the Y axis of a column chart to US dollars with zero decimal places. Which of the following describes the method that would allow you to accomplish this?

Select one:

a.Activate the Y axis and use any of the number formatting commands in the Home tab of the Ribbon.

b.Activate the Y axis and click the Data Labels button in the Add Chart Element of the Chart Tools Design Ribbon..

c.Activate the Y axis and click the Format Selection button in the Format tab of the Chart Tools Ribbon.

d.Activate the Y axis and click the Axis Titles button in the Layout tab of the Ribbon.

6.Which of the following statements is accurate with regard to changing the color of a data series on a column chart?

Select one:

a.Right click one bar on the column chart plot area to activate all bars for that data series. Select Format Data Series from the drop-down. Click the Paint can in the Format Data Series, select Fill Color button and select a color.

b.Click one bar on the column chart plot area twice to activate all bars for that data series. Click the Shape Fill button in the Format tab of the Ribbon and select a color.

c.Click the Legend one time and then click the name of the data series to activate it. Click the Shape Fill button in the Format tab of the Ribbon and select a color.

d.Both A and C are valid methods for changing the color of a data series.