Skip to main content

Featured Post

Changing Digit Grouping (Comma Style) in MS Excel - Million to Lakh

Well this is a very common problem for our sub-continent i.e. Bangladesh, India, Pakistan, Nepal, Maldives, Sri Lanka. Cause our digit grouping system doesn't match with the international system. To be more specific - they use million, billion etc. But we use - lakh (also lac), crore etc. 
Users of the mentioned regions often face problem with the comma separator position in MS Excel. Cause the default system is international. It doesn't suit our digit grouping system. 
International System - Separates every three digits 1,000.0010,000.00100,000.001,000,000.001,000,000,000.00
Subcontinental System - Separates every two digits after the 1st three digits
1,000.0010,000.00 1,00,000.001,00,00,000.001,00,00,00,000.00 
If you're familiar with the Indian Subcontinent system and if you're bound to use this system then it will be a big trouble if you don't know the solution. Well nothing to worry about as you are going through this article. Cause from the very next moment you'…

Marks PC Got a New CPU!

Finally I've got a new system unit! I purchased the CPU in April 02, 2014. I was very busy with transferring my files from old PC. So I didn't get enough time to write about my new CPU. In this post I'm gonna share my experience with you. And I also would like to give you some tips which you can follow before and after buying a new PC. 

In fact, I'm suffering with my old PC for more than a year. It shuts down without notice. And there is no definite pattern of shutting down. Actually the parts are 5.5 years old. So I didn't think about repairing. I've purchased a new system unit. 

I would like to start with my CPU configuration:

  • Processor: Intel Core i3-3220, 3.3 GHz (4 CPUs), 3MB Cache
  • System/Mainboard: GIGABYTE H61M-S2PV, LGA 1155 (Ultra Durable)
  • Memory: Team Elite 4GB DDR3 RAM with 1600 Bus Speed
  • Hard Drive: Samsung 1 TB HD 103SM
  • DVD Drive: HP DVD Writer 1265
  • Casing: San ATX Casing (E011B) with High Watt Power Supply

After assembling the CPU, the seller asked me to power on the system. I pushed the power button but it didn't run! Then he checked the connectors, power cords and everything. My father was there. He advised to check the power switch. 

Then the seller used reset switch to turn on the system. And it worked! What happened actually? There was a fault in the power button. After changing the internal connector of  the power button, it worked fine. 

Total Cost is approximately $ 340. 3-year warranty for Mainboard and CPU. Product lifetime warranty for RAM. Hard Disk and DVD writer get 1 year warranty. 

Here is my system rating

Windows 8 System Rating

Now I'd like to discuss what to do before and after buying a new PC. 

Before you Purchase - Think
  • What do you do using PC?
  • How much heavier your tasks are? Gaming, Graphics or Official Tasks? 
  • How much you know about configuration? Are you an expert or novice? 
  • Do you have a familiar PC shop which you can trust? How much expert they are?

Before buying a PC, you must think about these questions. You should also think about warranty. Because computer equipments could be damaged any time. Even best quality product can't guarantee that it wouldn't be damaged. But a good brand can ensure warranty service.  

You must think about your activities before purchasing a PC. What type of PC you should buy depends on your tasks. Heavier tasks like graphics, gaming requires a heavier system. But if you only browse Internet and work with Microsoft Office, then dual core PC with 2 GB RAM is enough for you. 

If you're expert about PC, then it's okay. But if you're just a beginner or don't have much idea about configuration, then you should talk to an expert. Or at least you can talk to a friend who has a good idea. 

Finally, choose a better outlet from where you will buy the computer. Never choose a shop which offers low price PC. I swear, you have to suffer with defective parts. Just tell the seller one thing - I need a quality CPU. Price doesn't matter. Because some sellers cut the price to match your budget. And often they give you poor quality parts to reduce the price. 

You must also ensure that you will get warranty for important equipments like Motherboard, Processor, RAM, Hard Disk etc. 

When you Purchase - Observe

When you're at the purchase point, you should observe the assembling procedure. Make sure that, the person assembling your CPU is an expert. Otherwise equipments could be damaged due to the wrong handling. 
  • Be sure that every equipment is new. Check the packet before opening an equipment. Make sure that the product is properly sealed in the packet with sticker. If the seal is broken, inform the seller and ask him to give you a new one. 
  • Check the installation of processor. Make sure that, CPU fan is properly installed.
  • There are usually 06 points in a motherboard. Make sure all of them are properly inserted into the casing.
  • Be sure that internal connectors are properly connected. 
  • Check the USB ports with a flash drive if possible and necessary.
  • Any loose connections may be the cause of danger. So be sure, there is no loose connections.
  • When the assembling is complete, turn on your system properly. And make sure everything is working perfectly. 

Before leaving the shop, don't forget to pack your equipments properly. Take the necessary documents - warranty papers, money receipt etc. Take the CD/ DVDs that come with the products. Ask the seller for any advice that can increase your computer life so that you shouldn't come back for warranty! 

After you Purchase - Ensure Proper Maintenance

A computer could be a machine. But it needs proper maintenance just like a human body. And you must take some precautionary measures to avoid any occurrence. Here are some tips for you: 
  • Place the system in a cool and dry place. 
  • Keep the surrounding area clean to keep the dust minimum.
  • Use Voltage Stabilizer and UPS to avoid any damage. 
  • Connect the cords using a good quality multiplug. 
  • Place the CPU in a way so that it doesn't touch any other object ie. walls, tables or any other electrical equipments.
  • Perform maintenance tasks at a regular interval.
  • Clean up your PC properly. Or take help of an expert.

Also read the following posts if necessary: 

Stay with Marks PC Solution to get more interesting IT topics!


Popular Posts

GTA San Andreas Cheat Code (PDF)

After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them. 
To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs. 

I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side. 

You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom. 

EffectCheat CodeAdrenaline ModeMUNASEFAll Cars ExplodeALLCARSGOBOOMAll Cars Have NitroCOXEFGU or SPEEDFREAKAll Green LightsZEII…

Office 2016 Activator (KMSPico 10.1.5)

It's been couple of months after the release of final version of Microsoft Office 2016. And maybe you're tired of finding for a working activator for this version. Today I'm gonna share Office 2016 activator with you - no more waiting!!

About the Activator Name: KMSPico 10.1.5File Size: 3 MB (Approx)File Type: Zipped Folder100% Neat & Clean - No virus!

Activating Capacity . . .
KMSPico 10.1.5 is successfully leading the KMS world for last few months. If everything is okay, success rate is 100%. This tool has been tested and verified by Marks PC Solution. With this tool, you can activate -  Office 2016, 2013 & 2010Windows 10, 8.1 & 8Hopefully this version will work for both 32 bit & 64 bit versions of Windows.

Installing Office 2016 Collect/ Download Office 2016 Professional Plus from Microsoft or somewhere else.Install it as trial version without any key.Use the following activator . . .

Download > Install > Enjoy . . . Get the file from here. The first link i…

Office 2010 Activator (KMS) !!

Day by day cracking has been a tough job. But yet very possible. Earlier a software may require only serial key to activate. But today there are many other options. Sometimes you might be asked to connect to the internet to activate or sometimes you're asked to make a phone call! 

Microsoft Office 2010 has the same problem. It is not simply activated by the CD key. Sometimes CD key may not be asked during the installation process. If you're required to enter serial then try any of the following:




After installing a trial version of Office 2010 you're allowed to use it for 30 days only. After that it will ruin your peace. It will give you continuous love messages each time you start office. Today I'm gonna share an activator by which you can activate Office 2010 and stop unwanted love messages by MS Of…

Office 2013 Activator (KMSpico 10.1.5)

KMSpico 9.1.3 is really an amazing tool for activating Office 2013. And as a bonus, you can also activate Windows 8 or 8.1 with this activator. Earlier I shared different activators for Office and Windows. And those activators are working fine. If you can't activate your Office or Windows by those activators, then you can try this one. 

I've got Microsoft Office Professional Plus 2013 (final version) last week. And before that I was using Office 2010. After installing Office 2013, I was unable to use it before activating. And with this KMSpico 9.1.3 my Office gets activated within minutes. It's very easy to use! 

Furthermore, this KMS is capable of activating -  Windows 8 and 8.1 (All Versions) Windows Vista and 7 (Business, Professional & Enterprise Edition)Office 2010 and 2013Windows Server 2008/2008R2Windows Server 2012/2012R2

Activation Procedure: Download the KMSpico 10.1.5 from Here.Now double click on it. And follow the manual include inside.Press Next > Accept ter…

Download GTA Vice City Cheat Codes (PDF)

Couple of years ago, GTA Vice City was one of the most popular game. GTA games are always preferred by the gamers. Most of the GTA games like Vicy City, Liberty City, San Andreas have cheat codes. With these cheat codes, you can complete missions easily. When something is very difficult to perform normally, you can use cheats. 

Here I'm gonna share 32 selected cheats with you. I've omitted the unnecessary cheats. And these cheats are also applicable for GTA Liberty City!

Press any of the below cheats while playing the game. The right part of the table contains the cheats and the left part contains the results. 

Cheat Code All Cars are FasterGet There FastArmorPrecious ProtectionBetter Driving SkillGrip is EverythingCaddyBetter Than WalkingCars Float on WaterSea WaysCars FlyAirshipCars FlyingCome Fly With MeClear Wanted LevelLeave Me AloneCommit SuicideI cant take it any moreDestroy All CarsBig BangFast CarGet There QuicklyFaster Game ClockLife is passing me byFaster Game Pla…

IDM 7.2 Portable Free Download!!

There is nothing new to tell about Internet Download Manager (IDM). Most of you are familiar with this amazing download accelerator. But still people look for the cracked version of IDM. Version changes over time. And people try to get the new activated version. Today I'm gonna share IDM 7.2 (Portable) with you! 

Before I begin, I should declare that this is not a registered version of IDM actually. But the settings of this IDM are modified. You don't need to upgrade or register this version. After 30 days, you will not get the notifications to upgrade. And you will enjoy all the advantages just like a registered version. 
But there is nothing to worry about. You can download this portable version of IDM without hesitation. It's just 4.7 MB. You don't need to install it. This version will never demand serial from you. And the download link is 100% free from ads, spams or malware.

Downlaod IDM 7.2 Portable either from Link 1 or Link 2. Unzip the folder and move it to your …

Rules for Bengali Typing in PDF (Bijoy Layout)

Bijoy is the most popular layout for Bangla typing. The layout was developed by Mostafa Jabbar. He is the pioneer of Bangla typing in computer. More than 90% people use his Bijoy layout for Bangla typing.

Today, I'm gonna share a PDF file with you that contains the Bijoy Keyboard layout with English fonts! If your keyboard doesn't have bengali fonts then you can print this PDF file to know where the bengali fonts are located in your keyboard. Additionally this file contains all the necessary rules and tips which are essential for Bangla Typing. 

Now there are many other software available for Bangla Typing Layout. Such as Avro Easy, Unicode, Unibijoy etc. And there rules are also somewhat different from Bijoy. And some of their layouts follow the same rules like Bijoy. Hopefully this PDF file will support most of the rules when a layout is similar to Bijoy Layout. 

Download the PDF file from the button below. Follow my instructions properly. And I can guarantee you will be able t…

How to Disable Word Verification (Captcha) in Blogger Comment

By default blogger blogs are designed to show word verification when visitors comment in a post. Though this is a very useful tool to avoid spam, but real users often get bored by this option. Besides blogger has an automatic spam checking tool. So you can remove the word verification option from the comment in order to let your visitors express their opinion easily. 
While commenting on blogger blogs or other websites you may face a word challenge. And this is a very common thing. Specially when you open any online account. Sometimes words used in the verification option are too hard to guess. And users are very annoyed with this. 

Look at the image above. When you comment on blogger blogs or someone comments on your blog he/she will face a challenge like this. Normally this option doesn't show any hard challenge. But sometimes they are also difficult to guess. Users have to try this again and again. If they are annoyed they will loose interest to express their opinion. 

Since blogg…

How to Check Cell Phones Quality Using IMEI - *#06#

Most probably, mobile phone is the most used device by the people throughout the whole world. Couple of years ago the use of mobile phone was very limited. But today many users have more than one or two mobile phones.
And to meet the demand, manufacturers are producing their products in different places to reduce the cost. Sometimes mobile phones are produced in China, India or any other country where production cost is relatively low. And quality is also hampered for this reason.
So, in this post I am gonna show you, how do you check your mobile phone's quality using the IMEI number
IMEI stands for International Mobile Equipment Identity. It is a 15-digit number and may be found in the packet of the mobile phone. It may also be found by removing the back cover and it may be placed on the battery sticker. 
If you lose your IME number then you can find it by typing *#06# on your mobile screen. After pressing this code, you will see a 15-digit number immediately on the screen which is…