DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is an example of a multiplication formula in Microsoft Excel?
|
|
=L3*C7
|
|
|
=B2 + B3/ C4
|
|
|
=B4xB6
|
|
|
=46 x 39
|
Explanation:
Detailed explanation-1: -For example, the formula =PRODUCT(A2, A4:A15, 12, E3:E5, 150, G4, H4:J6) multiplies two single cells (A2 and G4), two numbers (12 and 150), and three ranges (A4:A15, E3:E5, and H4:J6).
Detailed explanation-2: -The formula in B3 will automatically recalculate and display the new value in cell B3. Excel will not always tell you if your formula contains an error, so it’s up to you to check all of your formulas.
There is 1 question to complete.