USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Scope
|
|
Nested Parentheses
|
|
Order of operations
|
|
Operand
|
Detailed explanation-1: -Excel uses standard operators for formulas, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a caret (^) for exponents. All formulas in Excel must begin with an equals sign (=).
Detailed explanation-2: -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.
Detailed explanation-3: -Answer: The cell references containing values to be used for calculations passed to the function are called argument. Argument can also be defined as the value of a cell. It can also said to be a part of a function.
Detailed explanation-4: -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.