Tech2 Touch

Author: Aniruddh

  • Take Screenshot on Samsung Galaxy J6 and Galaxy J4

    Samsung J series smartphones are one of the successful smartphone series from past couple of years. Samsung Galaxy J6, Samsung Galaxy J4, Samsung Galaxy J6 Plus, and Samsung Galaxy J4 Plus are the latest release from this series. In this post, we will have a quick look into how to take screenshot on Samsung Galaxy J6 and Galaxy J4. The same method of capturing screenshot works with Galaxy J6 Plus and Galaxy J4 Plus as well.

    Capturing screenshot is the simple way to share the content on Galaxy J6 or Galaxy J4 with others or save it for future reference.

    Take Screenshot on Samsung Galaxy J6 and Galaxy J4

    Both Galaxy J6 and Galaxy J4 smartphones run on Android Oreo with Samsung own custom skin Experience 9.5 UI. This is the same OS version used in Galaxy J6 Plus and Galaxy J4 Plus. For all the 4 phones, the method to perform print screen remains same.

    Take Screenshot on Samsung Galaxy J6

    Take Screenshot on Samsung Galaxy J6 and Galaxy J4 using hardware Keys

    • First, go to the screen on which you want to capture a screenshot.
    • Press and hold volume down and power button simultaneously.
    • You will observe a shutter sound and screen flickering.
    • This confirms screenshot is taken.

    Take Screenshot on Samsung Galaxy J6 and Galaxy J4 using Google Assistant

    • On the screen on which you want to capture the screenshot, launch Google Assistant.
    • Just say or type “Take Screenshot”
    • The screenshot is taken.
    • Do remember, in this method screenshot is not saved by default. You need to save manually or you can directly share.

    You can access the taken screenshots from the Gallery folder.

    These are the two built-in methods to capture screenshot on Samsung Galaxy J6, Samsung Galaxy J4, Samsung Galaxy J6 Plus, and Samsung Galaxy J4 Plus. Long screenshot option is not available on these devices. Palm swipe gesture to take the screenshot on these Galaxy J smartphones not available.

  • Realme 2 Pro Review- Pros and Cons

    RealMe 2 Pro is the latest smartphone with powerful internals at the attractive price tag.   Large display panel with slim bezels and dew drop notch, Snapdragon 660 SoC, up to 8GB of RAM are the main USP of this device. So how does it fares in real time usage? Let’s explore in this Realme 2 Pro Review with pros and cons.

    Realme 2 Pro Review

    Realme 2 Pro Review- Pros and Cons

    Key Specification

    • Octa Core Snapdragon 660 SoC.
    • 4/6/8GB RAM and 64/128GB internal storage.
    • 6.3 inch Full HD+ IPS LCD screen(19.5:9 Aspect Ratio).
    • Dual rear camera -16MP with f/1.7 and  2MP depth.
    • 16MP front facing camera.
    • 3500 mAh battery.

    Realme 2 Pro Pros

    DewDrop notch and Good display panel:

    Realme 2 pro sports 6.3 inch Full HD+ display with Corning Gorilla Glass protection. Notch design is becoming a norm on many smartphones nowadays. “crystal-like dewdrop effect” is what Realme calls for the notch design this display has. It takes a small portion of the screen and looks aesthetically beautiful.

    The display panel used on this device is good. It provides good color saturation and viewing angles. The brightness is good enough to be legible in direct sunlight.

    Powerful Performance

    The device comes with Qualcomm Snapdragon 660 which is a powerful Octa-core Chip. For RAM and storage, the user can choose between 4GB of RAM with 64GB of storage; 6GB of RAM with 64GB of storage or 8GB of RAM and 128GB of storage. There is no complaint about the device regarding the performance. Whether it is multitasking or playing heavy games, it does without any issues.

    Good Camera

    The RealMe 2 Pro comes with a 16-megapixel main rear camera with a f/1.7 aperture and 2MP depth sensor. The images taken in good daylight came out well. The snaps had good dynamic range and colors. Considering the price, overall camera performance is good.

    Decent Battery

    3500 mAh battery on RealMe 2 Pro last one day without any issues with moderate to heavy usage.

    Realme 2 Pro Cons

    • Body attracts lots of smudges.
    • No stabilization for 4K video recording.
    • Slow charging.
    • No NFC and FM RAdio.

    Realme 2 Pro Review summary: Overall RealMe 2 Pro stands out in front of the competition. There are few drawbacks which can be ignored considering overall package it offers for the price.

     

  • Samsung Galaxy A7 (2018) Cons – Top 5 uninspiring Features

    Samsung Galaxy A7 2018 edition finally available to Indian consumers. Triple camera setup and fingerprint scanner integrated power button in the side are the unique features of this device among the Samsung Galaxy smartphones available today. The price of  Galaxy A7 (2018) starts from INR 23,990. Though it has many good features, considering the price, we felt a few things are not great on this device. Here is the Samsung Galaxy A7 (2018) Cons or demerits based on our first impression.

    Samsung Galaxy A7 (2018)

    Samsung Galaxy A7 (2018) Cons – Top 5 uninspiring Features

    • Lack 4K Recording Option: Video recording is restricted to full HD resolution. Even though  Samsung Galaxy A7 2018  is a camera-centric phone, it is sad to see no 4K video recording.
    • No Option Image Stabilisation: Though there is an EIS for the rear camera, the device lacks optical image stabilization.
    •  No NFC: This means, you can use Samsung Pay mini and not the full version of Samsung Pay. Hence you will not be able to use offline tap-and-pay using credit and debit cards on this device.
    •  Lack of USB-C type port and fast charger:The Galaxy A7 2018 comes with microUSB port. The bundled charger is not a  fast charger. Also, it does not support wireless charging.
    • No LED Notification Light.

    These are the uninspiring features or Samsung Galaxy A7 (2018) Cons according to us based on the first impression. However, we will be doing the in-depth review in the coming days and update these points if required.

    Samsung Galaxy A7 (2018) has many good features. So here is the quick list.

    Samsung Galaxy A7 (2018) Pros

    • Large 6 inch good AMOLED Display panel.
    • Ample storage and RAM.
    • Dual SIM with Dual VoLTE support and Dedicated microSD card slot.
    • Triple camera setup with 1 wide angle camera.
    • Impressive looks and design.

    Samsung Galaxy A7 (2018) is available in 2 variants. 4GB RAM/ 64GB storage variant price is Rs. 23,990 and 6GB RAM/ 128GB storage variant costs Rs. 28,990.

  • Conditional VLOOKUP in Excel with Match Function

    VLOOKUP in Excel is a powerful function. Simple vlookup does search for the value in the left most column in the table and returns the value in the same row from column number provided. If the requirement is to search for both row and column, then we need to use a conditional VLOOKUP in Excel. This needs clubbing of match function with vlookup.

    Recommended Reading:

    VLOOKUP in EXCEL tips and Tricks

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

    Conditional VLOOKUP in Excel with Match Function

    There are many ways to do conditional VLOOKUP in EXCEL. In this post we will learn one of the simple method to achieve this. For that, we need to use MATCH Excel function.
    By default, we need to enter the column number in the VLOOKUP syntax. To do conditional vlookup which does checks for both row and column, replace column number with match function. The syntax will look like below.
    VLOOKUP( lookup_value, table_array, MATCH (lookup_value, lookup_array, [match_type]), [range_lookup] )

    Explanation on how it works

    Lets a take a simple example. Refer the table below. The row has store details and in column has categories. To return corresponding value by matching  both row and column, this conditional vlookup formula will help.

    Conditional VLOOKUP in Excel

    Formula used here is 

    =VLOOKUP(A10,A1:D5,MATCH(B9,A1:D1,0),FALSE)

    In this example, instead of hard coding the column number, we have used match function. MATCH function return the relative position of an item in an array that matches a specified value in a specified order.  In our example it return the column number of the row header Store 3.

    Syntax for Excel MATCH function is

    =MATCH(lookup value, lookup array, [match type])

    This can be achieved through combination of match and index formula too. However, personally for me this is the most convenient way to do row and column vlookup in excel. If you have any specific queries on VLOOKUP in excel, feel free to write to us in the comment section below.

  • Moto G6 Plus Cons- 4 reasons for not to buy

    Lenovo finally launched Moto G6 Plus in India. It was unveiled globally in April 2018. Unlike the global variant of Moto G6 Plus, Indian variant comes with 6GB of RAM.  Looking at the specifications and the pricing, here is the Moto G6 Plus Cons.

    Moto G6 Plus Cons

    Moto G6 Plus Cons- 4 reasons for not to buy

    Uninspiring design

    Moto G6 Plus sports 5.93-inch display with 18:9 aspect ratio. Full-HD+ (1080×2160 pixel) resolution. However, the latest trend of thin bezels or display with a notch is missing. It has thicker bezels, especially in the top and bottom. The device has screen to body ratio of around 75%.  Overall there is nothing so special in this device when it comes to the design aspect.

    ‘outdated’ Qualcomm Snapdragon processor

    Moto G6 Plus is powered by a Qualcomm Snapdragon 630 processor. There are many smartphones such as Redmi Note 5 Pro, Nokia 6.1 Plus feature much more powerful and efficient Snapdragon 635 processors at a more competitive price. Xiaomi Poco F1  which comes with price tag of INR 21,000, features Snapdragon 845.

    No Fast Android updates

    Compared to Android One powered smartphones, Moto phones software updates are slow. There was a time when Motorola phones used to get Android updates faster. But nowadays, it is not the same.

    Not a value for money device

    Motorola is popular for providing the latest hardware at the competitive price.  However, Moto G6 Plus is disappointed in this segment. Price at INR 22,999, features it offers compared to the competition is very less.  Asus Zenfone Max Pro M1, Nokia 6.1 Plus, Xiaomi Poco F1, Redmi Note 5 Pro etc provide much better features at the competitive price.

    These are my raw opinion on the device. These Moto G6 Plus Cons are purely based on the specifications. I will be updating this post in the coming days once I complete the full review.