Question

write any two commands with their function you find in the layout tab of chart tools

Answer 1

Chart tools comprise of two tabs DESIGN and FORMAT.

Step 1 − When you click on a chart, CHART TOOLS comprising of DESIGN and FORMAT tabs appear on the Ribbon.

Design Format

Step 2 − Click the DESIGN tab on the Ribbon. The Ribbon changes to the DESIGN commands.

Design Tab

The Ribbon contains the following Design commands −

Chart layouts group

Add chart element

Quick layout

Chart styles group

Change colors

Chart styles

Data group

Switch row/column

Select data

Type group

Change chart type

Location group

Move chart

In this chapter, you will understand the design commands on the Ribbon.

Answer 2

Answer:

Chart Elements - (Moved in 2013). Drop-Down. The drop-down contains a list of all the individual items that make up the chart that is currently selected. Choosing a particular item will select the corresponding item on the active chart. In 2003 Category Gridlines are selected but in 2007 Category Gridlines is not selected.

Format Selection - (Moved in 2013). Displays the Format dialog box for the item that is currently selected in the "Chart Elements" drop-down.

Reset to Match Style - (Moved in 2013). Clears any custom formatting from the selected element to ensure that the formatting matches the overall theme of the workbook.