ICDL Mudules04 Questions Answer

Q01. What is freezing? When freezing is beneficial?

Answer:

Freezing

Freezing is an option in MS Excel to make the row or column title unhidden when scrolling the data. Also we can unhidden more than one rows or columns using this technique. The steps to freeze first row or column are as follows-

Open MS Excel file      within the View tab, in the Window group, click on the Freeze panes      select Freeze Top Row or Freeze First Column from the drop down menu to freeze the first row or column. icon

When freezing is beneficial

There are often row or column headings when we work in Excel worksheets. Scrolling down through the data hides the heading row or column which contains a description of each column or row contents. It is difficult to remember what the data in each column represents if we cannot see the column title row. Freezing is the technique that provides us the facility to view the title row while scrolling through a large datasheet.

Q02. What are mean by relative referencing and absolute referencing?

Answer:

Relative cell referencing

Relative cell referencing in a formula refers to the system of considering cell references that maintain a particular distance from the cell in which the formula is being written. It follows the direction to which we move the mouse when using Autofill option. It is the default cell referencing type in Autofill option.

Absolute cell referencing

Sometimes we need to make calculation between a particular cell and a row or column. In Auto-fill option, normal formula cannot consider the same cell for each of the contents in that row or column. So we need to fix that particular cell address for this calculation inserting two dollar sign ($) before and after the alphabetic part of that cell address. This system of referencing is called absolute cell referencing.

Q03. Write the differences between count, countA and countblank functions.

Answer:

The differences between COUNT, COUNTA and COUNTBLANK are as follows-

COUNT is used to count the number of cells in a range that contain numeric contents.

COUNTA is used to count the number of cells that are not empty and the values within the list of arguments.

COUNTBLANK is used to count empty cells within a cell range.

Q04. Explain how if function works.

Answer:

IF Function

IF function allows us to evaluate values and make decision based on the result of the evaluation. The format (Syntax) of IF function is as follows:

IF(LOGICAL_TEST, ACTION_IF_TRUE, ACTION_IF_FALSE)

The logical_test evaluates an expression to see if it passes the test (true) or does not pass the test (false).

Action_if_true can be a value or an operator which is placed in the cell when the logical_test is true.

Action_if_false can be a value or an operator which is placed in the cell when the logical_test is false.

Q05. What is text wrapping?

Answer:

In MS Excel, when the cell content exceeds the cell boundary then we use text wrapping to shorten the length of the cell boundary. This tool inserts necessary number of line breaks into the content. So the row height increases and column width fits to other cells. To wrap a text we should follow the following steps-

Select the cell    Within the Home tab, in the Alignment group, click on the Wrap text icon     The texts within the cell will be wrapped.

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 popup 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.