FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

BASICS OF BIG DATA

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
How would we multiply the value of cell A1 by the value of cell B3?
A
=TIMES(A1:B3)
B
A1xB3
C
=A1*B3
D
A1*B3
Explanation: 

Detailed explanation-1: -In each blank cell, enter the formula as =A1*B1, =A2*B1 and so on for each cell in column A. Repeat this formula in each of the cells in column C to multiply each cell in column A by the constant in cell B1.

Detailed explanation-2: -Multiply numbers in a cell To do this task, use the * (asterisk) arithmetic operator. For example, if you type =5*10 in a cell, the cell displays the result, 50.

Detailed explanation-3: -The PRODUCT function is useful when you need to multiply many cells together. For example, the formula =PRODUCT(A1:A3, C1:C3) is equivalent to =A1 * A2 * A3 * C1 * C2 * C3.

There is 1 question to complete.