BIS 155 Endless Education /uophelp.com BIS 155 Endless Education /uophelp.com | Page 58

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 )