COMPUTER FUNDAMENTALS

Detailed explanation-1: -Excel has prewritten formulas called functions to help simplify making complicated calculations. A function takes a value or values, performs an operation, and returns a result to a cell. The values that you use with a function are called arguments.

Detailed explanation-2: -A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and minimum value for a range of cells.

Detailed explanation-3: -Functions are pre-written formulas that carry out calculations by utilizing particular values, referred to as inputs, in a given order, or structure. Calculations of any complexity can be carried out using functions.

Detailed explanation-4: -A function is a prewritten formula. A function takes a value (or values), performs an operation, and returns a new value (or values.) Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.