DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
equal sign (=)
|
|
|
plus sign (+)
|
|
|
minus sign (-)
|
|
|
forward slash
|
Detailed explanation-1: -A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula. For example, the following formula multiplies 2 by 3 and then adds 5 to that result to come up with the answer, 11.
Detailed explanation-2: -Mathematical operators All formulas in Excel must begin with an equals sign (=). This is because the cell contains, or is equal to, the formula and the value it calculates.
Detailed explanation-3: -All formulas in spreadsheet programs, like Microsoft Excel, OpenOffice Calc, and Google Sheets start with an equal sign (=). To display an equal sign, but not have it start a formula, you must “escape” the cell by entering a single quote (’) at the beginning.
Detailed explanation-4: -If you type in the formula, you must start with an equal sign, so Excel knows that the data in the cell is a formula.
Detailed explanation-5: -Equal signs start all formulas. Constants, such as numbers or text values, can be entered directly into a formula.