Reference no: EM132387385
CPT 174 Microcomputer Spreadsheets Assignment - Skills Worksheet, Technical College of the Lowcountry, USA
Instructions: Using a single Excel worksheet, set up appropriate solutions for the problems specified below. You should use appropriate labels to identify the data and results, and choose formatting appropriate to the type of data involved (all financial quantities and all percentages should be expressed to two decimal places). Each problem will require the use of appropriate formula(s) and/or function(s), which you will need to identify and incorporate into your solution. For the first problem a sample layout is included as an example of how to design the solutions to the problems. Make sure each problem is clearly identified with the problem number. Submit your workbook to the appropriate D2L folder in a compressed (i.e. "zipped") folder with the name Skill x Worksheet, where "x" is the module number (1, 2, 3, etc.). Submissions that are not correctly named, or not in a compressed folder, will not be graded.
Test Scores
|
Test 1
|
79
|
Test 2
|
95
|
Test 3
|
83
|
Test 4
|
98
|
1. Test 1 + Test 2 = ________
2. Test 3 + Test 4 = ________
3. If the average of the four tests is equal to or greater than 90, the result is "Good Job", if the average of the four tests is less than 90, the result is "Study Harder". Based on the test scores above, what is the result?