BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 85

Assume the role of a regional manager for a retail organization looking at ways to analyze the large amounts of sales data you have. Give some examples. Note: As you answer these questions, a recommended approach would be to attach a sample Excel spreadsheet that you can use to illustrate your answers. ========================================= BIS 155 Week 3 Quiz (Data Analysis Functions) For more course tutorials visit www.tutorialrank.com Week 3 Quiz (TCO 4) If there are certain columns of information that are not needed at a particular time but might be needed later,_ the unneeded columns to allow users to focus on only the essential information. (Points:2) (TCO 4) In Excel, the print area is defined as _____. (Points : 2) (TCO 4) When sorting in Excel, it arranges records in a table _____. (Points : 2) (TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is......__. (Points:2) (TCO 4) To create a new Conditional Formatting Rule, _____. (Points : 2)