Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Question 1 Sort the data on the basis of the length of the name (descending order). Nime City Product James Carn London Coconut Hazelnut Ricky Martin Samuel Sean Andreaw Mils Paris Tokyo Bangkok Patna Newyork Paris Coconut Mango Banana Kelly Lewis Jordan Sngh Sona Tyagi Tiger wood Maria Dean Darny Duu Schera Chuu Mango Date Being New Delhi Orange Hazelnut Apple Mango Mango Carberra Bangalore Ontario Sudhi Arora Suit Kumar ha London Banana Use right and left function to remove the 1st and last letter from the city name. So if we have Boston - we want the result to be Question 2 'osto Name City Product London Paris James carn Mango Ricky Martin Hazelnut Pire Apple Apple Apple Banana Samuel Sean Tokyo Andreaw Mils Bangkck Patna Kelly Lewis Jordan singh Sorka Tyag Tiger wood Maria Dean Darny Duu Schera Chuu Newyork Paris Banana Being New Delhi Carberra Apple Coconut Hazelnut Banglore Kolkata Сесс Mango Sudhir Arora Create a new column using PostCode and it shoud be of length 5 (Add d's at the front if the length of the postcode is less t Question 3 City PostCode London 251866 Paris 10068 Tokyo Bargkok Patna 1002 25 8512 125896 Newyork Paris 325 Being New Delhi 8541 Carberra 23 Question 4 Please put the first name and last name in their respective columns Nme Arkit Sngh Sachn Gupta Rajev ha James Carn Frst Nime Last name Ricky Martn Samul Sean Kelly Lewis Tiger wood Maria Dean Darny Duu Sumit Tyag

Question 1 Sort the data on the basis of the length of the name (descending order). Nime City Product James Carn London Coconut Hazelnut Ricky Martin Samuel Sean Andreaw Mils Paris Tokyo Bangkok Patna Newyork Paris Coconut Mango Banana Kelly Lewis Jordan Sngh Sona Tyagi Tiger wood Maria Dean Darny Duu Schera Chuu Mango Date Being New Delhi Orange Hazelnut Apple Mango Mango Carberra Bangalore Ontario Sudhi Arora Suit Kumar ha London Banana Use right and left function to remove the 1st and last letter from the city name. So if we have Boston - we want the result to be Question 2 'osto Name City Product London Paris James carn Mango Ricky Martin Hazelnut Pire Apple Apple Apple Banana Samuel Sean Tokyo Andreaw Mils Bangkck Patna Kelly Lewis Jordan singh Sorka Tyag Tiger wood Maria Dean Darny Duu Schera Chuu Newyork Paris Banana Being New Delhi Carberra Apple Coconut Hazelnut Banglore Kolkata Сесс Mango Sudhir Arora Create a new column using PostCode and it shoud be of length 5 (Add d's at the front if the length of the postcode is less t Question 3 City PostCode London 251866 Paris 10068 Tokyo Bargkok Patna 1002 25 8512 125896 Newyork Paris 325 Being New Delhi 8541 Carberra 23 Question 4 Please put the first name and last name in their respective columns Nme Arkit Sngh Sachn Gupta Rajev ha James Carn Frst Nime Last name Ricky Martn Samul Sean Kelly Lewis Tiger wood Maria Dean Darny Duu Sumit Tyag

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

Umm this one is on excel commands need help. 

 

EXCEL COMMANDS

73 74 75 76 Question 5 Please find out Group from Mapping Sheet for each EMP ID 77 78 79 BMPD Group 80 13000 12 5000 5212 81 82 13 Macpng Sheet 83 14 13000 Salary 9000-0000 Group 84 S212 16 14900 451 85 86 1200-13000 B 87 18 12000 13001-Greater Than 13000 8000 88 19 20 21 22 23 89 Other Wise 90 91 3000 92 5000 93 24 520 94 25 13000 26 27 28 29 30 95 96 14500 5000 98 T000 99 35125 31 8000 12 04 Question 6 Please count the no. of observations which are greater than 10 Data Result 99 56 14 of 16 12 T13 T14 99 15 18 20 21 22 23 24 17 18 121 122 123 124 125 28 29 127 30 28 129 130 131 132 14 133 34 16 35 8. 136 87 137 138 20 139 140 141
Transcribed Image Text:73 74 75 76 Question 5 Please find out Group from Mapping Sheet for each EMP ID 77 78 79 BMPD Group 80 13000 12 5000 5212 81 82 13 Macpng Sheet 83 14 13000 Salary 9000-0000 Group 84 S212 16 14900 451 85 86 1200-13000 B 87 18 12000 13001-Greater Than 13000 8000 88 19 20 21 22 23 89 Other Wise 90 91 3000 92 5000 93 24 520 94 25 13000 26 27 28 29 30 95 96 14500 5000 98 T000 99 35125 31 8000 12 04 Question 6 Please count the no. of observations which are greater than 10 Data Result 99 56 14 of 16 12 T13 T14 99 15 18 20 21 22 23 24 17 18 121 122 123 124 125 28 29 127 30 28 129 130 131 132 14 133 34 16 35 8. 136 87 137 138 20 139 140 141
ISTICAL - NORM... FINANCIAL functions More questions K 1 2 Question 1 Sort the data on the basis of the length of the name (descending order). 4 City Product Name James Cann London Coconut Ricky Martin Paris Hazelnut Samuel Sean Tokyo Bangkok Coconut Andreaw MIIS Mango Kelly Lewis Patna Banana Jordan Singh Newyork Paris Mango Sorika Tyagi Date Tiger wood Orange Bejing 4 Maria Dean New Delhi Hazelnut Danny Duu Carberra Apple Mango Mango Schera Chuu Bangalore Sudhir Arora Suit Kumar ha Ontarip London Banana 20 21 22 23 Use right and left function to remove the 1st and last letter from the city name. So if we have Boston - we want the result to be Question 2 'osto 24 25 26 27 28 29 30 Product Name City James can London Mango Ricky Mar tin Paris Hazelnut Pine Apple Apple Samuel Sean Tokyo Bangkok Andreaw Mils Kelly Lewis Jordan singh Apple Banana Patna 31 32 Newyork Sorika Tyagi Tiger wood Paris Banana 33 Being Apple 34 35 Maria Dean New Delhi Соссrut Danny Duu Canberra Hazelnut 36 Schera Chuu Bangalore Coconut 37 38 39 40 41 42 43 44 45 46 47 48 49 Sudhir Arora Kolkata Mango Question 3 Create a new column using PostCode and it should be of length 5 (Add O's at the front if the length of the postcode is less th City PostCode London 251866 Paris 110068 Tokyo 11002 Bangkok 25 Patna 8512 Newyork 125896 Paris 325 52 1 Beijing New Delhi 8541 54 Canberra 23 57 Question 4 Please put the first name and last name in their respective columns Frst Name Last name Name Arkit Singh Sachn Gupta Rajev ha 34 James Carn Ricky Mar tin Samul Sean Kelly Lewis Tiger wood Maria Dean Darny Du Sumit Tyag 72 73
Transcribed Image Text:ISTICAL - NORM... FINANCIAL functions More questions K 1 2 Question 1 Sort the data on the basis of the length of the name (descending order). 4 City Product Name James Cann London Coconut Ricky Martin Paris Hazelnut Samuel Sean Tokyo Bangkok Coconut Andreaw MIIS Mango Kelly Lewis Patna Banana Jordan Singh Newyork Paris Mango Sorika Tyagi Date Tiger wood Orange Bejing 4 Maria Dean New Delhi Hazelnut Danny Duu Carberra Apple Mango Mango Schera Chuu Bangalore Sudhir Arora Suit Kumar ha Ontarip London Banana 20 21 22 23 Use right and left function to remove the 1st and last letter from the city name. So if we have Boston - we want the result to be Question 2 'osto 24 25 26 27 28 29 30 Product Name City James can London Mango Ricky Mar tin Paris Hazelnut Pine Apple Apple Samuel Sean Tokyo Bangkok Andreaw Mils Kelly Lewis Jordan singh Apple Banana Patna 31 32 Newyork Sorika Tyagi Tiger wood Paris Banana 33 Being Apple 34 35 Maria Dean New Delhi Соссrut Danny Duu Canberra Hazelnut 36 Schera Chuu Bangalore Coconut 37 38 39 40 41 42 43 44 45 46 47 48 49 Sudhir Arora Kolkata Mango Question 3 Create a new column using PostCode and it should be of length 5 (Add O's at the front if the length of the postcode is less th City PostCode London 251866 Paris 110068 Tokyo 11002 Bangkok 25 Patna 8512 Newyork 125896 Paris 325 52 1 Beijing New Delhi 8541 54 Canberra 23 57 Question 4 Please put the first name and last name in their respective columns Frst Name Last name Name Arkit Singh Sachn Gupta Rajev ha 34 James Carn Ricky Mar tin Samul Sean Kelly Lewis Tiger wood Maria Dean Darny Du Sumit Tyag 72 73
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Data Binding
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS