DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
A cell that is selected.
|
|
|
A feature that enables you to repeat the same data in a column or row.
|
|
|
The intersection of a single row and a single column.
|
|
|
An Excel term for a spreadsheet.
|
Detailed explanation-1: -The INTERSECTION of a row and column is called a CELL. Also called a spreadsheet. The intersection of a column and row on a worksheet. You enter data into cells to create a worksheet.
Detailed explanation-2: -The INTERSECTION of a row and column is called a CELL.
Detailed explanation-3: -Cell: A cell is a rectangular area formed by the intersection of a column and a row. Cells are identified by the Cell Name (or Reference, which is found by combining the Column Letter with the Row Number. For example the cell in Column “C” in Row “3” would be cell C3.
Detailed explanation-4: -Intersection of a Single Row and Column Now if you use =C2:C13 B5:D5 [Note there is a single space in between the ranges, which is also our intersect operator in Excel], it will return 523 (the value in cell C5), which is the intersection of these 2 ranges.
Detailed explanation-5: -how do you select a single cell, a single column, a single row, a cluster of cells and a entire worksheet. AI Recommended Answer: To select a single cell, column, or row, you can use the mouse or the keyboard. To select a cluster of cells, you can use the keyboard shortcut, Ctrl+click.