USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
T
|
|
|
F
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -All formulas in spreadsheet programs, like Microsoft Excel, OpenOffice Calc, and Google Sheets start with an equal sign (=). To display an equal sign, but not have it start a formula, you must “escape” the cell by entering a single quote (’) at the beginning.
Detailed explanation-2: -Equal signs start all formulas. Constants, such as numbers or text values, can be entered directly into a formula. Operators specify the kind of calculation that the formula performs. For example, the ^ (caret) operator raises a number to a power, and the * (asterisk) operator multiplies numbers.
Detailed explanation-3: -Equal Sign (=) The most commonly used symbol in Excel is the equal (=) sign. Every single formula or function used has to start with equals to let Excel know that a formula is being used. If you wish to reference a cell in a formula, it has to have an equal sign before the cell address.
Detailed explanation-4: -The parts of a function In order to work correctly, a function must be written a specific way, which is called the syntax. The basic syntax for a function is an equals sign (=), the function name (SUM, for example), and one or more arguments.