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.

A function is a predefined calculation entered in a cell to help to analyze or manipulate data in a spreadsheet. These functions simplify help to create the formulas needed to get the expected results

(i) Relative here means that the reference to this cell address will be changed automatically when you copy the formulae.
(ii) Absolute references are the opposite of relative addressing. A dollar sign is placed before each column name and row number in an absolute reference.