USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
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: -Use the multiplication sign (×), not the letter x, to indicate the mathematical operation. Use an asterisk (*) if you need to match the UI. Use × to mean by when you refer to screen resolution or dimensions.
There is 1 question to complete.