高頓網(wǎng)校友情提示，*7克孜勒蘇柯?tīng)柨俗螘?huì)計(jì)繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-Tables Part 3_在列表中使用公式等內(nèi)容公布如下：
　　Tables Part 3: Using Formulas with Tables
　　列表（第三部分）：在列表中使用公式
　　One of our goals with tables was to create a set of features that reduce the overall maintenance required to keep a spreadsheet functioning well over time. This involves making spreadsheets less prone to error, as well as making them more understandable days, months, and years after the spreadsheet was created. Rethinking the interaction between tables and formulas proved to be an important part of meeting that goal.
　　在以前的電子數(shù)據(jù)表格中，為了使其正常工作，用戶需要大量的維護(hù)工作，我們引入列表的一個(gè)目的就是減少這部分維護(hù)工作，它可以使電子數(shù)據(jù)表格更不容易出錯(cuò)，也可以使生成的電子數(shù)據(jù)表格更好的理解年月日。列表和公式的協(xié)同工作被證明是實(shí)現(xiàn)這個(gè)目標(biāo)的重要部分。
　　As many readers have presaged, Excel 12 provides some new ways to reference tables and parts of tables. We refer to our work in this area as “structured referencing” (that is a working title, so it may be called something else when we ship the product). In a nutshell, the structured referencing feature allows you to reference a table and/or subsets of the table directly by name as opposed to by cell coordinates. The feature is similar in concept to named ranges with a few crucial differences. First, the names that can be referenced are automatically generated when the table is created. Specifically, this includes the name of the table itself (which by default is something like “Table1”), and the names of all the columns. Also, the names are automatically removed as columns are deleted or the entire table is deleted. Finally, and perhaps most importantly, the names automatically adjust as the table grows and shrinks. As a result, the majority of the headaches of maintaining named ranges go away with structured referencing.
　　正如很多讀者預(yù)測(cè)的一樣，Excel 12提供了一些新的方法用于引用整個(gè)列表和部分列表，我們談到的這部分工作成為“結(jié)構(gòu)化引用”（這是開(kāi)發(fā)過(guò)程中的名稱，在最終發(fā)布的產(chǎn)品中可能使用其他的名稱）。簡(jiǎn)單的說(shuō)，相比過(guò)去我們只能通過(guò)單元格坐標(biāo)進(jìn)行引用，結(jié)構(gòu)化引用功能使得用戶可以通過(guò)名稱引用整個(gè)列表或者部分列表，這個(gè)功能和區(qū)域名稱的概念類似，只有很少的一點(diǎn)區(qū)別。首先，在生成列表時(shí)會(huì)自動(dòng)產(chǎn)生一個(gè)可以引用的名稱，這包括列表本身的名稱（系統(tǒng)缺省為類似于“Table1”的名稱）和全部列的名稱，其次，這些名稱會(huì)隨著列或者列表的刪除而消失，最后，可能是最重要的一點(diǎn)，名稱會(huì)隨著列表的擴(kuò)展和收縮而自動(dòng)調(diào)整。使用結(jié)構(gòu)化引用將能夠解決令人頭痛最主要的問(wèn)題——名稱的維護(hù)。
　　So how is all this manifested in the product? Structured referencing represents an addition to the syntax for formulas in Excel. Here are the basics of how it works.
　　系統(tǒng)如何識(shí)別這些引用呢？結(jié)構(gòu)化引用可以應(yīng)用于Excel的公式中，下面我們來(lái)簡(jiǎn)單介紹一下它是如何工作的。
　　· A reference to a table looks like this: =Table1, so if you wanted to sum the values in a table, you could use =SUM(Table1). Note that =Table1 returns all of the data in Table1 without the headers – this is because many of the common functions that work on ranges, like VLOOKUP, assume no headers.
　　列表的引用類似于=Table1，用戶使用=SUM(Table1)就可以對(duì)整個(gè)工作表數(shù)據(jù)進(jìn)行求和，注意=Table1將返回除了標(biāo)題之外列表中的所有數(shù)據(jù)——這是因?yàn)橐话愕氖褂脜^(qū)域作為參數(shù)的函數(shù)如VLOOLUP，都會(huì)假設(shè)該區(qū)域不包含標(biāo)題。
　　· A reference to a column looks like this: =Table1[Column1]. Again, this reference returns just the data. So, for example, if you wanted to SUM a column, you could type =SUM(Sales[2004]).
　　列的引用類似于=Table1[Column1]，同樣的這個(gè)引用也只是返回?cái)?shù)據(jù)，例如用戶需要對(duì)某列求和，那么可以輸入公式=SUM(Sales[2004])。
　　點(diǎn)擊看大圖
　　There’s more to the syntax than that, but first I want to talk about something I personally love – integration between structured referencing and Formula AutoComplete. The Formula AutoComplete feature I talked about a week ago is fully integrated with structured references – meaning Formula AutoComplete for tables names as well as columns within tables is possible. For example, here is what it would look like to build the structured reference pictured above. First, let’s start with just a table.
　　除了上面的例子，還有很多語(yǔ)法格式，在繼續(xù)講解之前我想解釋一個(gè)我個(gè)人很喜歡的東西——結(jié)構(gòu)化引用和公式記憶式鍵入功能的結(jié)合，公式記憶式鍵入功能完美的和結(jié)構(gòu)化引用結(jié)合在一起，也就是說(shuō)列表名稱和其中列的名稱可以在公式記憶式鍵入功能中使用。例如，我們來(lái)看一下如何應(yīng)用上圖中生產(chǎn)的結(jié)構(gòu)化引用，首先，我們的工作表中只有一個(gè)列表。
 　　　　
　　掃一掃微信，學(xué)習(xí)實(shí)務(wù)技巧
　　　
　　高頓網(wǎng)校特別提醒：已經(jīng)報(bào)名2014年財(cái)會(huì)考試的考生可按照復(fù)習(xí)計(jì)劃有效進(jìn)行！另外，高頓網(wǎng)校2014年財(cái)會(huì)考試高清課程已經(jīng)開(kāi)通，通過(guò)針對(duì)性地講解、訓(xùn)練、答疑、?？迹瑢?duì)學(xué)習(xí)過(guò)程進(jìn)行全程跟蹤、分析、指導(dǎo)，可以幫助考生全面提升備考效果。