FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
=A1+A2 is an example of what type of entry?
A
value
B
formula
C
label
D
function
Explanation: 

Detailed explanation-1: -=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-2: -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-3: -By default, a cell reference is relative. For example, when you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A), and in the same row (2). A formula that contains a relative cell reference changes as you copy it from one cell to another.

Detailed explanation-4: -For example, A1 is a relative cell reference, and it would become absolute when you make it $A$1.

There is 1 question to complete.