Chart is a powerful way to convey information to the reader through a pictorial representation. This facility enhances the presentation of data in an effective manner.

(i) Relative cell addressing
(ii) Absolute cell addressing

Frozen columns and rows remain the view during scrooling, whereas other rows and columns gets scrolled

Range is the range to which the criteria are to be applied.
Example: Criteria indicates the criteria in the form of a number, an expression or a text string. These criteria determine which cells are counted.
A1:A10 is a cell range containing the numbers 2000 to 2009. Cell B1 contains the number 2006. In cell B2, you enter a formula:
= COUNTIF (A1:A10;2006) - this returns 1

ASIN (Number/Cell Address): This function returns the inverse trigonometric sine of Number that is the angle (in radians) whose sine is Number. The angle returned is in the range – PI/2 to +PI/2. To return the angle in degrees, use the DEGREES function.
Example : = ASIN (0) returns 0. = ASIN (1) returns 1.5707963267949 (PI/2 radians).
= DEGREES (ASIN (0.5)) returns 30. The sine of 30 degrees is 0.5.

(i) To hide or show rows and columns, use the option in the Format menu or the right-click and choose from pop-up menu.
(ii) To hide a row/column, first select the row/column, and then use menu options,
(iii) Format → Row → Hide or Format → Column → Hide to hide row and column respectively,
(iv) The same can be achieved by choosing "Hide" option from the pop-up menu when you right-click the selected row/column.
(v) To show the hidden row/column, choose Format → Row → Show or Format → Column → Show (or)
(vi) Right-click and choose Show from pop-up menu.

The most commonly used feature input method is built-in functions, the Function Wizard. To open the Function Wizard can be opened through. The menu choose Insert→ Function or using the shortcut key press Ctrl+F2.
(i) Once open, Select a category of functions to shorten the list, then scroll down through the named functions and select the required one.
(ii) When you select a function its description appears on the right-hand side of the dialog. Double-click on the required function.
(iii) The Wizard now displays a textbox where you can enter data manually in text boxes and the result will be displayed in the Result text box
ABS (Number/Cell Address): Number/ Cell Address is the value whose absolute value is to be calculated. The absolute value of a number is its value without +/- sign.
Example : =ABS (-76) returns 76, =ABS (74) returns 7, =ABS (0) returns 0.

Creating and formatting charts :
(i) Select the cells that contain the data that you want to present in your chart.
(ii) Click the Insert → Chart option or click Insert Chart icon on the Standard toolbar.

(iii) The Chart Wizard has three main part:
1. List of steps involved in setting up the chart, List of chart types, and The options for each chart type.
2. At any time you can go back to a previous step and change selections.

(iv) Choose a Chart type and its option type. Then click Next button.

(v) In step 2, Data Range, manually correct any mistakes made in selecting the data. Click one of the options for data series in rows or in columns. Check whether the data range has labels in the first row or in the first column or both. Then click the finish button, or click Next to change some more details of the chart.

(vi) In the Data Series list box contains a list of all data series in the current chart.
1. To organize the data series, select an entry in the list
2. Click Add to add another data series below the selected entry. The new data series has the same type as the selected entry.
3. Click Remove to remove the selected entry from the Data Series list.
4. Use the Up and Down arrow buttons to move the selected entry in the list up or down. This does not change the order in the data source table, but changes only the arrangement in the chart.
5. Then click Next button.

(vii) On the Chart Elements page, chart a title and, if desired, a subtitle. Use a title that draws the viewer's attention to the purpose of the chart: Then click Finish to create chart.