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. 1. ============================================== BIS 155 Week 3 Quiz( Data Analysis Functions)
For more course tutorials visit www. uophelp. com
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. 1. ============================================== BIS 155 Week 3 Quiz( Data Analysis Functions)
Week 3 Quiz
For more course tutorials visit www. uophelp. com
1.( 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) 2.( TCO 4) In Excel, the print area is defined as _____.( Points: 2) 3.( TCO 4) When sorting in Excel, it arranges records in a table
_____.( Points: 2) 4.( TCO 4) Filtering the Cost column( field) to show only records greater than $ 10,000 is......__.( Points: 2) 5.( TCO 4) To create a new Conditional Formatting Rule, _____.
( Points: 2) 6.( TCO 4) In addition to sorting and filtering cells by content, you can sort and / or filter by _____.( Points: 2) 7.( TCO 4) When data is grouped, the margin area displays the
_____.( Points: 2) 8.( TCO 4) A _____ allows you to identify relationships between variables in your data.( Points: 2) 9.( TCO 4) Data mining techniques such as PivotTables can detect _____ of data.( Points: 2) 10.( TCO 4) A faster way to expand all categories at one time is to click _____.( Points: 2) 11.( TCO 4) Data displayed in the PivotTable will be updated
_____.( Points: 2)