ICDL Mudules04 Questions Answer 2011

Q06. Write the steps to add a pie chart in the excel document.

Answer:

The steps to add a pie chart in the excel document are as follows-

1.       Open the excel document that contains the data to create the pie chart.

2.       Select the data

3.       Within the Insert tab, in the Charts group, clicking on the Pie icon will display a range of pie chart options.

4.       Choose an option from the drop down list. The pie chart will be inserted into the worksheet.

Q07. Write the steps to change the chart background/column/bar/line/pie color.

Answer:

To change the chart background-

1.       Click on the chart to select it. Right click over an empty part of the chart background.

2.       Select Format Chart Area command from the popup menu displayed. The Format Chart Area dialog box will appear.

3.       In the Fill section, click on the Solid fill button. Some extra controls will be displayed.

4.       Click on the down arrow next to the Color button and select a color from the options displayed.

5.       Click on the Close button to apply the color.

The background color will be changed.

To change column/bar/line or pie color-

1.       Right click over a column/bar/line or pie slice and select Format Data Series command from the pop-up menu.

2.       Select Fill command or Line Color (in case of line chart) command from the Format Data Series dialog box. Click on the Solid fill or Solid line button. Some extra controls will be displayed.

3.       Click on the down arrow next to the Color button and select a color from the options displayed.

4.       Click on the Close button to apply the color.

Thus the color of chart background/column/bar/line or pie can be changed.

Q08. Write the steps to add chart title/axis title/ legend/data labels/data tables.

Answer:

To add chart title, axis title, legend, data labels and data tables we first click on the chart window. Three new tabs of Chart Tools- Design, Layout and Format will be displayed. Click on the Layout tab.

To add chart title-
1. Within the Labels group, click on the Chart Title button. A menu will be displayed allowing to control where and if the chart title is displayed.
2. Select an option to get the title in desired place.

To add axis title-
1. Within the Labels group, click on the Axis Title button. A menu will be displayed allowing to control how the labels for each axis are displayed.
2. Select an option to get the axis title in proper format.

To add legend-
1. Within the Labels group, click on the Legend button. A menu will be displayed allowing to control where and if the chart legend is displayed.
2. Select an option to display the legend in right position.

To add data labels-
1. Within the Labels group, click on the Data Labels button. A menu will be displayed allowing to control where and if the data labels is displayed.
2. Select an option to display the data labels.

To add data tables-
1. Within the Labels group, click on the Data Tables button. A menu will be displayed allowing to control if the data labels is displayed.
2. Select ‘Show Data Table’ or ‘Show Data Table with Legend Keys’ to display data table at the bottom of the chart with or without legend keys.

Q09. Write the steps to add header and footer in the excel document.

Answer:

The steps to add header and footer in the excel document are as follows-

1.       In the Insert tab, within the Text group click on the Header & Footer icon. The header area will be displayed at the top of the worksheet.

2.       Type the text for header in the header area.

3.       Scrolling down the page will display the ‘Click to add footer’ message at the bottom of the worksheet.

4.       Click within the footer area and type the text for footer.

Q10. Write the steps to add printing title on every page.

Answer:

The steps to add printing title on every page are as follows-

1.       Open the document. Within the Page Layout tab, in the Page Setup group, click the Print Titles icon. This will display the Page Setup dialog box showing the Sheet tab.

2.       Within the dialog box, insert the row address in the ‘Rows to repeat at top’ option and insert the column address in the ‘Columns to repeat at left’ option.

3.       Click OK. Now the row and column titles will be printed on every page.