DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The point-and-click method allows the user to:
|
|
type in a cell reference
|
|
|
automatically select a formula
|
|
|
click on each cell rather than type the cell reference into a formula
|
|
|
none of these
|
Explanation:
Detailed explanation-1: -Point-and-click method: Constructs a cell formula in Excel by clicking on the cell you want to reference rather than keying the reference.
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: -A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.
There is 1 question to complete.