In Excel the chart tools provides which three different options for formatting?
Answer & explanation
Correct answer: option 2
Correct answer: Option (2) → Design, Layout and Format
Concept: When a chart is selected in Excel, the Chart Tools appear with three tabs for formatting – per Graphs and Charts for Business Data.
Clicking anywhere in a chart displays the Chart Tools, adding the Design, Layout and Format tabs, which together let you change the chart type/style, add chart elements and format the shapes. Hence the three formatting options are Design, Layout and Format.