Question: use Microsoft excel to complete the problem take a picture after you're done thank you 3. Develop a spreadsheet using the data shown below to

use Microsoft excel to complete the problem take a picture after you're done thank you use Microsoft excel to complete the problem take a picture after you're
done thank you 3. Develop a spreadsheet using the data shown below

3. Develop a spreadsheet using the data shown below to perform database sorting and filtering operations, incorporate the following in your spreadsheet: a) Copy the original data. Sort the copied data by air pressure in ascending order. th) Copy the original data. Sort the copied data by humidity in descending order as the primary sort key and force in ascending order as the secondary sort key. c) Copy the original data. Filter the copied data using the Number Filters option for Temperature 2 76.5 AND Temperature s 90.7. Then sort the filtered table by temperature in descending order. Time 8:00 8:30 9:00 9:30 10:00 10:30 11:00 11:30 12:00 12:30 13:00 13:30 14:00 14:30 15:00 16:30 16:00 16:30 17:00 ORIGINAL DATA Temperature (F) Humidity (%) Air Pressure (in hg) 68.0 45 35.45 68.2 46 35.00 68.8 72 36.24 71.0 88 35.95 73.4 92 36.00 76.5 100 35.75 79.5 100 35.00 82.6 95 34.87 84.9 91 35.00 87.0 86 34.70 90.5 88 34.50 90.7 100 35.01 91.3 79 35.00 89.4 82 34.22 94.2 83 35.80 96.1 88 36 50 84.2 69 36.12 86.8 65 36.57 870 68 36.45 Force (lb) 163 167 159 157 168 164 159 151 163 158 164 164 169 172 173 168 155 153 164

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!