Re: [ vuZs.net ] IT430 Assignment Guide

no dear, i think its working only in excel 2007

 

On Tue, Nov 1, 2011 at 12:49 PM, mc090402794 Mohammed Haroon Baig <mc090402794@vu.edu.pk> wrote:

when u will try to write this the formula, it  will appear by itself, select it and it will show you the arguments as well, its in capital i think and working ok with me. check the attached file.

 

On Mon, Oct 31, 2011 at 2:11 PM, mc100203362 Asif Iqbal <mc100203362@vu.edu.pk> wrote:

haroon its not working,

 

=dec2bin(10)    result  

#NAME?

 

how this will work???

 

On Mon, Oct 31, 2011 at 4:05 PM, mc100203362 Asif Iqbal <mc100203362@vu.edu.pk> wrote:

very nice bro

 

On Mon, Oct 31, 2011 at 3:20 PM, mc090402794 Mohammed Haroon Baig <mc090402794@vu.edu.pk> wrote:

it is good to know and have practice with the one given, but for assignment purpose you can use formula in EXCEL                    =BIN2DEC(number) for Binary to Decimal and =DEC2BIN(number) for Decimal to Binary conversion  in a shortest time.

On Mon, Oct 31, 2011 at 1:02 PM, Misbah Yousuf <mc080404066@vu.edu.pk> wrote:

Question 1:      (6+4)

 

a) Convert the following IP addresses to binary and vice versa.

 

Solution:

i)

192.168.1.10

10.50.0.20

140.128.1.4

Decimal to Binary:

 

Division	Remainder
192/2
96/2	0
48/2	0
24/2	0
12/2	0
6/2	0
3/2	0
½	1
0/2	1

 

 

  11000000

=2^0×0+2^1×0+2^2×0+2^3×0+2^4×0+2^5×0+2^6×1+2^7×1

=0+0+0+0+0+0+64+128

=192

Follow same procedure for rest of the figures.

Binary to decimal:

10011011.10101011.00110101.11100101

 

 

   10011011

=2^0×1+2^1×1+2^2×0+2^3×1+2^4×1+2^5×0+2^6×0+2^7×1

=1+1+0+8+16+0+0+128

=52

(start multiplying from right to left) 

Follow same procedure for rest of the binary sets.

--
Regards, 

Misbah Yousuf

--
--
Please visit www.vuzs.net For Current & Old Papers, Quizzes, Assignments and study material.
--
You received this message because you are subscribed to the Google
Groups "vuZs" group.
--
To post a new message on this group, send email to vuZs@googlegroups.com
--
Message Posting Rules: http://vuzs.net/faq/4795-vuzs-google-groups-basic-rules-for-posting-messages.html
--
To unsubscribe from this group, send email to vuZs+unsubscribe@googlegroups.com
--
To join this group Send blank email from your virtual university email address to
vuZs+subscribe@googlegroups.com
or visit
http://groups.google.com/group/vuZs/subscribe
---
For more information Contact vuZs Manager at info@vuzs.net

--
--
Please visit www.vuzs.net For Current & Old Papers, Quizzes, Assignments and study material.
--
You received this message because you are subscribed to the Google
Groups "vuZs" group.
--
To post a new message on this group, send email to vuZs@googlegroups.com
--
Message Posting Rules: http://vuzs.net/faq/4795-vuzs-google-groups-basic-rules-for-posting-messages.html
--
To unsubscribe from this group, send email to vuZs+unsubscribe@googlegroups.com
--
To join this group Send blank email from your virtual university email address to
vuZs+subscribe@googlegroups.com
or visit
http://groups.google.com/group/vuZs/subscribe
---
For more information Contact vuZs Manager at info@vuzs.net

--

Best Regards

MBA 3rd Semester

toor.786@gmail.com

--

Best Regards

MBA 3rd Semester

toor.786@gmail.com

--
--
Please visit www.vuzs.net For Current & Old Papers, Quizzes, Assignments and study material.
--
You received this message because you are subscribed to the Google
Groups "vuZs" group.
--
To post a new message on this group, send email to vuZs@googlegroups.com
--
Message Posting Rules: http://vuzs.net/faq/4795-vuzs-google-groups-basic-rules-for-posting-messages.html
--
To unsubscribe from this group, send email to vuZs+unsubscribe@googlegroups.com
--
To join this group Send blank email from your virtual university email address to
vuZs+subscribe@googlegroups.com
or visit
http://groups.google.com/group/vuZs/subscribe
---
For more information Contact vuZs Manager at info@vuzs.net

--
--
Please visit www.vuzs.net For Current & Old Papers, Quizzes, Assignments and study material.
--
You received this message because you are subscribed to the Google
Groups "vuZs" group.
--
To post a new message on this group, send email to vuZs@googlegroups.com
--
Message Posting Rules: http://vuzs.net/faq/4795-vuzs-google-groups-basic-rules-for-posting-messages.html
--
To unsubscribe from this group, send email to vuZs+unsubscribe@googlegroups.com
--
To join this group Send blank email from your virtual university email address to
vuZs+subscribe@googlegroups.com
or visit
http://groups.google.com/group/vuZs/subscribe
---
For more information Contact vuZs Manager at info@vuzs.net

--

Best Regards

MBA 3rd Semester

toor.786@gmail.com

--
--
Please visit www.vuzs.net For Current & Old Papers, Quizzes, Assignments and study material.
--
You received this message because you are subscribed to the Google
Groups "vuZs" group.
--
To post a new message on this group, send email to vuZs@googlegroups.com
--
Message Posting Rules: http://vuzs.net/faq/4795-vuzs-google-groups-basic-rules-for-posting-messages.html
--
To unsubscribe from this group, send email to vuZs+unsubscribe@googlegroups.com
--
To join this group Send blank email from your virtual university email address to
vuZs+subscribe@googlegroups.com
or visit
http://groups.google.com/group/vuZs/subscribe
---
For more information Contact vuZs Manager at info@vuzs.net