Question

mention any 2 rules for using functions in excel 2013​

Answer 1

Answer:

Each function has a specific order—called syntax—which must be followed in order for the function to work correctly. The basic syntax to create a formula with a function is to insert an equals sign (=), function name (SUM, for example, is the function name for addition), and argument.

Answer 2

Figuring out formulas for calculations you want to make in Excel can be tedious and complicated. Fortunately, Excel has an entire library of functions—or predefined formulas—you can take advantage of. You may be familiar with common functions like sum, average, product, and count, but there are hundreds of functions in Excel, even for things like formatting text, referencing cells, calculating financial rates, and analyzing statistics.

In this lesson, you'll learn the basics of inserting common functions into your worksheet by utilizing the AutoSum and Insert Functions commands. You will also become familiar with how to search and find various functions, including exploring Excel's Functions Library.

Basic functions :

A function is a predefined formula that performs calculations using specific values in a particular order. One of the key benefits of functions is that they can save you time because you do not have to write the formula yourself. Excel has hundreds of functions to assist with your calculations.

To use these functions correctly, you need to understand the different parts of a function and how to create arguments in functions to calculate values and cell references.

The parts of a function :

The order in which you insert a function is important. Each function has a specific order—called syntax—which must be followed in order for the function to work correctly. The basic syntax to create a formula with a function is to insert an equals sign (=), function name (SUM, for example, is the function name for addition), and argument. Arguments contain the information you want the formula to calculate, such as a range of cell references.

Syntax of a basic function :

Working with arguments

Arguments must be enclosed in parentheses. Individual values or cell references inside the parentheses are separated by either colons or commas.

Colons create a reference to a range of cells.

For example, =AVERAGE(E19:E23) would calculate the average of the cell range E19 through E23.

Commas separate individual values, cell references, and cell ranges in parentheses. If there is more than one argument, you must separate each argument by a comma.

For example, =COUNT(C6:C14,C19:C23,C28) will count all the cells in the three arguments that are included in parentheses.