USING MICROSOFT EXCEL
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: -You can use the PRODUCT function to multiply numbers, cells, and ranges. You can use any combination of up to 255 numbers or cell references in the PRODUCT function.
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.