Checkbox in excel is a very handy tool for creating the checklist or simple user forms. There is no need of any Excel VBA knowledge to insert Checkbox into a excel sheet. This is increase the speed at which user enters data as well as it reduces the chances of misspellings which will give trouble in formulas or pivot tables. So lets start learning how to insert Checkbox in Excel.
Step to Add Check box to Excel Sheet
1. To use Checkbox, you need add it to your ribbon, if it is not already available. To Do this, Go to File->Excel Options->Select Show Developer tab in the Ribbon option if you are using excel 2007. If you are using Excel 201o, then go to File->Options->Customize Ribbon. In the list of main tabs select the Developer check box. Choose Ok to close the Options Dialog Box. This works work well for Excel 2o13 on enabling the developer tab in ribbon.
2. Once Developer Tab is enabled, go to Developer->Selects Chekbox under form controls.
3. Now you can place the Check box where ever you want in your excel sheet.
4. Once you placed the Check-box, left click on your mouse and choose Format Control option.
Format Check Box
5. Go to Control Tab. Here you can choose the default value of the check box whether it is Unchecked or Checked or Mixed. If it is checked the output will true and if it is unchecked the output will be False.
6. The Cell Link refers to the cell on which you want the output to displayed(True or False).
There are many new smartphones launching everyday. Choosing the good phone is everyone wants. Latest Android version, decent CPU, good amount of RAM and internal storage, support for the expandable storage and post sale support are key factors needs to considered when we buy a phone or a smartphone. So, lets start listing the phones running on Android Kitkat OS.
Cheap Android Smartphones running on Android Kitkat 4.4
I am considering the smartphones price which is less than Rs.7000 as cheap phones. So let’s begin.
1. Motorola Moto E
Motorola Moto E stays top of this list. I am considering this phone as best of the lot because of the brand name and specifications as well as feature Android updates. Motorola already confirmed that, Moto E will be getting the major update Android L Update. The device is powered by dual-core 1.2GHz processor with 1GB RAM and comes with internal storage of 4GB; it also supports microSD cards up to 32GB. For taking snaps and recording videos, Moto E comes with 5MP camera. Connectivity features includes 2G, 3G, Wi-Fi, Bluetooth 4.0, GPS, microUSB 2.0, USB tethering and WiFi hotspot. The device houses decent 1,980mAh battery and is available in two colours – black and white. The cons of this device includes low quality charger and no front facing camera. You more on this in Moto E Review. Motorola Moto E price in India is Rs.6999.
2. Micromax Unite 2
Micromax Unite 2 sports 4.7 inch screen with 800*400p resolution and powered by 1.3GHz quad-core Mediatek processor with 1GB RAM. The internal storage of the device is 4GB and supports expandable storage upto 32GB through microSD card. The budget micromax dual sim Android kitkat smartphone has 5MP main camera with LED flash and 2MP front camera. For connectivity, it provides 2G, 3G, Wi-Fi, Bluetooth 4.0, GPS,microUSB 2.0, USB tethering and WiFi Hotspot. Micromax Unite 2 price in India is Rs.7000. You can read more on this here.
3. Micromax Canvas Engage
Canvas Engage is the cheapest Android Kitkat dual sim from Micromax . The device is powered by quad-core 1.2GHz processor with 512MB RAM and features 4GB internal storage and supports microSD cards up to 32GB. It has 4inch screen with WVGA screen resolution of 800x480p. The phone comes with 5MP rear camera with LED flash and VGA front facing camera. The connectivity features includes 2G, 3G, Wi-Fi, Bluetooth, GPS, microUSB, USB tethering and WiFi Hotspot. It has a 1,500mAh battery. Micromax Canvas Engage price in India is Rs 5,700.
4. Karbonn Smart A11 Star
Karbonn Canvas Engage sports 4.3 inch display screen with 800x480p resolution. It is powered by dual-core 1.2GHz Mediatek processor with 512MB RAM and comes with 4GB internal storage and 32GB microSD support. There is 5MP rear camera with LED flash and a VGA front facing camera. It has all the basic connectivity features like 2G, 3G, Wi-Fi, Bluetooth and microUSB. Karbonn Smart A11 Star price in India is Rs.4,499.
5. Celkon A35K Campus
This is the cheapest Android Dual sim smartphone running on Kitkat 4.4 listed in this. The smartphone has 3.5 inch capacitive touchscreen with 320×480 pixels. This Celkon A35K Campus runs on 1GHz processor and has 256 MB RAM. It has 512MB internal storage and supports microSDs card of capacities up to 32GB. The Dual sim Celkon A35K Campus has 3.2MP main camera with LED flash and a VGA front facing camera. Connectivity features includes 2G, 3G, and Wi-Fi, while Bluetooth and microUSB can be used to transfer data. The device houses 1400 mAh battery. Celkon A35K campus price in India is Rs.2999.
Comparison Summary
Below is the specification summary table which might be useful for you.
The Motorola Moto E did a massive change in the perception of entry level Android smartphone. Providing a decent hardware and latest Android version for a entry level dual sim phone trend started with Moto E. The local mobile manufacturers such as Lava, Micromax etc started to provide such smartphone for very attractive price. One such attempt is Micromax Unite 2 A106. The Micromax Unite 2 A106 price in India is Rs. 6999.
Micromax Unite 2 runs on latest Android 4.4.2 Kitkat OS with 21 Indian languages support. The device is powered by 1.3GHz Mediatek MT6582 quad core processor with 1GB of RAM and Mali 400MP2 graphic unit. Internal storage of the device is 4GB in which only 890MB is user available memory. There is a support for microSD card for additional external storage.
Micormax Unite 2
Micromax Unite 2 comes with 5MP rear camera with flash which can record 720p videos and 2MP front facing camera for video calling. The device comes with 4.7 inch TFT capacitive touchscreen with WVGA screen resolution of 800×480 which results in low pixel density of 199 ppi. The sunlight visibility and viewing angle are not upto the standards of Moto E. Micromax Unite 2 houses 2000mAh battery which is rated to provide 8 hours of talktime and 190 hours of standby time.
Advantages and Disadvantages of Micromax Unite 2
Pros of Micromax Unite 2
Very attractive price tag
Latest Android Kitkat OS
Dual sim with Dual standby
Support for microSD card
Cons of Micromax Unit 2
Very low 199ppi pixel density
Only 890MB is user available memory.
Lot of pre installed micromax bloatware
Micromax Unite 2 Tips
Taking screenshot on Micromax Unite 2
To take screenshot on Micromax Unite 2, press and hold Volume down key and power button simultaneously. The screenshot will be saved in Gallery->Screenshots
Using Micromax Unite 2 as modem
You can use Micromax Unite 2 as modem through USB tethering and WiFi hotspot feature. I have written a detailed post which you can refer here Micromax smartphone tethering.
Micromax Unite 2 Specifications
Android v4.4.2 (KitKat) OS
4.7-inch LCD Touchscreen with FWVGA screen resolution and 199 ppi pixel density.
Motorola Moto E is one of the best budget Dual sim Android smartphone available right now. Latest Android OS, Dual core processor, 1GB RAM, 5MP camera, good build quality and importantly it supports most of the connectivity features such as 2G, 3G, WiFi, Bluetooth, USB tethering and WiFi Hotspot. In this tutorial, we will see how to use Motorola Moto E as modem through WiFi Hotspot. I will be writing a new post on How to use Moto E as modem through USB tethering.
How to Use Motorola Moto E as modem to connect to PC or WiFi enabled devices
Before, starting to use Moto E WiFi hotspot feature, we should have a active data plan. As soon as you enable WiFi hotspot, the WiFi of the device will be turned off. Also, do remember that, WiFi consumes lot of battery. Hence use this wisely to save battery as well as the data usage charges. Lets start with using Moto E as Modem through WiFi hotspot.
Enable Moto E WiFi Hotspot
First enable the data on your device.
Go to Settings->Wireless & networks and tap on to “More….“
Tap Tethering & mobile hotspot .
Tap the Mobile Wi-Fi hotspot to turn On.
You can customize the Hotspot name and password by tapping Set up Wi-Fi Hotspot.
Enter a hotspot name or SSID which you want.
Customize the SSID and password
Enter a password or use the default. The password is the key other people need to enter on their device so they can connect and use Moto E as a wireless router.
To help make your Wi-Fi hotspot more secure, use the default security type.
Tap on to Save.
You are done. Now you can use your Motorola Moto E as Wireless modem. Please let me know if you are facing any issues through writing it on the comment section below.
Video Guide on How to Use Motorola Moto E as WiFi Hotspot
HTC One M8 has got a huge applause for its beautiful design and build quality. It is not just beutiful, it is powerful too. HTC One M8 is powered by 2.5 GHz Qualcomm Snapdragon 801 Quad Core Processor with 2GB of RAM and Adreno 330 GPU. The device sports 5 inch Super LCD 3 Capacitive touchscreen with full HD resolution and 441 ppi pixel density. In this HTC One tutorial we will learn how to use HTC One as WiFi Hotspot.
HTC One M8
How to Use HTC One as Modem through WiFi Hotspot
To use HTC One as modem through WiFi Hotspot, please follow the steps mentioned below.
Go to Settings, and then under Wireless & networks, tap More.
Tap Mobile network sharing.
Tap the Portable Wi-Fi hotspot On/Off switch to turn it on.
The first time you turn on the Wi-Fi hotspot, you can customize the Hotspot name and password .
Enter a hotspot name or use the default.
Enter a password or use the default.
The password is the key other people need to enter on their device so they can connect and use HTC One as a wireless router.
To help make your Wi-Fi hotspot more secure, tap Advanced settings.
Choose settings such as SSID and the security type, and then press .
Tap Next and then tap Done.
Now you can use you HTC One as Modem through WiFi Hotspot.
Note:
Here is the few things you need to keep in mind while you are using HTC One M8 as modem via WiFi Hotspot.
Make sure the data connection is turned on.
You must have an approved data plan associated with your account from your mobile service provider to use this service. Devices connected to your Wi-Fi hotspot use data from your subscribed data plan.
Using WiFi hotspot consumes more battery. Hence, when not in use, disable the WiFi Hotspot feature.
