Author: Aniruddh

  • Huawei Honor 4C Cons and Pros Review

    Huawei Honor 4C is a dual sim 3G smartphone within the price tag of 10k. The main attraction of this smartphone is its primary camera. Let us see the Honor 4C review to understand whether it is worth buying or not.

    Recommended Reading:

    How to download Huawei Honor 4C PC Suite

    Huawei Honor 4C is powered by 64-bit 1.2 GHz Octa-Core HiSilicon Kirin 620 processor with 2GB RAM and Mali 450 GPU. The device has 8GB of internal storage capacity, in that 4GB is available for user. There is also provision for adding microSD card upto 32GB.  Phone performance is decent but has issues such as crashing of apps. Honor 4C runs on Android 4.4.2 Kitkat with Emotion UI.

    Huawei Honor 4C features 5 inch TFT IPS display with screen resolution of 720×1280 pixels and pixel density of 294 ppi. The sun light legibility and viewing angles are just average. In terms of call quality, Honor 4C does a decent job. However, watching youtube videos using the headphone, the audio quality is not good.

    Honor 4C Review

    Huawei Honor 4C comes with 13MP A/F primary camera with LED flash and 5MP front facing camera. The phone has lot of customisation options in camera settings. Even with default settings, this dual sim smartphone takes a good images and videos in this price. Some of the customisation option available on Honor 4C are Panorama, HDC, All Focus (lets you change focus point of a picture after you have taken it) etc.

    Huawei Honor 4C houses 2,550mAh battery. The battery performance is below average. It drains fast and also gets heated up while charging. The connectivity features of the device are Bluetooth 4.0, A-GPS, Wi-Fi , 3G, USB tethering and WiFi hotspot. Unfortunately there is no 4G support. It surprising considering the phones which are priced much lesser than this such as Lenovo A6000, Moto E 4G has 4G support.

    Advantages and Disadvantages of  Huawei Honor 4C

    Pros Honor 4C

    • Good camera performance.
    • Competitive pricing.
    • Decent build quality.
    • Good selfie camera.

    Cons of Honor 4C

    • No Android Lollipop out of the box.
    • Battery drains faster.
    • No headphone in the box.
    • No 4G connectivity
    • Only 4GB user available internal storage.

    Huawei Honor 4C Specification

    • Dual-SIM.
    • 5-inch 720p HD TFT IPS display.
    • 64-bit 1.2GHz octa-core HiSilicon Kirin 620 processor.
    • 2GB of RAM and 8GB internal memory.
    • Expandable storage up to 32GB via microSD card.
    • 13MP A/F rear camera with Flash, 5MP front camera.
    • Android 4.4 KitKat with Emotion UI 3.0.
    • 2,550mAh battery.
    • Bluetooth 4.0, A-GPS, Wi-Fi, 3G.
  • How to Round a Number to Closest ten in Excel

    Rounding a number in Excel is very easy. There are situation wherein we need to round a number to closest 10 or 100. For example, if we have a number 115 then 120, if we have 112 then 110. For this there is a dedicated function in Excel called MROUND which comes useful for such scenario. Let us learn more about the function MROUND in Excel.

    Syntax of Excel MROUND function

    MROUND(number, multiple)

    Where,

    • Number Required. The value to round.
    • Multiple Required. The multiple to which you want to round number.

    Note: MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple.

    Example:

    Below are the few useful examples of MROUND in Excel.

    1. Rounding a number to multiples of 10

    =MROUND(112, 10) Rounds 112 to the nearest multiple of 10 which will return 110

    =MROUND(116, 10) Rounds 116 to the nearest multiple of 10 which will return 120

    2. Rounding a number to multiples of 5

    =MROUND(112, 5) Rounds 112 to the nearest multiple of 5 which will return 110.

    =MROUND(116, 5) Rounds 116 to the nearest multiple of 5 which will return 115.

    =MROUND(118, 5) Rounds 118 to the nearest multiple of 5 which will return 120.

    There are other two Excel function which are very similar to this function but with slight change on the functionality.

    1. CEILING(number,significance)

    This will Returns number rounded up, away from zero, to the nearest multiple of significance. For example

    CEILING(112,5) will return 115

    CEILING(112,10) will return 120

    CEILING(115,5) will return 120.

    2.FLOOR(number,significance)

    This will Rounds number down, toward zero, to the nearest multiple of significance.  For example,

    FLOOR(112,5) will return 110

    CEILING(115,10) will return 110.

    So in summary, MROUND Excel function is useful when we need to round number up or down to the nearest multiple. Whereas if you want roundup decimals then ROUNDUP function is useful. For rounding down decimal ROUNDDOWN excel function is useful. Depending on the requirements, these Excel functions will help us to save our time.

  • Lenovo K3 Note 5.5 inch Phablet With 4G Launched at Rs.9999

    Lenovo has launched its most anticipated 4G phablet K3 Note in India. It will available exclusively on flipkart. The registration for the device is already started. The Lenovo K3 will go on sale from July 8.

    Sudhin Mathur – Director, Smartphones, Lenovo India on the event of launch said that, “We are truly overwhelmed with the positive response from consumers for our 4G portfolio. To further enhance our consumer’s experience we are launching a device with great multitasking capabilities and unrivalled features at an affordable price. The K3 Note is certainly a disruptive offering with its future-proof features, superior multi-media experience and extraordinary performance.”

    Read: Lenovo K3 Note Review.

    Lenovo Android Phablet

    Lenovo K3 Note runs on Android 5.0 lollipop with Vibe UI. It supports both LTE bands in India FDD-LTE 1800MHz Band 3, and TDD-LTE 2300MHz Band 40.  Lenovo K3 Note sports 5.5 inch OGS IPS display with screen resolution of 1080×1920 pixels and 401 ppi pixel density.

    Lenovo K3 Note is a dual sim Android smartphone. It is powered by 64-bit 1.7GHz octa-core MediaTek MT6572 processor with 2GB of RAM. There is 16GB internal storage and support for microSD card upto 32GB.  The Lenovo K3 Note will be available in Onyx Black, Pearl White, and Laser Yellow colour variants.

    Lenovo K3 Note comes with 13 megapixel primary rear camera with Dual LED flash and a 5MP front facing camera. Connectivity options of this phablet includes 4G (TD-LTE/ LTE), Wi-Fi, GPS/ A-GPS, Bluetooth, Micro-USB, tethering and WiFi hotspot.  The device measures 152.6×76.2×7.99mm and weighs 150 grams.

    Lenovo K3 Note houses 3000 mAh battery which is rated to deliver up to 39 hours of talk time on 2G and 16 hours on 2G, apart from 11 days of standby time.

    This K3 Note was first launched in China back in March. This Lenovo phablet has almost similar specifications as that of  Meizu m1 note. However, Meizu m1 note price in India is Rs. 11,999 which is much higher than K3 Note.

    Lenovo K3 Note Specification

    • Android 5.0 lollipop with Vibe UI
    • 5.5 inch OGS IPS display with screen resolution of 1080×1920 pixels and 401 ppi pixel density
    • 64-bit 1.7GHz octa-core MediaTek MT6572 processor with 2GB of RAM
    • 16GB internal storage and support for microSD card upto 32GB
    • 13 megapixel primary rear camera with Dual LED flash
    • 5MP front facing camera
    • 4G (TD-LTE/ LTE), Wi-Fi, GPS/ A-GPS, Bluetooth, Micro-USB, tethering and WiFi hotspot
    • 3000 mAh battery.
  • Tata Swach Smart Water Purifier Review

    Tata Swach Smart is one of the most affordable water purifier in India. It is ideal for small family. Tata claims that, the Tata swach water purifier uses Silver Nanotechnology which effectively removes harmful bacteria and viruses.

    Tata Swach Smart water purifier comes with a stylish and compact design.  It measures 301 x 231 x 436 mm(LengthxWidthxHeight). The upper container has 7.5 liter of capacity and Lower container has 7.5 liter of capacity.  The retail unit of Tata Swach Smart contains Top cap, Top Mesh, Top Storage container, Connector Cap, Tata Swach Bulb(With Bottom mesh attached), Lower storage container, tap and user manual.

    Tata Swach Smart water purifier comes with changeable bulb which uses Silver Nanotechnology to effectively remove harmful bacteria and viruses from water. The bulb can purify upto 1500 liters after that one need to replace the bulb.

    Tata Water Purifier

    Tata Swach Smart does not requires running water and electricity. The other key features of this water purifier are as follows.

    • Pure power indicator: indicated purifying power level of the Tata Swach Bulb and signals when to replace it
    • Advanced auto shut-off mechanism: Stops flow of water once the purifying power of the bulb is exhausted
    • Tata Swach Lock: Mark of originality to guarantee genuineness of Tata Swach Bulb

    Advantages and Disadvantages of Tata Swach Smart Water Purifier

    Pros of Tata Swach Smart

    • Very affordable price
    • Easy to install
    • Compact and stylish design.
    • Easy to clean and maintain
    • Low maintenance cost.

    Cons of Tata Swach Smart

    • Not useful for hard water: Though for the budget no water purifier provides this features. However, just to keep you informed, I am writing it here.
    • No Option to connect to running water: Only to option to fill the water is through manual filling.

    Tata Swach Smart Specification

    • 301 x 231 x 436 mm(LengthxWidthxHeight)
    • 15 liter overall capacity
    • Silver Nano Technology
    • Tata Swach Smart water purifying capacity: Upto 1500 liter

    Tata Swach Smart Water Purifier Unboxing and Installing Video

     

  • Yu Yuphoria Cons and Pros Review

    Yu Yuphoria is the second smartphone from the YU Televentures which is the subsidiary of Micromax. Yu Yuphoria is a compact and less pricier than the Yu Yureka. It will compete with the likes of Moto 2 4G 2nd gen, Xiaomi Redmi 2, Lenovo A6000 plus etc. The Yu Yuphoria price in India is Rs.6999 and available exclusively on Amazon via flash sales.

    Yu Yuphoria is sports 5 inch IPS display screen which comes with laminated glass coating. The screen has a resolution of 720×1280 pixels and pixel density of 294 ppi. There is also Corning Glass 3 to protect the screen from scratches and smudges. The display is sharp. The viewing angles are decent. However, there is slight color shift when you change the viewing angles horizontally. It is also observed that, the screen’s color temperature is skewed towards the warmer side and whites have pink tint. The sunlight legibility is good if you increase the brightness level. But auto brightness is not great.

    Read:

    Yu Yureka Review

    Motorola Moto E 2nd Gen Review

    Yu Yuphoria is powered by Qualcomm Snapdragon 410 system on chip which has a 64-bit 1.2GHz quad-core processor with Adreno 306 GPU and 2GB of RAM. This same chipset used in Redmi 2, Lenovo A6000 and Moto E 4G 2nd Gen. The device has 16GB of internal storage in that 11.8GB is available for users. Yu Yuphoria runs on Cyanogen Mod 12 ROM which is based on Android 5.0 platform. Out of the box device supports screen recording. You record your on screen navigation with recording registering where you’ve touched the screen as well. This feature is called Screencast.

    Micromax Yu Yuphoria

     

    Yu Yuphoria is a dual sim phone. The first sim has  4G LTE  TDD 2300MHz and FDD 1800MHz bands support and the second sim can take 2G or 3G. The connectivity features of the device are 3G, 4G (CAT 4, including TDD-LTE, Indian 4G bands, both sim card slots), Wi-Fi, Bluetooth 4.0 and GPS.  Cellular call quality and network reception are acceptable. However, WiFi signal reception is bit weak. Also the GPS encountered few issues in the test.

    Yu Yuphoria houses 8MP rear primary camera with OmniVision OV8865 sensor with an aperture of f/2.2. There is also a 5MP front facing camera. The primary camera has autofocus and secondary camera is fixed focus. The dayshots are good but low light shots are just ok.  8MP camera takes 4:3 ratio photos whereas for a taking wide angle photos, it drops to 2MP. The front facing camera is decent for the price. The device comes with user replaceable 2230mAh battery. The battery has quick charging features and battery life is satisfactory.

    Advantages and Disadvantages of  Yu Yuphoria

    Pros of Yu Yuphoria

    • Decent Battery life: With normal use, battery lasts for a day. It comes with fast charging features which is very handy. This is the only device which has fast charging feature in this price tag.
    • Good performance: Overall performance of the device is decent.
    • Sound quality and loudness: The quality of sound, the built in speaker produces is good and also the loudness decent.
    • Decent Camera: The primary and secondary camera performance is decent. Though there is lack of quality in recording the video as well as low light performance, considering the price, it is ok.
    • Value for money: For the price, the device is good. Though there are few improvement areas, it is decent performer.

    Cons of Yu Yuphoria

    • Issues with Proximity sensor: It may be a software glitch. Some of the issues observed are when making calls, device screen is not switching off, or trouble while disconnecting the calls etc. Hopefully with future software update, it might get fixed.
    • Lag in Dialer: This is once again a Cyanogen OS issue. There is a lag observed when the dialer is used. Also while typing messages fast, there is a skipping of words.
    • No USB OTG support: This device does not support USB OTG
    • No LED notification light:
    • Camera could have been better: As mentioned above, video recording on both camera are not upto expectations.

    Yu Yuphoria Specification

    •   5 inch IPS display with 720p HD resolution.
    •  Qualcomm Snapdragon 410 64-bit 1.2GHz quad-core processor with Adreno 306 GPU and 2GB of RAM.
    • 16GB internal storage and support for microSD card.
    • 8MP primary camera and 5MP front facing camera.
    • 4G bands, both sim card slots), Wi-Fi, Bluetooth 4.0 and GPS.
    • Dual sim.
    • Cyanogen Mod 12 ROM based on Android 5.0 Lollipop.
    • 2230mAh battery.