DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Cell Formatting
|
|
|
Cell Formula
|
|
|
Cell Identification
|
|
|
Cell Range
|
Detailed explanation-1: -A group of cells is known as a cell range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon. For example, a cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5.
Detailed explanation-2: -A cell range in Ms Excel is a collection of chosen cells. It can be referred to in a formula. This is defined in a spreadsheet with the reference of the upper-left cell as the minimum value of the range and the reference of the lower-right cell as the maximum value of the range.
Detailed explanation-3: -A range reference is represented by the address of the upper left cell and the lower right cell separated with a colon. For example, the range A1:C2 includes 6 cells from A1 through C2.
Detailed explanation-4: -To select an unnamed cell reference or range, type the cell reference of the cell or range of cells that you want to select, and then press ENTER. For example, type B3 to select that cell, or type B1:B3 to select a range of cells.