高頓網(wǎng)校友情提示，*7潮州會(huì)計(jì)繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-關(guān)于圖標(biāo)集的更多信息等內(nèi)容公布如下：　　A bit more on Icon Sets – answers to Biff’s and Harlan’s questions
　　關(guān)于圖標(biāo)集的更多信息——回答B(yǎng)iff和Harlan的問題
　　Since a few of the comments that were made on the last post  were more easily answered with pictures, I thought I would just go ahead and make a new post out of it.  (I have answered the other comments in the comments section of the previous post.)
　　因?yàn)樯洗伟l(fā)表的帖子的一些建議用圖片來回答更容易一些，所以，我想我得另外發(fā)一篇新帖子來回答這些問題（我已經(jīng)在上篇帖子的留言部分回答了其它建議）。
　　1. Biff commented “That 2nd screencap with all those icons applied looks like a real mess. I would not want to see that in any of my spreadsheets.”
　　1. Biff留言說“第二幅截屏中，應(yīng)用的那些圖標(biāo)看上去實(shí)在有些亂。我不想在我的任何電子表格里面看到這個(gè)樣子。”
　　Actually, Biff, my example wasn’t the greatest – that is not how I suspect that most people will use Icon Sets in the wild, it was something I created rapidly for illustrative purposes.  You may have noticed that there was an option on the Icon Set Formatting Rule dialog to “Show The Icon Only”.  I suspect we will see a lot of that – in the internal reports and documents we have seen from dogfood use around MSFT and our beta participants, I would say that 75% of what we see is just the icon.  Here are a few examples.
　　Biff，實(shí)際上，我的示例不是*4的——我想大多數(shù)人不會(huì)是那樣使用圖標(biāo)集的，它是我為了示范目的而快速創(chuàng)建的東東。你也許注意到圖標(biāo)集格式規(guī)則對(duì)話框里有個(gè)選項(xiàng)，可以選擇“僅顯示圖標(biāo)”。我想我們將看到很多這樣的例子——我們已經(jīng)看到在MSFT和我們beta版的試用中的內(nèi)部報(bào)告和文檔中，我要說，我們看到的75％是只有圖標(biāo)。這里有一些示例。
　　2) Harlan commented “I think the bigger problem is that the icons appear left-aligned in the cells. I'd be surprised if most users wouldn't associate the icons closest to the numbers with the numbers. A quick glance makes it appear that the value 35 for Measurement 6 in column One has an associated exclamation point rather than a checkmark.
　　2) Harlan留言說“我想較大的問題是圖標(biāo)左對(duì)齊顯示在單元格里。如果大多數(shù)的用戶不會(huì)將圖標(biāo)和挨得最近的數(shù)字聯(lián)系起來的話，那我才會(huì)真的感到意外呢。一眼看上去，好像在列’One’和行’Measurement 6’中的數(shù)值35與感嘆號(hào)聯(lián)系在一起，而不是對(duì)勾號(hào)。
　　I don't see how icons would be useful without aligning themselves with their corresponding values more closely than with the contents of adjacent cells. Given that it's also useful to have the icons align with each other in each column, the ideal would seem to be for icons to align to the left or right of left or right aligned cells and automatically indent the cell contents to make space. Treat centered and the other horizontal alignments the same as general: align icons on the right for numbers and on the left for the other types (and for general, change cells' horizontal alignment to right or left as appropriate for the cells' type and indent).
　　如果不將圖標(biāo)與它們相應(yīng)的數(shù)值挨得比臨近的單元格內(nèi)容更近一些的話，那么我看圖標(biāo)不會(huì)有什么用處。假設(shè)圖標(biāo)在每列中彼此對(duì)齊也有用處的話，理想狀況是圖標(biāo)應(yīng)該可以自動(dòng)在左對(duì)齊或者右對(duì)齊的單元格中進(jìn)行左對(duì)齊或者右對(duì)齊，并且，單元格內(nèi)容自動(dòng)縮進(jìn)以確保空間。將居中和其它橫向?qū)R處理為常規(guī)：數(shù)字類型的將圖標(biāo)對(duì)齊在右邊，其它類型的對(duì)齊在左邊（對(duì)于常規(guī)，基于單元格類型和縮進(jìn)更改單元格’橫向?qū)R為右或者左’）。
　　This raises the question how these icons would align vertically if they were in cells that wrapped to multiple lines OR were in rows with greater than needed row height. They should either match cells' vertical alignment or always be centered.”
　　這提出了另外一個(gè)問題，如果多行單元格合并了或者行高大于所需行高的話，圖標(biāo)將如何豎直對(duì)齊呢？它們應(yīng)該要么和單元格的豎直匹配要么總是居中對(duì)齊。”
　　Good feedback – the folks on the feature will think about it.  Again, I suspect that either the numbers wont be shown, or they will be a column of numbers that are easily identified with the icon (as in the above examples).  In the final implementation, the icon will line up with the text in a cell, and the icon will follow the cell’s vertical alignment.  Since Icon Sets can only be applied to numerical values, so text wrapping will not be an issue.
　　很好的反饋——本功能組的成員將考慮它。再次強(qiáng)調(diào)，我想要么不顯示數(shù)字，要么它們會(huì)是一列容易與圖標(biāo)鑒別的數(shù)字（參見上面的示例）。在最后的實(shí)施中，圖標(biāo)會(huì)和單元格中的文本整齊排列，圖標(biāo)會(huì)遵循單元格的豎直對(duì)齊。因?yàn)閳D標(biāo)集只能應(yīng)用到數(shù)值，因此文本換行不會(huì)是個(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)開通，通過針對(duì)性地講解、訓(xùn)練、答疑、?？迹瑢?duì)學(xué)習(xí)過程進(jìn)行全程跟蹤、分析、指導(dǎo)，可以幫助考生全面提升備考效果。