DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
#
|
|
|
=
|
|
|
+
|
|
|
/
|
Detailed explanation-1: -A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula. For example, the following formula multiplies 2 by 3 and then adds 5 to that result to come up with the answer, 11.
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.