Chapter 3 Simnet Study Guide Test.

Chapter 3 Simnet Study Guide Test. use a slicer to filter the detain this table to show only rows where the category value is coffee - CORRECT ANSWER 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 sort this data by values in the cost column so the most expensive items are listed first - CORRECT ANSWER 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 use the quick analysis tool to apply the data bars conditional formatting option to the selected cells - CORRECT ANSWER you clicked the quick analysis tool button, clicked data bars button add slicers to filter the data in this table by date - CORRECT ANSWER 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 apply conditional formatting to the selected cells using the red gradient fill data bar - CORRECT ANSWER 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 sort this data alphabetically from A to Z by values in the category column - CORRECT ANSWER in the data ribbon cabin the sort and filter ribbon group you clicked the sort a to z button remove duplicate rows where data in all the columns are identical - CORRECT ANSWER 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