Question

Q.5. Define the following function:
1. AVERAGE
2. RATE
3. NOW​

Answer 1

Answer:

1 ) The AVERAGE function in Excel calculates the average (arithmetic mean) of a group of numbers. The AVERAGE function ignores logical values, empty cells and cells that contain text.

Average

Instead of using the AVERAGE function, use SUM and COUNT.

2) In mathematics — specifically, in large deviations theory — a rate function is a function used to quantify the probabilities of rare events. It is required to have several properties which assist in the formulation of the large deviation principle.[clarification needed] In some sense, the large deviation principle is an analogue of weak convergence of probability measures, but one which takes account of how well the rare events behave.

A rate function is also called a Cramér function, after the Swedish probabilist Harald Cramér.

3) The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.