# FUNDAMENTALS OF COMPUTER

## DATABASE FUNDAMENTALS

### HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which excel formula is a division formula?
 A =sum(A1/A2) B =A1/A2 C (A1/A2) D None of the above
Explanation:

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).

There is 1 question to complete.