高頓網(wǎng)校友情提示，*7克孜勒蘇柯爾克孜會計繼續(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ù)表格中，為了使其正常工作，用戶需要大量的維護工作，我們引入列表的一個目的就是減少這部分維護工作，它可以使電子數(shù)據(jù)表格更不容易出錯，也可以使生成的電子數(shù)據(jù)表格更好的理解年月日。列表和公式的協(xié)同工作被證明是實現(xiàn)這個目標(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ù)測的一樣，Excel 12提供了一些新的方法用于引用整個列表和部分列表，我們談到的這部分工作成為“結(jié)構(gòu)化引用”（這是開發(fā)過程中的名稱，在最終發(fā)布的產(chǎn)品中可能使用其他的名稱）。簡單的說，相比過去我們只能通過單元格坐標(biāo)進行引用，結(jié)構(gòu)化引用功能使得用戶可以通過名稱引用整個列表或者部分列表，這個功能和區(qū)域名稱的概念類似，只有很少的一點區(qū)別。首先，在生成列表時會自動產(chǎn)生一個可以引用的名稱，這包括列表本身的名稱（系統(tǒng)缺省為類似于“Table1”的名稱）和全部列的名稱，其次，這些名稱會隨著列或者列表的刪除而消失，最后，可能是最重要的一點，名稱會隨著列表的擴展和收縮而自動調(diào)整。使用結(jié)構(gòu)化引用將能夠解決令人頭痛最主要的問題——名稱的維護。
　　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)如何識別這些引用呢？結(jié)構(gòu)化引用可以應(yīng)用于Excel的公式中，下面我們來簡單介紹一下它是如何工作的。
　　· 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)就可以對整個工作表數(shù)據(jù)進行求和，注意=Table1將返回除了標(biāo)題之外列表中的所有數(shù)據(jù)——這是因為一般的使用區(qū)域作為參數(shù)的函數(shù)如VLOOLUP，都會假設(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]，同樣的這個引用也只是返回數(shù)據(jù)，例如用戶需要對某列求和，那么可以輸入公式=SUM(Sales[2004])。
　　點擊看大圖
　　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.
　　除了上面的例子，還有很多語法格式，在繼續(xù)講解之前我想解釋一個我個人很喜歡的東西——結(jié)構(gòu)化引用和公式記憶式鍵入功能的結(jié)合，公式記憶式鍵入功能完美的和結(jié)構(gòu)化引用結(jié)合在一起，也就是說列表名稱和其中列的名稱可以在公式記憶式鍵入功能中使用。例如，我們來看一下如何應(yīng)用上圖中生產(chǎn)的結(jié)構(gòu)化引用，首先，我們的工作表中只有一個列表。
 　　　　
　　掃一掃微信，學(xué)習(xí)實務(wù)技巧
　　　
　　高頓網(wǎng)校特別提醒：已經(jīng)報名2014年財會考試的考生可按照復(fù)習(xí)計劃有效進行！另外，高頓網(wǎng)校2014年財會考試高清課程已經(jīng)開通，通過針對性地講解、訓(xùn)練、答疑、模考，對學(xué)習(xí)過程進行全程跟蹤、分析、指導(dǎo)，可以幫助考生全面提升備考效果。