Question: use excel after complete take a picture this is a engeniering problem solving question Assignment 1.pro - Saved to my Mac View Tell me ferences
Assignment 1.pro - Saved to my Mac View Tell me ferences Mailings Review c c Normal No Spacing ing 5. Develop a spreadsheet using the data shown below to perform database sorting and filtering operations, incorporate the following in your spreadsheet: a) Center all headings and numeric values. b) Place a grid patter on your spreadsheet and identify cach section. c) Identify all columns with field names, .) Copy the original data. Sort the copied data by temperature in descending order e) Copy the original data. Sort the copied data by humidity in ascending order as the primary sort key and air pressure in descending order as the secondary sort key 6) Copy the original data. Filter the copied data using the Number Filters option for Force 2 153 AND Force 164. Then sort the filtered list by force in ascending order. Tiene BEDO 8.30 1 30 719 19 20 1100 1030 23.00 ORIGINAL DATA TemperatureHurity Air Pressure in hal Foro 08.0 45 3545 382 46 35 DO 72 30 24 08 0595 157 7.4 92 30.00 705 100 795 100 35.00 RS 05 114.9 91 15.00 870 163 86 3.70 305 14.50 154 50g 33520 79 25.00 204 12 172 2 3D TI 09 BEEEEEEEEEEEEEEEEE 2300 14:30 19.00 1500 STO B 7 Assignment 1.pro - Saved to my Mac View Tell me ferences Mailings Review c c Normal No Spacing ing 5. Develop a spreadsheet using the data shown below to perform database sorting and filtering operations, incorporate the following in your spreadsheet: a) Center all headings and numeric values. b) Place a grid patter on your spreadsheet and identify cach section. c) Identify all columns with field names, .) Copy the original data. Sort the copied data by temperature in descending order e) Copy the original data. Sort the copied data by humidity in ascending order as the primary sort key and air pressure in descending order as the secondary sort key 6) Copy the original data. Filter the copied data using the Number Filters option for Force 2 153 AND Force 164. Then sort the filtered list by force in ascending order. Tiene BEDO 8.30 1 30 719 19 20 1100 1030 23.00 ORIGINAL DATA TemperatureHurity Air Pressure in hal Foro 08.0 45 3545 382 46 35 DO 72 30 24 08 0595 157 7.4 92 30.00 705 100 795 100 35.00 RS 05 114.9 91 15.00 870 163 86 3.70 305 14.50 154 50g 33520 79 25.00 204 12 172 2 3D TI 09 BEEEEEEEEEEEEEEEEE 2300 14:30 19.00 1500 STO B 7
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
