DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=sum(A1/A2)
|
|
|
=A1/A2
|
|
|
(A1/A2)
|
|
|
None of the above
|
Detailed explanation-1: -For example, to divide values in row 1 by values in row 2, you put =A1/A2 in cell A3, and then copy the formula rightwards to as many cells as necessary.
Detailed explanation-2: -Divide numbers in a cell To do this task, use the / (forward slash) arithmetic operator. For example, if you type =10/5 in a cell, the cell displays 2. Important: Be sure to type an equal sign (=) in the cell before you type the numbers and the / operator; otherwise, Excel will interpret what you type as a date.
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: -Examples of simple formulas =A1+A2+A3 this Excel formula adds the contents of the three cells specified (see the SUM function for adding multiple numbers).