FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -A function is a prewritten formula that is built into Excel.

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 predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations. You can find all of Excel’s functions on the Formulas tab on the Ribbon: Excel function syntax.

Detailed explanation-4: -The AutoSum button can be used only to create formulas with SUM. Flash fill provides suggestions for cell entries based on previously entered data. The weighted average inventory method results in inventory cost that fall between those arrived at through the use of LIFO and FIFO.

Detailed explanation-5: -Formulas calculate values in a specific order. A formula always begins with an equal sign (=). Excel for the web interprets the characters that follow the equal sign as a formula. Following the equal sign are the elements to be calculated (the operands), such as constants or cell references.