DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=
|
|
|
()
|
|
|
;
|
|
|
FORMULA
|
Detailed explanation-1: -Type the equal sign =. Note: Formulas in Excel always begin with the equal sign.
Detailed explanation-2: -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.
Detailed explanation-3: -The SUM function is the first must-know formula in Excel. It usually aggregates values from a selection of columns or rows from your selected range. Example: =SUM(B2:G2) – A simple selection that sums the values of a row.
Detailed explanation-4: -A formula begins with an equal sign. Meanwhile, functions are used to perform complex calculations that cannot be done manually. Functions in excel have names that reflect their intended use. The example below shows how we have used the multiplication formula manually with the ‘*’ operator.
Detailed explanation-5: -A formula in Excel is used to do mathematical calculations. Formulas always start with the equal sign ( = ) typed in the cell, followed by your calculation. Formulas can be used for calculations such as: =1+1. =2*2.