USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Reference operator
|
|
|
Comparison operator
|
|
|
Mathematical operators
|
|
|
Addition operator
|
Detailed explanation-1: -Reference operators Combine ranges of cells for calculations with these operators. Reference operator. Meaning. Example. : (colon)
Detailed explanation-2: -These are called “relative” cell references, since they change relative to where you copy the formula. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a “$” before the column letter if you want that to always stay the same.
Detailed explanation-3: -Type =CONCAT(. Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text. Close the formula with a parenthesis and press Enter.
Detailed explanation-4: -Summary. Mixed reference in Excel means only part of the reference is fixed, either the row or the column, and the other part is relative. Unlike absolute references, only one $ (dollar sign) is applied, either in front of the column or row number.