ACTM Lab TEX3108

Fall 2021

SET 1(A) 

  1. There are few names below. Now make this chart in excel.
First Name Last Name Upper case for last name Full name with proper case Length of lower case Add Dr. before the full name Replace the first name with Cricketer in full name  
Gulbadin Naib    
Samiullah shenwari            
TeEM DaviD            
Shane Bond            
JofrA archer            
Mominul Huq            
Sandeep LamiChanne            
Rabbi hannan            

 

  1. Crete a drop down list with these cities and make sure that shipment quantity remain 50,000 to 1,00,000 pc for any city. If anyone tries to input any values beyond this range, create an error alert for that.
City Shipment Qty
NYC  
Berlin  
Brooklin  
Sydney  
Canberra  
London  
Manchester  
Kampala  

 

 

 

 

 

  1. This is your data.
Month Product Quantity Product ID
December T-Shirt 16000 160010
January Tank top 3459 160011
February Polo Shirt 235 160012
March Long Sleeve T 2040 160013
April Short Sleeve T 7065 160014
May Jacket 6000 160015
March T-shirt 5400 160016
April Polo Shirt 4040 160017
December Tank top 1035 160018
March Short Sleeve T 445 160019
April Long Sleeve T 235 160020
March Jacket 895 160021
April Jacket 7065 160022
April Polo Shirt 6000 160023
April Tank top 1054 160024
March Short Sleeve T 408 160025
December Long Sleeve T 4500 160026
March T-Shirt 3500 160027
December T-Shirt 1000 160028
January T-Shirt 300 160029

 

Now you need to show in excel –

  1. Find out the qty of below products with product ID. If any id is absent in data set, then in the qty collum it will show not available.

 

Product ID Qty
160020  
160016  
160033  
160034  

 

  1. Make an example of H-look up with this data set.
Scroll Below to View Our Previous Reviews

Calculate the price of your order

Continue with Order
Continue with Order
Continue with Order
Continue with Order

Simple Order Process

Fill in the Order Form

Share all the assignment information. Including the instructions, provided reading materials, grading rubric, number of pages, the required formatting, deadline, and your academic level. Provide any information and announcements shared by the professor. Choose your preferred writer if you have one.

Get Your Order Assigned

Once we receive your order form, we will select the best writer from our pool of experts to fit your assignment.

Share More Data if Needed

You will receive a confirmation email when a writer has been assigned your task. The writer may contact you if they need any additional information or clarifications regarding your task

Let Our Essay Writer Do Their Job

Once you entrust us with your academic task, our skilled writers embark on creating your paper entirely from the ground up. Through rigorous research and unwavering commitment to your guidelines, our experts meticulously craft every aspect of your paper. Our process ensures that your essay is not only original but also aligned with your specific requirements, making certain that the final piece surpasses your expectations.

Quality Checks and Proofreading

Upon the completion of your paper, it undergoes a meticulous review by our dedicated Quality and Proofreading department. This crucial step ensures not only the originality of the content but also its alignment with the highest academic standards. Our seasoned experts conduct thorough checks, meticulously examining every facet of your paper, including grammar, structure, coherence, and proper citation. This comprehensive review process guarantees that the final product you receive not only meets our stringent quality benchmarks but also reflects your dedication to academic excellence.

Review and Download the Final Draft

If you find that any part of the paper does not meet the initial instructions, send it back to us with your feedback, and we will make the necessary adjustments.