DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What mathematical operation does the asterisk (*) perform in Excel?
|
|
Addition
|
|
|
Subtraction
|
|
|
Division
|
|
|
Multiplication
|
Explanation:
Detailed explanation-1: -3. Constants: Numbers or text values entered directly into a formula, such as 2. 4. Operators: The ^ (caret) operator raises a number to a power, and the * (asterisk) operator multiplies numbers.
Detailed explanation-2: -Read on for three powerful ways to perform an Excel multiply formula. To write a formula that multiplies two numbers, use the asterisk (*). To multiply 2 times 8, for example, type “=2*8”. Use the same format to multiply the numbers in two cells: “=A1*A2” multiplies the values in cells A1 and A2.
Detailed explanation-3: -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.
There is 1 question to complete.