|Book Edition||1st Edition|
Label each of the elements of the Excel worksheet window shown in FIGURE 8-25.
1. Filter icon (replaces Column header arrow after filtering options): To filter data range, select any range and in the Data tab choose filter option.
Once the filter option appears select the column header row.
De select Select All option and choose the other options to be filtered in display. (here state options are filtered where only options NJ and PA are selected)
The column header arrow is replaced to a Filter icon . To change or clear the filter, select this icon.
2. Row heading : The chart's row heading feature with breaks in the sequence of the numbers, such as 7, 8, 12 as data filter is applied.
3. Row for Total Sales (with Total Sales less return, returns, and bonus): This row is displaying the total sales for the month of January, February, and March, with returns, Total Sales less return, and bonus.
4. Quick Analysis Gallery : When the data is chosen from the data cells that you want to examine. At the bottom of the data, the Quick Analysis Tool icon appears. When the button is pressed. A Quick Analysis gallery is opened up where each obtain can be previewed when one hovers the cursor over it.
5.Color Scale : Excel's colour scales make it simple to see values in a group of cells. The value in the cell is represented by the colour shade.
6.Quick Analysis Button : To utilize the Quick Analysis tool, click the Quick Analysis button emerge in the lower-right corner of the cells that is last selected . When it is clicked, a palette of options displays beneath the tool, ranging from Formatting to Sparklines. One may quickly format their data into a chart, table, formatted data or sparkline with the Quick Analysis tool.
7.Currency Format ($ symbol here): For general monetary values any cell can be formatted by right clicking on it and selecting format cells options. Using currency category symbol are chosen and displayed in the cell accordingly.
8.Absolute Reference : In Excel, an absolute reference is one that is "locked" such that rows and columns do not change when copied. An absolute reference, unlike a relative reference, relates to a certain fixed point on a worksheet. In Excel, place a dollar sign before the row and column to create an absolute reference.
Example : Relative reference is for example D2 and absolute is $D$2 formats.
9.Fill Color : Click the Fill Color button's on the Home tab, in the Font group. The drop-down menu is opened up and the Fill Color pallet displays on the screen. From the drop down palette the color is chosen to be applied.
In Microsoft Excel, Borders can be applied to cells in MS Excel. To apply border, select a range of cells to apply a border to. Tab for Borders » Choose a border style to be applied.