Question

1. how would you change the colors in a chart?

click on the chart, click on the data tab.
select the data on the worksheet, right click and choose format cells...
click on the chart, right click and choose format...
click on the chart, click on the insert tab.

Explanation:

To change the colors in a chart, you need to access the formatting options specific to the chart. Right - clicking on the chart and choosing "Format..." is the correct way as it provides chart - specific formatting settings (including color changes). Clicking on the Data tab or Insert tab does not directly lead to chart color - changing options. Selecting data on the worksheet and formatting cells changes the cell formatting (not chart formatting).

Answer:

Click on the chart, right click and choose Format...