Page 283 - Computer - 9(A&B)

Mixed Reference
Mixed reference is a combination of relative and absolute referencing. In mixed referencing, one part of the
cell address—column or row, is made absolute while the other part is relative, such as $A4 or A$4. In mixed
reference, the cell references change in one direction—row or column, while the part made absolute remains
same in the formula copied to all cells.
In the above example, when we copy the formula =B2*C2-$D2 from the cell E2 to cell E3, the column reference
remains same, but the row changes i.e., =B3*C3-$D3.

Session 5

Create and Insert Different Types of Charts in a Spreadsheet

In Calc, you can also represent data in pictorial form. Charts are the pictorial representation of data values
arranged in the form of rows and columns. Calc offers a wide range of charts to interpret data.

Advantages of Charts
Charts are more appealing than the simple presentation of data. There are many advantages of charts.
Some of them are as follows:
v Charts present data and information in a compact and attractive manner.
v Charts are easier to understand and analyse large quantities of data.
v Charts have a more lasting effect on the mind than a simple spreadsheet.

Components of a Chart
The main components of a chart are discussed below.
v Chart Area: This area includes all the objects of the chart.
v Y-Axis/Value Axis: This is the vertical axis of the chart along which the value of each data point is plotted.

145
145