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