DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Column C
|
|
|
=SUM
|
|
|
Row 1
|
|
|
A5
|
Detailed explanation-1: -Explanation: False-A1 is the example of the cell reference. True-The name of the box shows the data that you enter in an active cell called the formula bar.
Detailed explanation-2: -2. The Name box shows the data that you enter in an active cell.
Detailed explanation-3: -Relative Cell References The reference will change when you copy the formula, so that it always refers to the correct cells. For example, if you have a formula in cell A1 that sums the values in cells A2:A5, the references in the formula will change when you copy the formula to cell B1.
Detailed explanation-4: -A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet. For example, A1 refers to the cell at the intersection of column A and row 1; B2 refers to the second cell in column B, and so on.
Detailed explanation-5: -Cell reference contains one or more letters or the alphabet followed by a number where the letter or alphabet indicates the column and the number represents the row. Each cell can be located or identified by its cell reference or address, e.g., B5.