Tech2 Touch

Author: Aniruddh

  • Lenovo A6000 Cons and Pros Review

    Lenovo A6000 is a budget Dual sim Android smartphone with support for 4G connectivity. The device is available exclusively on flipkart through flash sales. The price of Lenovo A6000 in India is Rs.6999.

    Lenovo A6000 is powered by 1.2GHz quad core 64 bit Qualcomm Snapdragon processor with 1GB of RAM and Adreno 306 GPU. Internal storage of the device is 8GB in which 4.19GB is user available. The device also supports expandable storage upto 32GB. You can even install most of the apps to microSD card as default storage location.

    Lenovo A6000 4G LTE Dual sim

    Lenovo A6000 sports 5 inch IPS screen with screen resolution of 1280×720 pixel(720p HD) and 294 ppi pixel density. The viewing angles and colors reproduction are great. The texts and video looks crisp. The sunlight legibility also good. Overall it is very good display panel in this price range.

    Lenovo A6000 houses 8MP primary camera with LED flash and 2MP front facing camera. Both camera can record videos at 720HD resolution. The connectivity features of the device includes 3G, 4G(LTE Cat 4 speeds of up to 150Mbps download and up to 50Mbps upload.), Bluetooth, WiFi, USB tethering and WiFi Hotspot.  The device has 2300 mAh battery.

    Read: How to take screenshot on Lenovo A6000

    How to download PC suite for Lenovo A6000 and Lenovo A6000 Plus

     Advantages and Disadvantages of Lenovo A6000

    Pros of Lenovo A6000

    • Great Display panel: The 5 inch 720p HD screen provides excellent viewing angles and sunlight legibility.  The colors look great. It is one of the best display screen within the price of 10k.
    • Good battery life: With heavy usage, it lasts almost a day. However with causal usage it last close to 2 days. Standby mode consumes very minimum power.
    • Excellent performance: The quad core 64 bit processor with 1GB of RAM and Adreno 306 GPU coupled with minimalistic UI provides lag free experience.
    • Good sound output: The dual speaker with Dolby features produces excellent sound quality. The output through 3.5mm headphone jack too good.
    • Good build quality: Though it is 5 inch smartphone, it feels very comfortable to hold in hand as well as keeping it in pocket.
    • Decent cellular call quality: The call quality on this device is good.
    • Good value to price:  It is overall good value for money device.

    Cons of Lenovo A6000

    • No OTG support: Lenovo A6000 does not supports OTG.
    • Lack of sensors: Lenovo compromised on the sensors like Gyroscope, compass etc. The device comes with only light, proximity and accelerometer sensors.
    • Max video record resolution is 720p: Max resolution at which video can be recorded on this device is 720p. There is no 1080p video recording available on this device.
    • No LED notification light.
    • The capacitive touch buttons are not back illuminated.
    • No screen protection: The display screen does not features any protective glass such as Corning Gorilla glass. The display screen is finger print magnet.

    Lenovo A6000 Specification Summary

    • 1.2GHz quad core 64 bit Qualcomm Snapdragon processor with 1GB of RAM and Adreno 306 GPU.
    • 5 inch IPS screen with screen resolution of 1280×720 pixel(720p HD) and 294 ppi pixel density.
    • 8GB internal storage in which 4.19GB is user available.
    • microSD support upto 32GB.
    • 8MP primary camera with LED flash.
    • 2MP front facing camera.
    • 2300 mAh battery.

  • How to take screenshot on Lenovo A6000

    Lenovo A6000 is a budget Dual sim Android smartphone with 4G capability. The device runs on Android 4.4 Kitkat out of the box with Vibe UI. Taking screenshot on Lenovo A6000 is very easy. There are two methods through which you can take screenshot. Here are the two methods to take screenshot on Lenovo A6000 4G Android smartphone.

    Useful Tips and Tricks Posts on Lenovo A6000 and A6000 Plus:

    How to use Lenovo A6000 as Modem: How to guide on using features like perforsonal wifi hotspot and USB tethering.

    How to download Lenovo A6000 PC suite: Tips to download and install USB driver and PC suite

    How to take screenshot on Lenovo A6000

    As mentioned before, there are methods. First one is the default Android method and another one is Lenovo Vibe UI exclusive method.

    Android Default method of taking screenshot on Lenovo A6000.

    Like any other Android smartphone, you need to press and hold Volume down and power button simultaneously to take screenshot.

    Vibe UI way of taking screenshot on Lenovo A6000

    • First go to the screen on which you want to take the screenshot.
    • Next go to quick notification area settings by swiping the screen from top to down using two finger.

    Print screen on Lenovo A6000

    • The quick settings has the screenshot icon.
    • Tap on to it to take the screenshot.

    Where the taken screenshot gets saved?

    The taken screenshot on Lenovo A6000 will be saved on Gallery folder.

    Video on How to take screenshot on Lenovo A6000

  • Find matching value in a row and return column name in Excel

    When we work in excel sheets, we are required to find a matching value in a row and return the Column name. For example, we need to calculate the lowest priced store from the price table of multiple stores for multiple products. Another example can be found at the primary reason for exits from the exit feedback form analysis. In these cases, even multi-condition vlookup doesn’t help. We will take the first example and find out how to solve this using the Excel formulas.

    Recommended Reading:

    Conditional VLOOKUP with MATCH In EXCEL
    Example:

    Excel Lookup

    In the above table we have to return the company name which has lowest price for that product. For this we need to find the column which has the lowest price. So we need to use min(Range) excel worksheet formula. This will give us which is the lowest value. Now we need to find the relative position of the value. For this, match worksheet formula is useful. Now have to get the column name of that position. For this we need to use index function. The final formula will become like below.

    =INDEX($B$1:$E$1,MATCH(MIN(B2:E2),B2:E2,0)) which returns Company A.

    How it works?

    MIN(B2:E2) returns 16999.
    MATCH(MIN(B2:E2),B2:E2,0) returns 1
    INDEX($B$1:$E$1,MATCH(MIN(B2:E2),B2:E2,0)) returns Company A as column 1 in range B1 to E1 is B1.

    Note: The column range for index and match should be the same. Only the row numbers can be different. As match function returns relative position data, the column range should be same for Index function also.

    You can tweak this function according to your requirements. You might required to find the column name when you know the exact value in the row. In that case, you need to replace min function with required value.

  • Asus EeeBook X205T Frequently Asked Questions

    Asus EeeBook X205T is newly launched compact travel friendly device. I have already written a detailed review on this. You can read it in my post  pros and cons of Asus EeeBook 205. In this post I am giving you some of the useful information which is directly answered  by the ASUS product support team. Let us start the questions and answers on Asus EeeBook X205T.

    Asus X205T

    Asus EeeBook X205T Frequently Asked Questions

    Question: Is this device supports USB booting? If yes, how to enable USB booting?
    Answer: In USB Storage, there has to be a UEFI applicable OS or UEFI Shell , and Security Boot in BIOS SETUP has to switch to disabled.
    Question: How to reinstall the Windows 8.1 in Asus EeeBook X205T in case of OS gets corrupted because of Virus or some disc failure?
    Answer: When turn on the computer, Press F9 to enter recovery OS mode or start OS recovery in Windows.
    Question: Is Asus EeeBook X205T  compatible with Ubuntu Linux?
    Not Guaranteed.
    Question: How to install applications directly in to microSD card in Asus EeeBook X205T?
    Answer: When installed, if the .exe program ask you to choose the designated installing address and you can choose the address in Micro SD card. If not, than it has to be installed in build-in eMMC.

    Just to recap, Asus Eeebook X205T sports 11.6 inch screen with resolution of 1366 x 768 Pixels  and powered by 1.33 GHz with Turbo Boost Upto 1.83 GHz 4th Gen Atom Quad Core with 2GB of RAM. It has 32GB internal storage and supports microSD card upto 128GB. The Eeebook 205 runs on Windows 8.1. For connectivity it has Bluetooth, WiFi, 2 USB ports and micro HDMI port.

    Update: My Asus EeeBook X205 got updated to Windows 10 home edition. I have been using this from past 10 days and I have not faced any issues. All the features are working good. The performance is better than before. I will share a dedicated post on how to update Asus EeeBook X205T to Windows 10 in my next post.

  • Samsung Galaxy A5 Cons and Pros- Review

    Samsung Galaxy A5 and A5 dual are the premium smartphones which comes with metal finish. With decent performance and great camera performance are the key features of the device. The Samsung Galaxy A5 price in India is Rs. 26,500 for the dual sim variant.

    Samsung Galaxy A5 is powered by Quad core 1.2GHz Cortex A53 CPU based on Qualcomm MSM8916 Snapdragon 410 chipset with 2GB of RAM and Adreno 306 GPU. The device runs on Android 4.4.4 Kitkat along with customised Touchwiz UI.

    Dual sim Samsung Galaxy A5

    Samsung Galaxy A5 sports 5 inch Super AMOLED capacitive touch screen with screen resolution of 720×1280 pixels which results in 294 pixel density. The viewing angles are great on the display. The internal storage of the device is 16GB and supports microSD card upto 64GB.

    Samsung Galaxy A5 houses 13MP primary camera and 5MP front facing camera. Both the camera are capable of recording 1080p video. The camera performance great in good lighting conditions. The connectivity features of the device includes 2G, 3G, WiFi, Bluetooth, USB, USB tethering and WiFi hotspot. Sadly, Galaxy A5 doesn’t supports USB OTG.

    Samsung Galaxy A5 is has non removable Li-ion 2300 mAh battery which is rated to provide 15 hours of talk time and 68 hours of standby time. In real time, with normal usage, it lasts single day. The dimension of this Android dual sim phone are 139.3×69.7×6.7mm and weighs 123 grams. Now we will see some of the pros and cons of Samsung Galaxy A5.

    Advantages and Disadvantages of Samsung Galaxy A5

    Pros of Galaxy A5

    • The premium metal build quality
    • Super AMOLED screen and Great viewing angles
    • Good cellular call quality
    • 16GB of internal storage and support for microSD card
    • Decent performance.
    • Great primary and front facing Camera performance.

    Cons of Galaxy A5

    • No physical LED notification
    • No user replaceable battery
    • Average speaker volume
    • No USB OTG support
    • No optical image stabilization
    • You cannot use 2 sim with microSD cards: If you insert 2nd sim card on a dual sim variant, you can use microSD card or vice versa.
    • Too pricey: For the premium metal finish, the price of the device is too steep. The same specification device are available for much cheaper price of other brands.

    Samsung Galaxy A5 Tips and Tricks

    Galaxy A5 as modem: You can use Galaxy A5 as modem using the USB tethering and WiFi hotspot features. you can read detailed post on this in my post on How to use Samsung Galaxy smartphone as modem.

    Take screenshot on Galaxy A5: To take screenshot on Galaxy A5, you press and hold volume down key and home key simultaneously. The screenshot will be saved in the Gallery. You can read detailed methods of taking screenshot in my previous post how to take screenshot on Samsung Galaxy smartphones.

    Samsung Galaxy A5 Specifications

    • 5 inch Super AMOLED capacitive touch screen with 720p resolution
    • 13MP primary camera and 5MP front facing camera
    • 2G, 3G, WiFi, Bluetooth, USB, USB tethering and WiFi hotspot
    • Quad core 1.2GHz Cortex A53 CPU based on Qualcomm MSM8916 Snapdragon 410 chipset with 2GB of RAM and Adreno 306 GPU
    • non removable Li-ion 2300 mAh battery
    • 16GB internal storage and microSD card support upto 64GB.