tech2touch

Author: Aniruddh

  • Vivo V9 Features FAQ Cons

    Vivo V9 new selfie centric flagship has been launched in India with some interesting features. A large 6.3-inch bezel-less display, 24MP front facing camera, dual camera setup in the back, AI integration on both camera, Android 8.1 Oreo are the key attraction of this smartphone. In this post, let’s look into Vivo V9 Features FAQ and Cons.

    Vivo V9 Features FAQ Cons

    What are the different color variant of Vivo V9 available in India?

    This new selfie centric flagship from Vivo will be available in Champagne Gold and Perl Black color variants.

    From when Vivo V9 will be available for purchase in India and where to buy?

    Vivo V9 will be available starting 2nd April 2018. It will be available in Flipkart, Vivo E-Store, Amazon, and Paytm mall.

    What are the specification of Vivo V9

    • Dual Rear Camera(16MP + 5MP).
    • 19:9 Full View 6.3 inch Full HD + Display.
    • Qualcomm Snapdragon 626 Octa Core SoC with 4GB of RAM and 64GB of internal storage.
    • Face Access 2.0 and Game mode.
    • 3260mAh battery.

    How is the display on this device?

    Vivo V9 sports a large 6.3 inch full HD +  bezel-less display. Except for a notch in the top center, the front is fully covered with the display screen. The company claims it has industry’s highest 90% body to screen ratio. With the limited usage, we felt display panel on the device has good brightness and offers decent viewing angles.The color saturation, sharpness are also decent.

    What are the features of Camera on this device?

    Vivo V9 has 24MP front-facing camera with f 2.0. In the back it has two camera setup. One has 16MP and another one is 5MP. This dual camera setup host of other features such as Ultra HD, Slo-mo, Live Photos, Retina Flash and AR Sticker.  The 24MP front-facing selfie camera coupled with AI Face Beaty feature is claimed to provide clear and beautiful selfies.

    What are the key advantages of Vivo V9?

    This is not a review. Based on our first impression at the launch event, here is the list of Vivo V9 pros.

    • The large display panel in a compact size.
    • 24MP selfie camera.
    • Dual camera setup in the back.
    • AI integration on both camera.
    • Dedicated microSD card slot.

    What is the price of Vivo V9 in India?

    Vivo V9 price in India is 22,990.

    What are the cons of Vivo V9?

    • There is no USB-C port.
    • No support for fast charging.
    • Price could have been more aggressive.

  • Excel Formula to Convert Date To Weekday Name Or Month Name

    How to convert a date to Weekday Name Or Month Name or Year? For example 13-03-2018 to Tuesday or March or 2018. This is one of the most frequently asked queries. So let’s learn an Excel Formula to Convert Date To Weekday Name Or Month Name.

    Recommended Reading

    Excel Tips

     

    Excel Formula to Convert Date To Weekday Name Or Month Name

    Excel Formula to Convert Date To Weekday Name Or Month Name or Year

    One of the frequently used EXCEL formula to convert date to Weekday Name Or Month Name or year is TEXT Function.

    The syntax of text function in excel

    TEXT( value, format )

    The TEXT excel function is the easiest formula to use for converting Date To Weekday Name Or Month Name. Let’s learn this with an example.

    We have a date in cell A2 has 13-03-2018(Date-Month-Year format)

    Now we will use TEXT Function

    =text(A2, “ddd”) will return “Tue”

    =text(A2, “dddd”) will return “Tuesday”

    =text(A2, “mmm”) will return “Mar”

    =text(A2, “mmmm”) will return “March”

    =text(A2, “yyyy”) will return “2018”

    =text(A2, “m”) will return “3”

    =text(A2, “d”) will return “13”

    Summary of the examples mentioned above.

    A2 is the value or the reference to the cell where date is present.

    The second argument of TEXT function accepts format, You can use the format based on your requirement as mentioned below.

    1. “ddd” will return first three characters of the week name.
    2.  “dddd” will return full week name.
    3. “mmm” will return first three letters of the month name.
    4. “mmmm” will return full name of the month.
    5. “yyyy” will return year.

    Using TEXT function to convert Date To Weekday Name Or Month Name ideal in the scenario where you want the result to be shown in the different cell. If you just want to convert to the same cell, then format cell will be the best option.

     

  • Samsung Galaxy A8 Plus Cons- Reasons not to buy

    Samsung Galaxy A series smartphones are considered as the toned down version of the flagship. Galaxy A8 plus is not an exception to it. It borrows a lot of features such as infinity display,  best in class design, water, and dust resistance etc from Galaxy S8 and Galaxy Note 8. Priced at Rs.32,990, it is a premium mid-range smartphone. Hence we try to list down some of the key Samsung Galaxy A8 Plus Cons according to us in this post. This is based on the availability of feature on other smartphone at the same price range.

    Samsung Galaxy A8 Plus Cons- Reasons not to buy

    No Android Oreo update

    Samsung Galaxy A8 Plus launched in the month of Jan 2018. Therefore we expected it to ship with the latest version of Android, i.e Android Oreo. Unfortunately, Samsung opted to ship with Android Naugat. Considering the past experience, the device will take a long time to get the latest version of Android.

    Lacks 4K video recording support

    Priced at 33k, comparing with competition, lack of 4K video recording capability is a demerit of Samsung Galaxy A8 Plus.

    No Optical Image stabilization

    Touted as a camera-centric phone, it is surprising that Samsung omitted the optical image stabilization option. The lack of OIS will be felt while capturing photos in low light and artificial lighting condition.

    These are some of the cons of Samsung Galaxy A8 Plus. There are many things which are merits of this which we will list down below.

     Samsung Galaxy A8 Plus Pros

    • Best in class design and build.
    • Good performance.
    • Infinity Display.
    • Good battery life.
    • IP68 certification for water and dust resistance and Samsung Pay with MST technology.
    • Ample RAM and storage space.

    Galaxy A8 Plus is a promising premium midrange smartphone. Samsung has done a good job in most of the segment. Competetive pricing could have made this smartphone much more impressive.

  • Xiaomi Mi TV 4A Key Features

    After becoming India’s largest smartphone seller, Xiaomi is eying for capturing Indian TV market. It has launched affordable smart TV lineup Mi TV 4A in India on March 7 and the first sale will begin on March 13. The Mi TV 4A lineup consists of 43 inch and 32-inch smart tv.

    Below are the key features of the Mi TV 4A

    Mi TV 4A

    Xiaomi Mi TV 4A Key Features

    Screen

    Xiaomi Mi TV 4A base variant sports 32 inch HD display panel(720p resolution) and another variant has 43-inch full HD(1080p) display. Both variants claim to provide a viewing angle up to 178 degree.

    Hardware and Software

    The Mi TV 4A is powered by Amlogic 64-bit quad core chipset coupled with 1GB of RAM and 8GB of internal storage.  It runs on Android-based PatchWall UI. Patchwall is an AI-enabled TV system which helps to customize the content based on user preferences.

    Using the Patchwall, users can access content from several partners such as Voot, Sony Liv, Hungama etc. Some of them are free and some of the content is paid.

    It comes with  DTS and 20W dome speakers. The Mi TV 4A package has 11-button MI Remote.

    Connectivity

    Mi TV 4A has a lot to offer when it comes to connectivity. The 32inch variant of Mi TV4A has three HDMI ports, two USB ports, Ethernet port, WiFi and a headphone jack. The 43-inch variant provides one additional USB port and a S/PDIF port.

    Pricing

    The 32inch variant of Mi TV 4 A price in India is Rs.13,999 and 43-inch variant price in India is Rs.22,999. Like Xiaomi smartphones, these TV’s also will go on sale via flash sale starting from March 13. The flash sale will be held on every week Tuesdays and Wednesday. The new smart tv’s will be sold via mi.com, Mi Home, and Flipkart.

    Xiaomi entered Indian TV segment with the launch of Mi TV 55 inch at Rs.39,999. 4K Video support and Bluetooth connectivity are the additional features of it apart from larger screen size.

  • How to take screenshot on Xiaomi Mi A1

    Xiaomi Mi A1 is one of the best budget Android smartphone of the year 2017. The stock Android experience with timely updates is the main attraction of the device. But the downside of this is lack of software customization which is available on other Xiaomi smartphones. Due to this, many users are searching the option for How to take screenshot on Xiaomi Mi A1. So here is the method to capture screenshot on this device.

    How to set Ringtone in Xiaomi Mi A1

    Recommended Reading:

    How to set custom ringtone in Mi A1

     How to take screenshot on Xiaomi Mi A1

    To capture screenshot on Mi A1, there are 2 methods. First one is using the hardware keys and another one is using the Google Assistant. Do note that, there are other options which need users to install third-party apps. We are not covering those methods.

    Method 1: How to take screenshot on Xiaomi Mi A1 using the hardware keys

    To perform print screen on Xiaomi Mi A1 using this method, follow the steps given below.

    • Go to the screen on which you want to capture screenshot.
    • Now press and hold Volume down and power buttons simultaneously for few seconds.
    • The screenshot will be captured.
    • Captured screenshot can be accessed from Photos->Album->screenshot.

    Method 2: How to take screenshot on Xiaomi Mi A1 using the Google Assistant

    To capture screenshot using this method, follow the steps given below.

    • On a screen on which you want to capture screenshot, open Google Assistant.
    • You can do this by saying “OK Google” or by long press on home button.
    • Now either you can say “Take screenshot” or type.
    • Screenshot will be taken.
    • Do note that, if you are taking screenshot using this method, it will not be saved automatically.
    • You need to either share or upload it to the Google photos.

    These are two methods through which you can take screenshot. If you find any difficulty in following this How to take screenshot on Xiaomi Mi A1 guide, please share it in the comment section below.

    Video Guide on How to take screenshot on Mi A1