DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Cell Address
|
|
|
Active Cell
|
|
|
Headings
|
|
|
Sheet Tab
|
Detailed explanation-1: -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-2: -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. It is basically a cell’s column number and row number.
Detailed explanation-3: -To do this, you’ll simply need to begin the cell reference with the worksheet name followed by an exclamation point (!). For example, if you wanted to reference cell A1 on Sheet1, its cell reference would be Sheet1!A1.
Detailed explanation-4: -The Correct Answer is “Cell". A worksheet in Excel is made up of Rows and Columns. The intersection of a Row and column in an Excel worksheet is a rectangle called a Cell. Cells store a value, a formula, or text.