USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
FieldName[TableName]
|
|
|
TableName[FieldName]
|
|
|
[FieldName]TableName
|
|
|
[TableName]FieldName
|
Detailed explanation-1: -That combination of table and column names is called a structured reference. The names in structured references adjust whenever you add or remove data from the table. Structured references also appear when you create a formula outside of an Excel table that references table data.
Detailed explanation-2: -Start typing a formula as usual, beginning with the equality sign (=). When it comes to the first reference, select the corresponding cell or range of cells in your table. Excel will pick up the column name(s) and create an appropriate structured reference for you automatically.
Detailed explanation-3: -A field is an element in which one piece of information is stored, such as the received field. Usually a column in a table contains the values of a single field. However, you can show several fields in a column by using a Formula or a Combination field.