DATABASE FUNDAMENTALS
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: -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.
Detailed explanation-4: -The formula for this function is =CONCATENATE(Cell reference 1, Cell reference 2). So, for example, you can input “=CONCATENATE (A1, B1)” into cell C1 to combine the values of A1 and B1 into that cell.