DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
value
|
|
|
formula
|
|
|
label
|
|
|
function
|
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.