Question

ENGR 1301 Engineering Practices Lab LAB EXERCISE 4 (Sorting Lists Prof M. Lewis Use Excel to Create and Sort Lists 1. OPEN A NEW EXCEL WORKSHEET 1.1. Worksheet headings are the following; 1.2. Title 1.3. File name 1.4. Your name 1.5. Date TITLE 2. SET UP A FICTITICIOUS LIST 2.1. In column A insert numbers 1 to 10 2.2. Enter 10 fictitious random names and corresponding data in separate columns starting at column B through column K as follows; 2.2.1. Last name 2.2.2. First name 2.2.3. Middle initial 2.2.4. Address number 2.2.5. Address Street name 2.2.6. City 2.2.7. State 2.2.8. Zip Code 2.2.9. Phone number 2.2.10. Email address 2.3. Use the above list as the column headings. 2.4. Save this initial worksheet file as the file name given above. PRINT THIS. (see 3.7) 3. DATING SORTING OPERATIONS 3.1. Highlight the 11 columns [columns A to K] [but not the column headings]. 3.2. Click on the "DATA" tab in the toolbar. 3.3. Then just to the right and below the "DATA" tab, you will see the word "SORT". Click on "SORT". 3.4. A menu box appears that asks you to indicate which column to sort on and in what order {ASCENDING OR DECENDING}. 3.5. Select to sort on the column corresponding to the last name and in ascending order. Click "OK". 3.6. Now the data set is in alphabetical order by last name. PRINT THIS, (see 3.7) 3.7. Note: You will need to print this entire worksheet {all 11 columns} on a single page in "Landscape". For this to fit on the page, you may need to set the font to 10 (or 9). 3.8. Select [highlight] the data set contained in the 11 columns. Click the right mouse button, and on the drop-down menu select"COPY". 3.9. At one or two rows below the data set, "PASTE" in the copy of the data set. Now you have two copies of the sorted data. Again select[ highlight] the upper data block again from columns A to K. Again select "DATA" and then "SORT" and this time sort on column A [ the numbers 1-10] in ascending order. Click "OK". 3.10. Note that the upper data block is now returned to the original unsorted format. 4. SORT DESCENDING 4.1. Select [highlight] the 11 columns of unsorted data. Select "COPY". 4.2. Open worksheet "Sheet 2". Do a "PASTE" on worksheet 2. 4.3. Copy and paste the column headings from sheet 1 to sheet 2. 4.4. Select the 11 data columns on sheet 2. 4.5. Do a "SORT" with the last name in "descending" order. 5. SELECTING COLUMNS 5.1. Select the 11 data columns on sheet 2 and "COPY". 5.2. "PASTE" this two rows below the first block of data on sheet 2. 5.3. "COPY" and "PASTE" in the column headings. 5.4. Select the 11 data columns from the second block of data on sheet 2. 5.5. Do a "SORT" by "city" column in "descending" order. 6. SORTING BY MULTIPLE FIELDS 2 6.1. Now create a data set that is sorted by state, city and then last name. 6.2. "COPY" a data block to worksheet 3. 6.3. Open the sort instructions dialog box. 6.4. Select sort on the column containing the 'state' data. 6.5. Then click on "ADD Level" in the dialog box. Add the column containing the city' data. 6.6. Again click on "ADD Level" in the dialog box. Add the column containing the last name'. 6.7. Click OK. 6.8. Note that the data block has been correctly sorted. 7. LAB EXERCISE 4 REPORT GUIDELINES 7.1. For the "DATA' section, include the worksheets with the unsorted data block and the various sorted data blocks. Put in a heading for each data block indicated the sorting criteria. 7.2. For the "SUMMARY AND CONCLUSIONS" section, explain the significance of each of the sorting options used and how they would be useful in general and the use of column A. IMPORTANT

Get Instant Homework HelpOn Your Mobile

Get Instant Homework HelpOn Your Mobile

Get Instant Homework HelpOn Your Mobile