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: -Why the symbol? The symbol is already used in table references to indicate implicit intersection. Consider the following formula in a table =[Column1]. Here the indicates that the formula should use implicit intersection to retrieve the value on the same row from [Column1].
Detailed explanation-3: -An Excel formula that starts with =+ is nothing. It’s an old habit that Lotus Notes users have for starting a formula. Erika, there’s nothing to worry about. Whether a formula starts with = or =+ the answer is going to be the same. Just keep on movin’ and keep your data clean!
Detailed explanation-4: -A formula in Excel always begins with an equal sign (=).