I need help for those problems.

1.You need to make a chart showing the past year sales results for the university bookstore. Your chart will show the total sales by month for twelve months. Which of the following is the best chart type?

Select one:

a. pie chart

b. line chart

c. scatter chart

d. either line or column chart

2.Which of the following should you do first to create an effective chart in Excel?

Select one:

a. Identify a chart type.

b. Define the message you need to communicate.

c. Determine which values belong on the Y axis.

d. Highlight all the data on your worksheet.

3.Which of the following is the most efficient method for adding labels to each section of a pie chart?

Select one:

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

b. Click the Text Box button in the Layout tab of the Ribbon and add labels next to each section of the chart.

c. Use the Legend button in the Layout tab of the Ribbon to reposition the legend around each section of the chart.

d. Click the Select Data button in the Design tab of the Ribbon to select and arrange specific data points to be placed on the chart.

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.