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: -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: -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-3: -Press Tab. To start the formula, type an equal sign, and start typing the name of a function. A popup list will appear, showing any functions that match what you’ve typed. When the function that you want is highlighted, press the Tab key, to enter it in the cell, along with its opening bracket.
Detailed explanation-4: -All Excel formulas begin with an equal sign (=). After the equal symbol, you enter either a calculation or function. For example, to add up values in cells B1 through B5, you can either: Type the entire equation: =B1+B2+B3+B4+B5.