# FUNDAMENTALS OF COMPUTER

## USING MICROSOFT EXCEL

### HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A formula is a calculation involving values, cell references, and/or built-in functions. All formulas begin with ____
 A # B = C + D /
Explanation:

Detailed explanation-1: -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.

Detailed explanation-2: -A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.

Detailed explanation-3: -Note: Formulas in Excel always begin with the equal sign. Select a cell or type its address in the selected cell. Enter an operator. For example, – for subtraction.

Detailed explanation-4: -So in summary, a formula is any calculation in Excel, but a function is a pre-defined calculation. =MAX(A1:B20) is a formula containing a function. Mastering the use of functions in formulas is a key skill in learning financial modelling.

There is 1 question to complete.