Pages

Sunday, January 29, 2012

Monday, January 16, 2012

Saving and Using an Excel 2010 Macro-Enabled Workbook - For Dummies

Saving and Using an Excel 2010 Macro-Enabled Workbook - For Dummies

While I was working on my excel sheet and student details(records), I got a call from my boss. I was asked to create folder of each row (each row consist of student details). When I looked at excel sheet I was shocked that I have to create almost 250 folders and it was a nightmare. I decided look for help and I search it on not other than google. After searching for almost 30 minutes, I discovered this beautiful script(macro) perfectly related to my work. I tested it and works fine and did my job. I decided to share this information with my readers and other people who are looking for simple macro to work on.

Have a lovely day.

Check macro at Dummies








Hope it will help you in your learning.Best of Luck and keep visiting the Blog.


Saturday, June 12, 2010

FIFA WORLD CUP 2010

JULES RIMET TROPHY

FIFA WORLD CUP fever is back all over the world. Everyone is looking forward for it and supporting their favourite teams. This is the only sports which is being watched by millions of users all over the world and the whole world is crazy about it.

Follow me on Twitter and Click here for more...


Thanks for visiting the blog.




Hope it will help you in your learning. Best of Luck and keep visiting the Blog.


Monday, May 31, 2010

1st Annual Pakistan Blog Awards

1st Annual Pakistan Blog Awards & New Media UnConference 2010

May 28th, 1998 was the day of proud PAKISTANI. This day is commonly known as Yum – e – Takbeer, when Pakistan successfully tested its nuclear technology. Friday the 28th May, 2010 CIO Pakistan and Google gave me and more bloggers like me a great chance for being social and get together with talented bloggers of Pakistan. They hosted a dominant and successful event “1st Annual Pakistan Blog Awards and New Media UnConference 2010” and gave more than 250 bloggers and corporate to come out of virtual world and socialize oneself. The event presenter was none other than our favourite MADAM RABIA GARIB one of the most talented and charming personality. The experience was nice and ended in a splendid manner including the prizes won by the best bloggers in more than 40 categories.
To find and read more about it follow the link ----- > BLOG AWARDS


Hope it will help you in your learning.Best of Luck and keep visiting the Blog.

Sunday, May 23, 2010

Assignment Sample

Hi dear fellows, here you can download the assignment draft and the packet tracer file for you to have an idea how to deal with these type of questions and assignments. It will also help you in your skill test.

Wish you best of Luck!

Cheers.

Assessment File

Packet Tracer File





Hope it will help you in your learning.
Best of Luck and keep visiting the Blog.


Wednesday, May 19, 2010

FREE ACCOUNT

Rapidshare FreePremium Account.

Click on the referral link below to continue.

http://www.freepremiumaccounts.com/?r=1017145

Thank you and have a nice day.




Hope it will help you in your learning. Best of Luck and keep visiting the Blog.

Saturday, April 10, 2010

CCNA 3 Exploration - Chapter 3

E-Switching Chapter 3 - CCNA Exploration: LAN Switching and Wireless (Version 4.0)

Provided by : Malcolm

1. What is the effect of the switchport mode dynamic desirable command?

DTP cannot negotiate the trunk since the native VLAN is not the default VLAN.
The remote connected interface cannot negotiate a trunk unless it is also configured as dynamic desirable.
The connected devices dynamically determine when data for multiple VLANs must be transmitted across the link and bring the trunk up as needed.
A trunk link is formed if the remote connected device is configured with the switchport mode dynamic auto or switchport mode trunk commands.




2. Refer to the exhibit. The network administrator has just added VLAN 50 to Switch1 and Switch2 and assigned hosts on the IP addresses of the VLAN in the 10.1.50.0/24 subnet range. Computer A can communicate with computer B, but not with computer C or computer D. What is the most likely cause of this problem?

There is a native VLAN mismatch.
The link between Switch1 and Switch2 is up but not trunked.
The router is not properly configured for inter-VLAN routing.
VLAN 50 is not allowed to entering the trunk between Switch1 and Switch2.


3. Switch port fa0/1 was manually configured as a trunk, but now it will be used to connect a host to the network. How should the network administrator reconfigure switch port Fa0/1?

Disable DTP.
Delete any VLANs currently being trunked through port Fa0/1.
Administratively shut down and re-enable the interface to return it to default.
Enter the switchport mode access command in interface configuration mode.


4. What statements describe how hosts on VLANs communicate?

Hosts on different VLANs use VTP to negotiate a trunk.
Hosts on different VLANs communicate through routers.
Hosts on different VLANs should be in the same IP network.
Hosts on different VLANs examine VLAN ID in the frame tagging to determine if the frame for their network.


5. What happens to the member ports of a VLAN when the VLAN is deleted?

The ports cannot communicate with other ports.
The ports default back to the management VLAN.
The ports automatically become a part of VLAN1.
The ports remain a part of that VLAN until the switch is rebooted. They then become members of the management VLAN.


6. Which two statements describe the benefits of VLANs? (Choose two.)

VLANs improve network performance by regulating flow control and window size.
VLANs enable switches to route packets to remote networks via VLAN ID filtering.
VLANs reduce network cost by reducing the number of physical ports required on switches.
VLANs improve network security by isolating users that have access to sensitive data and applications.
VLANs divide a network into smaller logical networks, resulting in lower susceptibility to broadcast storms.



7. Refer to the exhibit. Computer 1 sends a frame to computer 4. On which links along the path between computer 1 and computer 4 will a VLAN ID tag be included with the frame?

A
A, B
A, B, D, G
A, D, F
C, E
C, E, F



8. Refer to the exhibit. The exhibited configurations do not allow the switches to form a trunk. W cause of this problem?

Cisco switches only support the ISL trunking protocol.
The trunk cannot be negotiated with both ends set to auto.
By default, Switch1 will only allow VLAN 5 across the link.
A common native VLAN should have been configured on the switches.


9. A network administrator is removing several VLANs from a switch. When the administrator enters the no vlan 1 command, an error is received. Why did this command generate an error?

VLAN 1 can never be deleted.
VLAN 1 can only be deleted by deleting the vlan.dat file.
VLAN 1 can not be deleted until all ports have been removed from it.
VLAN 1 can not be deleted until another VLAN has been assigned its responsibilities.


10.
Refer to the exhibit. Which statement is true concerning interface Fa0/5?

The default native VLAN is being used.
The trunking mode is set to auto.
Trunking can occur with non-Cisco switches.
VLAN information about the interface encapsulates the Ethernet frames.


11.
Refer to the exhibit. SW1 and SW2 are new switches being installed in the topology shown in the exhibit. Interface Fa0/1 on switch SW1 has been configured with trunk mode “on”. Which statement is true about forming a trunk link between the switches SW1 and SW2?

Interface Fa0/2 on switch SW2 will negotiate to become a trunk link if it supports DTP.
Interface Fa0/2 on switch SW2 can only become a trunk link if statically configured as a trunk.
Interface Fa0/1 converts the neighboring link on the adjacent switch into a trunk link if the neighboring interface is config no negotiate mode.
Interface Fa0/1 converts the neighboring link on the adjacent switch into a trunk link automatically with no consideration configuration on the neighboring interface.


12.
Refer to the exhibit. How far is a broadcast frame that is sent by computer A propagated in the LAN domain?

none of the computers will receive the broadcast frame
computer A, computer B, computer C
computer A, computer D, computer G
computer B, computer C
computer D, computer G
computer A, computer B, computer C, computer D, computer E, computer F, computer G, computer H, computer I


13.
Refer to the exhibit. Computer B is unable to communicate with computer D. What is the most likely cause of this problem?

The link between the switches is up but not trunked.
VLAN 3 is not an allowed VLAN to enter the trunk between the switches.
The router is not properly configured to route traffic between the VLANs.
Computer D does not have a proper address for the VLAN 3 address space.


14. The network administrator wants to separate hosts in Building A into two VLANs numbered 20 and 30. Which two statements are true concerning VLAN configuration? (Choose two.)

The VLANs may be named.
VLAN information is saved in the startup configuration.
Non-default VLANs created manually must use the extended range VLAN numbers.
The network administrator may create the VLANs in either global configuration mode or VLAN database mode.
Both VLANs may be named BUILDING_A to distinguish them from other VLANs in different geographical locations.


15.
Refer to the exhibit. Which two conclusions can be drawn regarding the switch that produced the output shown? (Choose two.)

The network administrator configured VLANs 1002-1005.
The VLANs are in the active state and are in the process of negotiating configuration parameters.
A FDDI trunk has been configured on this switch.
The command switchport access vlan 20 was entered in interface configuration mode for Fast Ethernet interface 0/1.
Devices attached to ports fa0/5 through fa0/8 cannot communicate with devices attached to ports fa0/9 through fa0/12 without the use of a Layer 3 device.


16. What are two characteristics of VLAN1 in a default switch configuration? (Choose two.)

VLAN1 should renamed.
VLAN 1 is the management VLAN.
All switch ports are members of VLAN1.
Only switch port 0/1 is assigned to VLAN1.
Links between switches must be members of VLAN1.


17. What must the network administrator do to remove Fast Ethernet port fa0/1 from VLAN 2 and assign it to VLAN 3?


Enter the no vlan 2 and the vlan 3 commands in global configuration mode.
Enter the switchport access vlan 3 command in interface configuration mode.
Enter the switchport trunk native vlan 3 command in interface configuration mode.
Enter the no shutdown in interface configuration mode to return it to the default configuration and then configure the port for VLAN 3.


18.
Refer to the exhibit. Company HR is adding PC4, a specialized application workstation, to a new company office. The company will add a switch, S3, connected via a trunk link to S2, another switch. For security reasons the new PC will reside in the HR VLAN, VLAN 10. The new office will use the 172.17.11.0/24 subnet. After installation, the existing PCs are unable to access shares on PC4. What is the likely cause?

The switch to switch connection must be configured as an access port to permit access to VLAN 10 on S3.
The new PC is on a different subnet so Fa0/2 on S3 must be configured as a trunk port.
PC4 must use the same subnet as the other HR VLAN PCs.
A single VLAN cannot span multiple switches.


19. What statement about the 802.1q trunking protocol is true?

802.1q is Cisco proprietary.
802.1q frames are mapped to VLANs by MAC address.
802.1q does NOT require the FCS of the original frame to be recalculated.
802.1q will not perform operations on frames that are forwarded out access ports.


20. What is a valid consideration for planning VLAN traffic across multiple switches?

Configuring interswitch connections as trunks will cause all hosts on any VLAN to receive broadcasts from the other VLANs.
A trunk connection is affected by broadcast storms on any particular VLAN that is carried by that trunk.
Restricting trunk connections between switches to a single VLAN will improve efficiency of port usage.
Carrying all required VLANs on a single access port will ensure proper traffic separation.


21. What switch port modes will allow a switch to successfully form a trunking link if the neighboring switch port is in "dynamic desirable" mode?

dynamic desirable mode
on or dynamic desirable mode
on, auto, or dynamic desirable mode
on, auto, dynamic desirable, or nonegotiate mode




The Result is satisfactory. If you find any wrong answer please don't hesitate to comment or email me. Thanks for visiting the blog.







Hope it will help you in your learning.
Best of Luck and keep visiting the Blog.
Don't forget to click on Adsence!!


Friday, April 9, 2010

CCNA 3 Exploration - Chapter 2

E-Switching Chapter 2 - CCNA Exploration: LAN Switching and Wireless (Version 4.0)

Provided by : Malcolm


1. Which command line interface (CLI) mode allows users to configure switch parameters, such as the hostname and password?

user EXEC mode
privileged EXEC mode
global configuration mode
interface configuration mode


2. Refer to the exhibit. The exhibit shows partial output of the show running-config command. The enable password on this switch is "cisco." What can be determined from the output shown?



The enable password is encrypted by default.
An MD5 hashing algorithm was used on all encrypted passwords.
Any configured line mode passwords will be encrypted in this configuration.
This line represents most secure privileged EXEC mode password possible.


3. Which statement is true about the command banner login "Authorized personnel Only" issued on a switch?

The command is entered in privileged EXEC mode.
The command will cause the message Authorized personnel Only to display before a user logs in.
The command will generate the error message % Ambiguous command: "banner motd" ” to be displayed.
The command will cause the message End with the character “%” to be displayed after the command is entered into the switch.


4. A network administrator uses the CLI to enter a command that requires several parameters. The switch responds with "% Incomplete command". The administrator cannot remember the missing parameters. What can the administrator do to get the parameter information?

append ? to the last parameter
append a space and then ? to the last parameter
use Ctrl-P to show a parameter list
use the Tab key to show which options are available


5. Where is the startup configuration stored?

DRAM
NVRAM
ROM
startup-config.text


6. Refer to the exhibit. The switch and workstation are administratively configured for full-duplex operation. Which statement accurately reflects the operation of this link?



No collisions will occur on this link.
Only one of the devices can transmit at a time.
The switch will have priority for transmitting data.
The devices will default back to half duplex if excessive collisions occur.


7. Refer to the exhibit. The network administrator’s attempts to connect to Switch1 via Secure Shell are failing. What is most likely the problem?




incorrect vty lines configured
incorrect default gateway address
incompatible Secure Shell version
vty lines that are configured to allow only Telnet


8. What are two ways to make a switch less vulnerable to attacks like MAC address flooding, CDP attacks, and Telnet attacks? (Choose two.)

Enable CDP on the switch.
Change passwords regularly.
Turn off unnecessary services.
Enable the HTTP server on the switch.
Use the enable password rather than the enable secret password.


9. Refer to the exhibit. What happens when Host 1 attempts to send data?



Frames from Host 1 cause the interface to shut down.
Frames from Host 1 are dropped and no log message is sent.
Frames from Host 1 create a MAC address entry in the running-config.
Frames from Host 1 will remove all MAC address entries in the address table.


10. When a switch receives a frame and the source MAC address is not found in the switching table, what action will be taken by the switch to process the incoming frame?

The switch will request that the sending node resend the frame.
The switch will issue an ARP request to confirm that the source exists.
The switch will map the source MAC address to the port on which it was received.
The switch ends an acknowledgement frame to the source MAC of this incoming frame.


11. What happens when the transport input ssh command is entered on the switch vty lines?

The SSH client on the switch is enabled.
Communication between the switch and remote users is encrypted.
A username/password combination is no longer needed to establish a secure remote connection to the switch.
The switch requires remote connections via proprietary client software.


12. Refer to the exhibit. The switch and the hub have default configurations, and the switch has built its CAM table. Which of the hosts will capture a copy of the frame when workstation A sends a unicast packet to workstation C?


workstation C
workstations B and C
workstations A, B, C, and the interfaces of the router
workstations B, C, D, E, F, and interfaces of the router


13. Which two statements are true regarding switch port security? (Choose two.)



The three configurable violation modes all log violations via SNMP.
Dynamically learned secure MAC addresses are lost when the switch reboots.
The three configurable violation modes all require user intervention to re-enable ports.
After entering the sticky parameter, only MAC addresses subsequently learned are converted to secure MAC addresses.
If fewer than the maximum number of MAC addresses for a port are configured statically, dynamically learned addresses are added to CAM until the maximum number is reached.


14. Which two statements about Layer 2 Ethernet switches are true? (Choose two.)

Layer 2 switches prevent broadcasts.
Layer 2 switches have multiple collision domains.
Layer 2 switches route traffic between different networks.
Layer 2 switches decrease the number of broadcast domains.
Layer 2 switches can send traffic based on the destination MAC address.


15. Refer to the exhibit. What action does SW1 take on a frame sent from PC_A to PC_C if the MAC address table of SW1 is empty?

SW1 drops the frame.
SW1 floods the frame on all ports on SW1, except port Fa0/1.
SW1 floods the frame on all ports on the switch, except Fa0/23 and Fa0/1.
SW1 uses the CDP protocol to synchronize the MAC tables on both switches and then forwards the frame to all ports on


16. When a collision occurs in a network using CSMA/CD, how do hosts with data to transmit respond after the backoff period has expired?

The hosts return to a listen-before-transmit mode.
The hosts creating the collision have priority to send data.
The hosts creating the collision retransmit the last 16 frames.
The hosts extend their delay period to allow for rapid transmission.


17. Which two statements are true about EXEC mode passwords? (Choose two.)

The enable secret password command stores the configured password in plain text.
The enable secret password command provides better security than the enable password.
The enable password and enable secret password protect access to privileged EXEC mode.
The service password-encryption command is required to encrypt the enable secret password.
Best practices require both the enable password and enable secret password to be configured and used simultaneously.


18. Refer to the exhibit. How many collision domains are depicted in the network?



1
2
4
6
7
8


19. Refer to the exhibit. Which hosts will receive a broadcast frame sent from Host A?



hosts A and B
hosts B and C
hosts D and E
hosts A, B, and C
hosts B, C, D, and E
hosts A, B, C, D, E, and F


20. If a network administrator enters these commands in global configuration mode on a switch, what will be the result?
Switch1(config-line)# line console 0
Switch1(config-line)# password cisco
Switch1(config-line)# login

to secure the console port with the password "cisco"
to deny access to the console port by specifying 0 lines are available
to gain access to line configuration mode by supplying the required password
to configure the privilege exec password that will be used for remote access


The Result is satisfactory. If you find any wrong answer please don't hesitate to comment or email me. Thanks for visiting the blog.







Hope it will help you in your learning.
Best of Luck and keep visiting the Blog.
Don't forget to click on Adsence!!


Friday, May 1, 2009

Forgot Windows XP Password

Windows Password


Hi all! I know this post is not relevant to CCNA but this is a common problem that came across so many times. Yes it is the forgot windows password problem. I have seen on many websites people are asking for it but most of the websites ....



More....


Wednesday, February 11, 2009

CCNA 3 Exploration - Chapter 1

E-Switching Chapter 1 - CCNA Exploration: LAN Switching and Wireless (Version 4.0)

Provided by : Malcolm

1 Link aggregation should be implemented at which layer of the hierarchical network?


Core only


Distribution and core


Access and distribution


Access, distribution, and core


2 Which two features are supported at all three levels of the Cisco three-layer hierarchical model? (Choose two.)


Power over Ethernet


Load balancing across redundant trunk links


Redundant components


Quality of Service


Link aggregation


3 Which hierarchical design model layer controls the flow of network traffic using policies and delineates broadcast domains by performing routing functions between virtual LANs (VLANs)?


Application


Access


Distribution


Network


Core


4 Which layer of the hierarchical design model provides a means of connecting devices to the network and controlling which devices are allowed to communicate on the network?


Application


Access


Distribution


Network


Core


5 A technician is attempting to explain Cisco StackWise technology to a client that is setting up three stackable switches.Which explanation accurately describes StackWise technology?


StackWise technology allows up to eight ports to be bound together to increase available bandwidth.


StackWise technology allows the switch to deliver power to end devices by using existing Ethernet cabling.


StackWise technology allows the switch capabilities and ports to be expanded by the addition of line cards.


StackWise technology allows up to nine switches to be interconnected via the use of a fully redundant backplane.


6 Configuring communication between devices on different VLANs requires the use of which layer of the OSI model?


Layer 1


Layer 3


Layer 4


Layer 5



7 Which three features are commonly supported at the distribution layer of the Cisco hierarchical network model? (Choose three.)


Security policies


Power over Ethernet


Switch port security


Quality of service


Layer 3 functionality


End user access to network


8




Refer to the exhibit. Beginning with HR servers and workstations, a network engineer is designing a new security structure for the network. Which set of policies adheres to the hierarchical network model design principles?


Implement Layer 3 switching on S1 to reduce the packet processing load on D1 and D2. Install all security processing on S1 to reduce network traffic load.


Configure port security options on S1. Use Layer 3 access control features on D1 and D2 to limit access to the HR servers to just the HR subnet.


Move all HR assets out of the data center and connect them to S1. Use Layer 3 security functions on S1 to deny all traffic into and out of S1.


Perform all port access and Layer 3 security functions on C1.


9 A network technician is asked to examine an existing switched network. Following this examination, the technician makes recommendations for adding new switches where needed and replacing existing equipment that hampers performance. The technician is given a budget and asked to proceed. Which two pieces of information would be helpful in determining necessary port density for new switches? (Choose two.)


Forwarding rate


Traffic flow analysis


Expected future growth


Number of required core connections


Number of hubs that are needed in the access layer to increase performance


10 Which layer of the hierarchical network design model is referred to as the high-speed backbone of the internetwork? Where high availability and redundancy are critical?


Access layer


Core layer


Data-link layer


Distribution layer


Network layer


Physical layer


11 What statement best describes a modular switch?


A slim-line chassis


Allows interconnection of switches on redundant backplane


Defined physical characteristics


Flexible characteristics



12 Which hierarchical design characteristic would be recommended at both the core and distribution layers to protect the network in the case of a route failure?


PoE


Redundancy


Aggregation


Access lists


13 Which two characteristics are associated with enterprise level switches? (Choose two.)


Low port density


High forwarding rate


High latency level


Support link aggregation


Predefined number of ports



14 Which feature supports higher throughput in switched networks by combining multiple switch ports?


Convergence


Redundant links


Link aggregation


Network diameter


15 At which hierarchical layer are switches normally not required to process all ports at wire speed?


Core layer


Distribution layer


Access layer


Entry layer


16 For organizations that are implementing a voice over IP solution, what functionality should be enabled at all three layers of the hierarchical network?


Power over Ethernet


Quality of service


Switch port security


Inter-VLAN routing


17 Which layer of the OSI model does an access layer LAN switch use to make a forwarding decision?


Layer 1


Layer 2


Layer 3


Layer 4


18 What is the likely impact of moving a conventional company architecture to a completely converged network?


Local analog phone service can be completely outsourced to cost-effective providers.


The Ethernet VLAN structure is less complex.


A shared infrastructure is created resulting in a single network to manage.


QoS issues are greatly reduced.


There is less bandwidth competition between voice and video streams.


19 A network administrator is selecting a switch that will operate at the network core. Which three features should the switch support for optimum network performance and reliability? (Choose three.)


Port security


Security policies


10 Gigabit Ethernet


Quality of service (QoS)


Hot-swappable hardware


Power over Ethernet (PoE)


20





Refer to the exhibit. What characteristic of hierarchical network designs is exhibited by having SW3 connected to both SW1 and Sw2?


Scalability


Security


Redundancy


Maintainability



The Result is satisfactory. If you find any wrong answer please don't hesitate to comment or email me. Thanks for visiting the blog.





Hope it will help you in your learning.
Best of Luck and keep visiting the Blog.
Don't forget to click on Adsence!!