UNIT 2 .INTRODUCTION TO EXCEL -BASIC

 

💁Using Reference Operators

To use functions, you need to understand reference operators. 

Reference operators refer to a cell or a group of cells. There are two types of reference operators: range and union.

A range reference refers to all the cells between and including the reference.

 A range reference consists of two cell addresses separated by a colon.

 The reference A1:A3 includes cells A1, A2, and A3.

 The reference A1:C3 includes cells A1, A2, A3, B1, B2, B3, C1, C2, and C3.

A union reference includes two or more references.

A union reference consists of two or more numbers, range references, or cell addresses separated by a comma.

 The reference A7, B8:B10, C9,10 refers to cells A7, B8 to B10, C9 and the number 10.

💁Understanding Functions

Functions are prewritten formulas. Functions differ from regular formulas in that you supply the value but not the operators, such as +, -, *, or /.

For example, you can use the SUM function to add. When using a function, remember the following:

💂

1.     Use an equal sign to begin a formula

 2. Specify the function name.

3. Enclose arguments within parentheses.

😎 Arguments are values on which you want to perform the calculation.

For example, arguments specify the numbers or cells you want to add. 4.

 Use a comma to separate arguments.

example of a function: =SUM(2,13,A1,B2:C7)

 In this function, known as the SUM function:

1. The equal sign begins the function.

 2. SUM is the name of the function.

 3. 2, 13, A1, and B2:C7 are the arguments. Parentheses enclose the arguments.

4. Commas separate the arguments.

After you type the first letter of a function name, the AutoComplete list appears.

You can double-click on an item in the AutoComplete list to complete your entry quickly or use tab button . Excel will complete the function name and enter the first parenthesis.