DATABASE FUNDAMENTALS
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.
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: -You can do it through AutoSum or Some Formulas.