DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is a simple formula?
|
|
=B2*C2
|
|
|
=(B2*C2)-D2
|
|
|
=SUM(B2:B7)
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Simple formulas always start with an equal sign (=), followed by constants that are numeric values and calculation operators such as plus (+), minus (-), asterisk(*), or forward slash (/) signs. Let’s take an example of a simple formula.
Detailed explanation-2: -For example, when you enter the formula =5+2*3, the last two numbers are multiplied and added to the first number to get the result. Following the standard order of mathematical operations, multiplication is performed before addition.
There is 1 question to complete.