1. The following question is based on Figure 1.1: Micros File Home Insert Page Layout Formulas Data Review View Cut Genera Calbri 11 Wrap Text Sa Copy Paste Merge & Center Format Painter Fent G24 Student ID Student Name State Age Major SO03 Fatihah Alias Terengganu 20 IT Melaka 25 Science Balqis Amin Sarimah Hasssan SOOS Johor 24 Business So02 21 IT SO08 Saugi Yusuf Kedah Perlis 23 Economics SO07 Haron Bachik Selangor 19 Account SO09 Deraman Helah Kelantan 25 Science SO06 Gina Rais Perak 20 Arts SO04 Ramlan Ramlee Kedah 21 IT SO08 Sauqi Yusuf 123AS 67
1. The following question is based on Figure 1.1: Micros File Home Insert Page Layout Formulas Data Review View Cut Genera Calbri 11 Wrap Text Sa Copy Paste Merge & Center Format Painter Fent G24 Student ID Student Name State Age Major SO03 Fatihah Alias Terengganu 20 IT Melaka 25 Science Balqis Amin Sarimah Hasssan SOOS Johor 24 Business So02 21 IT SO08 Saugi Yusuf Kedah Perlis 23 Economics SO07 Haron Bachik Selangor 19 Account SO09 Deraman Helah Kelantan 25 Science SO06 Gina Rais Perak 20 Arts SO04 Ramlan Ramlee Kedah 21 IT SO08 Sauqi Yusuf 123AS 67
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
1. List down the steps to sort the data based on the Student Name.
2. How many students are from Kelantan? Filter the data by State.
![LAB EXERCISE
1. The following question is based on Figure 1.1:
dataxisx
Micro
Fle
Home
Insert
Page Layout
Formulas
Data
View
Review
Genera
Calbri
A A
C Wrap Text
11
Ra Copy
Paste
E Merge & Center-
Format Painter
Chpbeard
Font
Allgnment
G24
Student Name
State
Age
Major
Student ID
SO03
Fatihah Alias
Terengganu
20
IT
25
Science
SOOS
Balqis Amin
Melaka
Johor
24
Business
SO02
Sarimah Hasssan
Sauqi Yusuf
Kedah
21
IT
SO08
Perlis
23
Economics
S007
Haron Bachik
Selangor
19
Account
SO09
Deraman Helah
Kelantan
25
Science
So06
Gina Rais
Perak
20
Arts
So04
Ramlan Ramlee
Kedah
21
IT
SO08
Sauqi Yusuf
10
Pahang
21
Account
SO01
Farid Hamid
11
Kelantan
23
Account
SO09
Dzul Ahmed
12
Figure I.1. A Students File
1234S67997](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Faa781be9-e1d9-4273-b77c-d8f0529ea30b%2F6eccafdc-5bbd-4a69-82b7-cfb890466a9f%2Fegcdeqq_processed.jpeg&w=3840&q=75)
Transcribed Image Text:LAB EXERCISE
1. The following question is based on Figure 1.1:
dataxisx
Micro
Fle
Home
Insert
Page Layout
Formulas
Data
View
Review
Genera
Calbri
A A
C Wrap Text
11
Ra Copy
Paste
E Merge & Center-
Format Painter
Chpbeard
Font
Allgnment
G24
Student Name
State
Age
Major
Student ID
SO03
Fatihah Alias
Terengganu
20
IT
25
Science
SOOS
Balqis Amin
Melaka
Johor
24
Business
SO02
Sarimah Hasssan
Sauqi Yusuf
Kedah
21
IT
SO08
Perlis
23
Economics
S007
Haron Bachik
Selangor
19
Account
SO09
Deraman Helah
Kelantan
25
Science
So06
Gina Rais
Perak
20
Arts
So04
Ramlan Ramlee
Kedah
21
IT
SO08
Sauqi Yusuf
10
Pahang
21
Account
SO01
Farid Hamid
11
Kelantan
23
Account
SO09
Dzul Ahmed
12
Figure I.1. A Students File
1234S67997
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 5 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY