Question: This is a homework assignment for Quantitative Business Methods. If anybody is good with Excel and can help explain I would greatly appreciate it! File
This is a homework assignment for Quantitative Business Methods. If anybody is good with Excel and can help explain I would greatly appreciate it!
File Home Insert Page Layout Formulas Data Review View Help Acrobat Calibri 11AA ab Wrap Text General Normal 2 X Cut [b Copy ~ Paste 3 Format Painter Clipboard BIU A Merge & Center $ -% 8-28 Conditional Format as Calculation Formatting Table y Font Alignment Number 16 fo F J K N O c D E H ! M This is a graded assignment reflecting your own work only. Assistance from students, tutors, or outside sources in not permitted. 1. (4pts) Your supervisor asks you to identify the maximum value in a large dataset. Being a sharp QMB student, you recognize that Excel can assist you. a. Copy the following data (including the text header) into cells E13 to E28. b. Sort the cells E13 to E28, ordering the data from largest to smallest with cell E13 containing the largest value and cell E28 the smallest. C. Identify the maximum value. 1 2 3 Sales $207.90 $415.43 $695.30 5 5 $42.18 3 2 3 $873.36 $231.56 $764.54 $567.18 $55.35 $652.25 $552.90 $360.99 $331.82 $83.26 $71.63 5 3 3 e 1 2 3 5 5 7 3 3 2 3 5 5 - 3 e 1 2 3 5 Prob 1 Prob 2 Prob 3 Prob 4 Prob 5
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
