Question

1-Color Scales are one of the options under Conditional Formatting.

True

False

2-

After choosing the PivotTable, the PivotChart can be found on the ________ tab.

		Options
		Design
		Layout
		View

7-Solve the problem

To select a chart type in Excel from the Charts group, which tab has to be accessed?

		Insert tab
		Layout tab
		Design tab
		Format tab

Answer 1

1. True

In conditional formatting color scales is one of the options.

2. Options

After creating a pivot table in options or analyze tab we can create the pivot charts.

But in Excel 2016, there is a separate option of pivot chart in the insert tab itself that can also be choosen to do the necessary.

3. Insert Tab

To select a chart type in Excel Click the Insert tab and then under the charts eindow box click the appropriate charts for the data.