DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
$
|
|
|
?
|
|
|
%
|
|
|
!
|
Detailed explanation-1: -To make the cell E4 an Absolute Reference, add the dollar symbol ($) before the column name and row number like $E$4. So now, the formula will be = B2*$E$4.
Detailed explanation-2: -There is a shortcut for placing absolute cell references in your formulas! When you are typing your formula, after you type a cell reference-press the F4 key. Excel automatically makes the cell reference absolute! By continuing to press F4, Excel will cycle through all of the absolute reference possibilities.
Detailed explanation-3: -Excel absolute cell reference (with $ sign) The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references allows you to copy the formula in Excel without changing references.
Detailed explanation-4: -$D$21:$D$44 is the column of numbers to add, the amount column. $B$21:$B$44 is the first criteria range, the region column. B10 is the first criteria value, the region. $C$21:$C$44 is the second criteria range, the department column.
Detailed explanation-5: -In this style, columns are defined by letters and rows by numbers, i.e. A1 designates a cell in column A, row 1.