Author: Aniruddh

  • 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.
  • Asus IndiBlogger Meet 2015- First Blogger Meet of the year

    Jan 30, 2015 is one of the precious day of my blogging career. This was the first bloggers meet I ever attended till now. It was Indiblogger Meet powered by Asus.  This also the first bloggers meet of this year from IndiBlogger.

    Asus Indiblogger Meet 2015

    As I mentioned earlier, as it was my first blogger meet, I was not having any idea how the event will be. The meet started 30 minutes later than the scheduled time. It started with music concert and some activity to meet the other bloggers. It was well planned and well managed event.

    As mentioned this event is powered by Asus. The product manager of Asus, described the features of the newly launched EeeBook 205 and Asus All in one PC ET2040. Asus EeeBook 205 I already own it and made a review on it. You can read on that in my post Asus EeeBook 205 Review. I got a fair hands on experience on Asus All in one PC ET2040. Thanks to David, product manager Asus. He answered all my queries regarding the EeeBook as well as the Asus All in One PC.

    Then there was a group activity. The activity included showcasing a theme on stage with a group which promotes the blogging. Each team was provided with different themes. It was a good activity as it helped make more contacts with other bloggers.

    Overall it was a great event for me. I never expected a such a well managed event. I got an opportunity to meet many bloggers and share the ideas with them. Many of them provided very valued suggestions. On the lighter note, I was little disappointed for not getting a IndiBlogger T-shirt.