USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
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?
|
|
=TIMES(A1:B3)
|
|
|
A1xB3
|
|
|
=A1*B3
|
|
|
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.