The shortest compressed format of the ipv6 address 2001: 0db8: 0000: 1470: 0000: 0000: 0000: 0200 is

The answer is : 2001:DB80:1470::200

A double colon ( :: ) can replace any single, contiguous string of one or more 16-bit segments (hextets) which is  consist of all 0s, and it can only be used once per IPv6 address. Therefore,any leading 0s (zeros) in any 16-bit section or hextet can be omitted.

since it can be assumed that what aslam is making is a template by compiling all the commonly used excel formatting in several worksheets in an excel document, aslam can choose to save it using the .xltx or .xltm format instead. thus, aslam can distribute the templates he has made to his team members in an easier manner.

to change your username, you must:

1) make sure what the username you want to change to is allowed in this community

2) contact a administrator (for example, jaysl)

3) through pm, tell the admin what you want to change to

4) if the username is allowed, it will be changed in a matter of seconds (minutes at most)

~