USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
equal
|
|
|
more than
|
|
|
less than
|
|
|
unidentified
|
Detailed explanation-1: -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. These are separated by calculation operators.
Detailed explanation-2: -Create a formula that refers to values in other cells Type the equal sign =. Note: Formulas in Excel always begin with the equal sign. Select a cell or type its address in the selected cell. Enter an operator.
Detailed explanation-3: -The parts of a function In order to work correctly, a function must be written a specific way, which is called the syntax. The basic syntax for a function is an equals sign (=), the function name (SUM, for example), and one or more arguments.
Detailed explanation-4: -The Equal to logical operator (=) can be used to compare all data types-numbers, dates, text values, Booleans, as well as the results returned by other Excel formulas. For example: =A1=B1. Returns TRUE if the values in cells A1 and B1 are the same, FALSE otherwise. =A1="oranges"