Assigned number is 34257ID 7664 Use assigned numbers in Excel file "Numbers".1. Take last four digits of your assigned number and divide it by 100. For example, ifyour ID is 4537 then you get45.37. Convert this decimal number to binary base. Then convert it from binary to octaland hexadecimal bases. For fractional part stop calculation after finding 3 digits.

Answered: Use assigned numbers in Excel file…

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...

See similar textbooks

Related questions

Question

Assigned number is 34257 ID 7664

Use assigned numbers in Excel file "Numbers".
1. Take last four digits of your assigned number and divide it by 100. For example, if
your ID is 4537 then you get
45.37. Convert this decimal number to binary base. Then convert it from binary to octal
and hexadecimal bases. For fractional part stop calculation after finding 3 digits.

Expert Solution

Step 1

take an excel file named as numbers

There is a group of Excel functions that take into account all combinations of conversion among binary, octal, decimal, and hexadecimal. These functions are shown in the following table.

*Function*	*What It Does*
BIN2DEC	Converts binary to decimal
BIN2HEX	Converts binary to hexadecimal
BIN2OCT	Converts binary to octal
DEC2BIN	Converts decimal to binary
DEC2HEX	Converts decimal to hexadecimal
DEC2OCT	Converts decimal to octal
HEX2BIN	Converts hexadecimal to binary
HEX2DEC	Converts hexadecimal to decimal
HEX2OCT	Converts hexadecimal to octal
OCT2BIN	Converts octal to binary
OCT2DEC	Converts octal to decimal
OCT2HEX	Converts octal to hexadecimal