chapter 3 simnet

sort this data alphabetically from A to Z by values in the category column

in the data ribbon cabin the sort and filter ribbon group you clicked the sort a to z button

enable filtering

in the data ribbon tab in the sort and filter ribbon group you clicked the filter button

filter the category column so only rows with coffee are shown

in the data ribbon tab in the sort and filter ribbon group you clicked the filter button. you clicked cell B1, clicked the quick start dropdown. in the table filter menu, you clicked the select all checkbox, click the coffee checkbox, and clicked the ok button

sort this data by values in the cost column so the most expensive items are listed first

in the data ribbon tab in the sort and filter ribbon group you clicked the sort button. inside the sort dialoging the sort by drop-down you selected cost. inside the sort dialog in the order drop-down you selected largest to smallest. inside the sort dialog you clicked the ok button

sort the data columns the oldest dates are listed first

in the data ribbon tan in the sort and filter ribbon group you clicked the sort button. inside the sort dialog you clicked the ok button

use a slicer to filter the detain this table to show only rows where the category value is coffee

in the design ribbon tab in the tools ribbon group you clicked the insert slicer button. inside the insert slicer dialog you checked the category check box, clicked the ok button. you clicked coffee button

convert the table to a normal range

in the design ribbon tab in the tools ribbon group, you clicked the convert to range button. inside the Microsoft excel dialog you clicked the yes button

add slicers to filter the data in this table by date

in the design ribbon tab in the tools ribbon group, you clicked the insert slicer button. inside the insert slicer dialog you checked the data check box then clicked ok

remove duplicate rows where data in all the columns are identical

in the design ribbon tab in the tools ribbon group, you clicked the remove duplicate button. inside the remove duplicate dialog you clicked the ok button . inside the Microsoft excel dialog you clicked the okay button

apply conditional formatting to the selected cells so cells with a value greater than 400 are formatted using a light red fill

in the home ribbon tab in the styles ribbon group you clicked the conditional formatting button. in the conditional formatting menu in the highlight cells rules mine you clicked the greater than menu item. inside the greater than dialog you typed 400 in the format cells that are greater than: input. inside the greater than dialoging in the with drop down you selected light red fill. inside the greater than dialog you clicked the ok button

convert the cell range to a table using table style table style light 8 (the first stall in the second row under the light styles) the table should include headers

in the home ribbon tab in the styles ribbon group you clicked the format as table button. in the format as table menu you sleeted the table style light 8 option. inside the format as table dialog, you clicked the ok button

apply conditional formatting to the selected cells using the red gradient fill data bar

in the home ribbon tab in the styles ribbon group, you clicked the conditional formatting button. in the conditional formatting menu in the data bars menu, you selected the red data bar gradient option

apply conditional formatting the selected cells so cells with the 10 lowest values are formatted with green fill and dark green text

in the home ribbon tab in the styles ribbon group, you clicked the conditional formatting button. in the conditional formatting menu in the top/bottom rules menu you clicked the bottom 10 items menu item. inside the bottom 10 items dialog in the format selector box drop-down you selected the green fill with dark green text. inside the bottom 10 items dialog you clicked the ok button

Insert a recommended PivotTable, using the Sum of Bonus by Employee option

in the insert ribbon tab in the tables ribbon group you clicked the recommended pivotable button. inside the recommended pivotables dialog from the pivotable list you clicked the sum of bonus by employee item. inside the recommended pivotables dialog you clicked the ok button

use the quick analysis tool to apply the data bars conditional formatting option to the selected cells

you clicked the quick analysis tool button, clicked data bars button