DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=SUM(A1:A10)
|
|
|
=A1*A2
|
|
|
=MEDIAN( )
|
|
|
None of the above
|
Detailed explanation-1: -The PRODUCT function multiplies all the numbers given as arguments and returns the product. For example, if cells A1 and A2 contain numbers, you can use the formula =PRODUCT(A1, A2) to multiply those two numbers together.
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: -Excel 2016 =A1+A2 adds the values in cells A1 and A2. =A1-A2 subtracts the value in A2 from A1. =A1*A2 multiplies the values in A1 and A2. =A1/A2 divides the value in A1 by A2.
Detailed explanation-4: -For example, clicking in a cell and typing =A1+A2 means that the value of the cell you selected will equal the value of cell A1 plus the value of cell A2. Similarly, clicking in a cell and typing =B3-C3 means that the value of the cell selected will equal the value of cell B3 minus the value of cell C3.
Detailed explanation-5: -Use function commands Suppose you want to multiply all the values together in a column, then multiply this result by a constant in another column. So assuming you multiply cells A1 through A10 and then by a constant in cell B1, you can write this as =PRODUCT(A1:A10, B1) in a blank cell.