Tech2 Touch

Author: Aniruddh

  • Asus Zenfone C Cons and Pros Review

    The budget Dual sim Android market is becoming crowded. Even Asus launched smartphones under Zenfone series for the budget conscious market. Asus Zenfone C is one of them which got released recently. Does this worth buying? When we have so many options such as Xiaomi Redme 1S, Lenovo A6000, Moto E etc, where it stands? Let us have a look into it. Asus Zenfone C price in India is Rs.5,999.

    Asus Zenfone Dual sim

    Read: How to download Asus PC suite for Zenfones

    Asus Zenfone C is powered by 1.2GHz dual core Intel Atom Z2520 which is based on Intel’s previous generation Cloverview platform.  This is the same processor we have seen in the Zenfone 4.  It has 1GB of RAM and 8GB of internal storage. There is a provision for adding microSD card upto 64GB.

    Read: How to take screenshot on Asus Zenfone 

    Asus Zenfone C sports 4.5 inch screen with FWVGA 854×480 pixel resolution which results in 217 ppi pixel density. This display panel is not very good in the budget. Low screen resolution coupled with poor viewing angles, dull colours and harsh reflection puts this behind other same priced smartphones Moto E or Redme 1S.

    Asus Zenfone C comes with 5MP primary camera with LED flash. It record videos in HD resolution. But the video clarity is once again, below average. Photos taken are grainy and just dull. There is a also a VGA front facing camera. The connectivity features include 2G,3G, Wi-Fi b/g/n, Bluetooth 4.0. The device has 2100 mAh battery. Asus  bundled a app called Smart Saving which offers three modes namely Ultra-saving, Optimized, Customized mode.

    Advantages and Disadvantages of Asus Zenfone C

    Pros of Zenfone C

    • Reasonable performance: When it comes to performance in terms of casual games and day to day, it does decent job.
    • Good Build Quality: Overall, it comes with good build quality.
    • ZenUI: The customised ZenUI and Android 4.4 Kitkat provides good user experience.

    Cons of Zenfone C

    • Below average camera: Both primary camera and front facing camera are not impressive.
    • Poor Display panel: With poor viewing angles,Low screen resolution and  heavy reflections especially in outdoors, this is at par with competitors.
    • Average Battery: Even with Ultra saving mode, battery drains faster.

    Asus Zenfone C Specification

    • 1.2GHz dual core Intel Atom Z2520
    • 1GB of RAM and 8GB of internal storage
    • 4.5 inch display with FWVGA 854×480 pixel resolution
    • 5MP primary camera and VGA front facing camera
    • 2G,3G, Wi-Fi b/g/n, Bluetooth 4.0
    • 2100 mAh battery

  • How to use Lenovo A6000 as Modem

    Lenovo A6000 is one the most affordable 4G Dual sim Android smartphone in India. The good internal hardware coupled with decent build quality and competetive price is the key attraction of this smartphone. In this tutorial, we will see, how to use Lenovo A6000 as modem through WiFi hotspot and USB tethering.

    Read:

    Take screenshot on Lenovo A6000

    Lenovo A6000 Review

    How to download Lenovo A6000 PC Suite

    How to use Lenovo A6000 as WiFi Hotspot

    As I mentioned earlier, Lenovo A6000 supports 4G speeds. So even if you are outside, you can get the broadband speed on your smartphone. It is worth to use Lenovo A6000 as WiFi hotspot to connect to internet from your laptop or PC. Do remember that, using WiFi hotspot will incur charges as per your data plan also it will drain your device battery faster. Let us have a look into how to use Lenovo A6000 as WiFi hotspot.

    1. Enable the mobile data.
    2. Now go to settings->More…
    3. Tap on to Tethering & hotspot.
    4. Now enable the WLAN hotspot moving the slider to right.
    5. It will enable your Lenovo A6000 as WiFi hotspot.

    How to customise Lenovo A6000 WiFi hotspot Settings.

    If you want to customise the settings such as SSID, password and security type, follow the step given below. Even if you wanto see the Lenovo A6000 hotspot password or just want to change or reset Wi-Fi hotspot password of Lenovo A6000 and A6000 Plus, follow the step given below.

    • Tap on to WLAN hotspot
    • Now go to Set up WLAN hotspot.
    • You enter or edit the SSID, password and security type in this page.
    • Once you are done, tap Save.

    How to use Lenovo A6000 as modem through USB tethering

    1. Follow the same steps mentioned above till the step 3.
    2. Now connect your device to PC or laptop using the USB cable.
    3. Now enable the USB tethering.
    4. Now mobile data will be shared to your PC.

    Video Guide on How to use Lenovo A6000 as WiFi Hotspot

     

  • 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.