EX 802 Excel Chapter&Creating, Sorting and Querying a Table 1. Open the workbook Lab 6-1 City Market. Save the workbook using the file nar 2. Create three new calculated columns, Shelf Life, Days Left, and Grade. The form Lab 2 Note: T name, Lab 6-1 for City Marker Complete. Format the data as a table. calalating the shelf life is ISell By Date)-IStock Date]. The formula for calculatin Left is informa is (Sell By Datej-current Date. (fint currentDate is a named cell, F24)the Problew sales sta d data below 3. The Grade column will require you to create a lookup table area, shown in Table 6 in Table 6-6. The calculation for the Grade column will use the VLOOKUP function that in a table, the irst argument of the VL.OOKUP function references the first cell in dh column that you want to look up (such as G8). The second argument is the range of the table with absolute references (sach as SSsSKS 12) The third argument is the column Perform workbo create b signs. F that yo first pre 1. Sel Th 16 and fill in rating within the lookup table. Table 6 Grade Table Grade Table 4. Create an output area, as shown in Table 6-7, using several COU TIF functions to total the following. Recall that the first argument of the COUNTIE function is the range of data (for instance, the grade ratings in H8:H20, or the type of produce argument is the desired data (such as "A" or "Vegetable). in C8:C20) and the second Table 6-7 Output Area Output Area Grade A Count Grade B Count Grade C Count Vegerable Count mcountifhB:h20,"8) countifth8:h20, c") scountific8 c20,"Vegetable") 5. Add one more item to the Output Area with the count of your favorite fruit or vegeta If you use the correct function and arguments, the count should equal 1.) 6. Save the file again and submit the assignment as requested by your instructor. 7.O If you were to add a criteria range to the workshcet, for what kinds of data andcondiboes woald you search? Why? What criteria would be most important to the owner of the City EX 802 Excel Chapter&Creating, Sorting and Querying a Table 1. Open the workbook Lab 6-1 City Market. Save the workbook using the file nar 2. Create three new calculated columns, Shelf Life, Days Left, and Grade. The form Lab 2 Note: T name, Lab 6-1 for City Marker Complete. Format the data as a table. calalating the shelf life is ISell By Date)-IStock Date]. The formula for calculatin Left is informa is (Sell By Datej-current Date. (fint currentDate is a named cell, F24)the Problew sales sta d data below 3. The Grade column will require you to create a lookup table area, shown in Table 6 in Table 6-6. The calculation for the Grade column will use the VLOOKUP function that in a table, the irst argument of the VL.OOKUP function references the first cell in dh column that you want to look up (such as G8). The second argument is the range of the table with absolute references (sach as SSsSKS 12) The third argument is the column Perform workbo create b signs. F that yo first pre 1. Sel Th 16 and fill in rating within the lookup table. Table 6 Grade Table Grade Table 4. Create an output area, as shown in Table 6-7, using several COU TIF functions to total the following. Recall that the first argument of the COUNTIE function is the range of data (for instance, the grade ratings in H8:H20, or the type of produce argument is the desired data (such as "A" or "Vegetable). in C8:C20) and the second Table 6-7 Output Area Output Area Grade A Count Grade B Count Grade C Count Vegerable Count mcountifhB:h20,"8) countifth8:h20, c") scountific8 c20,"Vegetable") 5. Add one more item to the Output Area with the count of your favorite fruit or vegeta If you use the correct function and arguments, the count should equal 1.) 6. Save the file again and submit the assignment as requested by your instructor. 7.O If you were to add a criteria range to the workshcet, for what kinds of data andcondiboes woald you search? Why? What criteria would be most important to the owner of the City