FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Select True or False. A Formula is an instruction that tells the computer to work out the answer for the values entered. When writing a formula putting the equal sign at the beginning is not necessary.
A
False
B
True
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -Formulas are equations that perform calculations on values in your sheet. All formulas begin with an equal sign (=). You can create a simple formula by using constant and calculation operator. For example, the formula =5+2*3, multiplies two numbers and then adds a number to the result.

Detailed explanation-2: -Formulas in Excel are used to perform calculations or other actions on data entered into the formula and/or stored in program files. They can range from basic mathematical operations, such as addition and subtraction, to complex engineering and statistical calculations.

Detailed explanation-3: -A formula establishes a relationship between two or more cells. It can include cell addresses, numbers, arithmetic operators and parenthesis. Using it, we can perform simple as well as complex calculations. A Formula must begin with an equal to (=) symbol followed by cell reference and operators.

There is 1 question to complete.