USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
-
|
|
|
+
|
|
|
*
|
|
|
/
|
Detailed explanation-1: -Addition Using Excel You can use Excel as a calculator to add numbers by clicking on any cell and typing the = symbol and then the numbers you want to add together separated by a + symbol. In any cell, type “=9+7” (without the quotation marks).
Detailed explanation-2: -Excel absolute cell reference (with $ sign) The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references allows you to copy the formula in Excel without changing references.
Detailed explanation-3: -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 (=).