Apple Pencil doesn’t have any sort of lights which shows the battery level. While 2nd Generation Apple pencil magnetically attaches on the side of the iPad and charges. 1st Generation Apple Pencil needs to be charged by connecting to iPad or charger. In this post, let us have a quick look into How to check Apple pencil battery percentage level using the iPad widget.
If you are using the Apple pencil for long time, then knowing the battery level will help you to know when to keep it for charging. Apple Pencil is claimed to provide upto 12 hours of battery life in a single charge. Also even in case battery drains out, you can charge it for 15 seconds and use it for 30 minutes.
How to check apple pencil battery percentage level
To check battery percentage of Apple Pencil first generation,
Enable Bluetooth on your iPad.
On your iPad, go to Widget area. You can do that by swiping left to right from first home screen page.
Here tap on edit.
Scroll down. Here you will find all the available widgets.
Tap “+” sign adjacent to battery widget.
It will be added to favorite section.
You can move it to change the order.
Now battery percentage of your Apple pencil will be shown on the widget.
The 2nd Generation Apple pencil battery percentage will be directly shown at the top of the screen when it is attached to the side of the iPad.
Want to capture a screenshot on Galaxy M21? Very often we come across a situation in which we want to grab what is on our phone screen and either share it or save it for future reference. Screenshots are the perfect solution for this. So here is how to take screenshot on Samsung Galaxy M21.
Galaxy M21: How to take screenshot
Hardware keys method
Assistant Touch menu
Palm swipe gesture.
Taking a screenshot on Galaxy M21 using the hardware keys
To take screenshot using this methods, follow the steps given below.
Navigate to the content which you want to screenshot.
Quickly press Power and volume down key simultaneously and release them.
The screen will flash and screenshot will be saved.
Screenshot toolbar will pop up in the bottom. You can directly share from there or you can jump into the editing mode. Editing mode lets you crop and draw on the screenshot before sharing or saving.
How to screenshot using Palm swipe
Open the content you want to screenshot.
Swipe your palm from one side to other ensuring the edge of the palm touches the screen slightly.
The screen will flash and the screenshot will be saved.
If this method does not works, go into Settings, Advanced features, Motions and gestures and make sure Palm swipe to capture is turned on.
You will be getting a sharing and editing options in the exact same way from either the on screen toolbar or notification shade.
Capture screenshot using Assistive touch
To use this method,
Enable the Assistant Touch menu.
Go to Settings, Accessibility and then interaction and dexterity.
On this page enable Assistant Menu. In the next page, make it on.
XLOOKUP is the latest addition to Excel lookup family of functions. It is much more functional excel formula than VLOOKUP or HLOOKUP. In this post, let us explore all about this new EXCEL XLOOKUP function with Syntax and examples.
XLOOKUP formula is available only on Office 365 at the time of writing this. It may roll out to other version in the coming months.
What is XLOOKUP? How it is different from VLOOKUP or HLOOKUP?
XLOOKUP allows us to search for a value in a range or table and return the matching result. It is similar to VLOOKUP/HLOOKUP but, it offers so much more. For example, VLOOKUP can do only vertical lookup and HLOOKUP will do only horizontal lookup. XLOOKUP can be used for vertical or horizontal lookup. We will explore more on this in our example section.
XLOOKUP has just 3 mandatory parameters and 3 optional parameters.
The mandatory parameters are
The value you are looking for.
The list where the value to be searched.
The list where you want the result.
Advantages of XLOOKUP in EXCEL
XLOOKUP is simple and easy to use: You just need to write =XLOOKUP(What you want to find, list where you want to find, result list). You will get the answer. It is less error prone as well. No need to use the index number or define on whether you want to exact or relative match.
Supports right to left lookup: By default, this function has support for right to left lookup.
IFERROR is built in as parameter: Most of the times, we will wrap VLOOKUP formula with IFERROR to hide the #N/A. However, XLOOKUP has 4th parameter in which you can define the default output if the the value is not found.
Reference as outputnot the value: This means that, you combine XLOOKUP outputs with other formulas to get innovative outputs.
XLOOKUP Syntax
Basic formula with mandatory fields
=XLOOKUP(What you want to find, list where you want to find, result list)
Optional Parameters
Only 3 parameters are mandatory for XLOOKUP formula. However, you can use optional 4th, 5th and 6th parameters to explore additional features.
4th Parameter in XLOOKUP: IF not found: This parameter can be used to define what to do incase if search value is not found. Instead of returning #N/A, you can get your optional output.
5th Parameter in XLOOKUP: Match Mode or type: By default, match type is exact match. However, you can choose between Exact match or next smaller item or next larger item or Wildcard character match.
6th Parameter in XLOOKUP-Match direction: By default direction is top down. If you want bottom up, you define it in the 6th parameter.
XLOOKUP in EXCEL examples
Let us take the sample data sheet below.
Example 1: As a alternative to VLOOKUP:
=XLOOKUP(A2,F2:F10,G2:G10)
This will look for the value in A2 in the range F2 to F10 and return the corresponding value in the range G2:G10. The result will be “Sales”.
Example 2: Right to Left Lookup
One of the advantage with XLOOKUP is right to left lookup. So to get the name, use formula as given below.
=XLOOKUP(A2,F2:F10,E2:E10)
This will look for the value in A5 in the range F2 to F10 and return the corresponding value from the range E2 to E10. That is “Jill”.
Example 3: Lookup bottom up
When there is a duplicate values in lookup range, you can choose first from the top or first one from the bottom by using the 6 parameter. -1 to bottom first and 1 for top first.
=XLOOKUP(A8,G2:G10,H2:H10,,,-1)
This will look for the value in A8 in the range G2 to G10 and return the corresponding value from the range H2 to H10. As we have selected -1 as 6th parameter, it will pick first one from last. The result will be 17-Apr-2020.
Example 4: Handling Not found error
In XLOOKUP, you can define what to do incase the search value is not found in the lookup list by entering the 4th parameter.
=XLOOKUP(A11,F2:F10,E2:E10,”Not Found”)
This will look for the value in A11 in the range F2 to F10 and return the corresponding value from the range E2 to E10. As the ID “SA104” not available in the range F2 to it will return “Not Found”. You can define any value or a different formula. For example, you can define another XLOOKUP to look for the data in different table as well.
HMD Global, the home of Nokia phones, recently launched Nokia 3.1 Plus in India. The key attraction of this smartphone is 6-inch HD+ display and 3500 mAh battery which is claimed to provide up to 2-day battery life. Nokia 3.1 Plus is also part of the Android One programme. Hence this device ideally will get monthly security update up to 3 years and OS updates for 2 years. Here is the quick Nokia 3.1 Plus FAQ Tips and Tricks Cons.
Nokia 3.1 Plus FAQ Tips and Tricks Cons
What are the different variants of Nokia 3.1 Plus available?
Nokia 3.1 Plus will be available in two variants. One with 2GB of RAM and 16GB of internal storage and the second one comes with 3GB of RAM and 32GB of internal storage.
Does this smartphone has dedicated microSD card support?
Yes.
What is the price of different variants of Nokia 3.1 Plus?
3GB RAM with 32 GB storage variant price is ₹11,499. Another variant price yet to be revealed.
What are the key specifications of Nokia 3.1 Plus?
Here are the summarised specifications of Nokia 3.1 Plus.
6-inch HD+(720×1440 pixels) IPS display with 18:9 aspect ratio and 2.5D glass.
Octa-core MediaTek Helio P22 (MT6762) SoC
2GB/3GB RAM with 16GB/32GB storage.
Dual camera setup. 13-megapixel primary sensor along with a f/2.0, PDAF lens and a 1.12-micron pixel size and 5-megapixel secondary monochrome sensor along with a f/2.4, fixed focus lens and 1.12-micron pixel size.
8MP front facing camera with a f/2.2, fixed focus lens, and a 1.12-micron pixel size.
4G VoLTE, Wi-Fi 802.11 b/g/n, Bluetooth v4.1, GPS/ A-GPS, Micro-USB, and a 3.5mm headphone jack.
To capture screenshot on Nokia 3.1, first, go to the screen on which you want to take the screenshot. Then press and hold Volume down and power button simultaneously. The screenshot will be captured. Another way to take the screenshot on Nokia 3.1 Plus is using Google Assistant.
What are the cons of Nokia 3.1 Plus?
We have not done the review on the device. However, based on the specification, here is the quick list of Nokia 3.1 Plus Cons.
Following Nokia 3.1 Plus demerits are purely based on comparison with other smartphones in the same price tag.
Mi Air Purifier 2 is a stylish compact air purifier which is priced at Rs.9,999. I have been using this air purifier at my home from December 2016. Based on my last one year’s experience, here is the Mi Air Purifier 2 review.
Mi Airpurfier 2 comes with triple layer 360-degree cylindrical filter. This triple-layer design claims to removes particles larger than 0.3 microns with a high-density EPA filter, while an activated carbon filter removes formaldehyde, bad odor, and other harmful substances.
Mi Air Purifier 2 Review- Pros and Cons
Mi Air purifier 2 Pros
Here are the few things which I liked with this air purifier.
Design: It is one of the best-looking air purifiers in the sub 10k price range.
Quiet operation: In night mode, it is almost silent. Xiaomi claims it produces a noise level as low as 30db in night mode. Though I have not tested actual decibel, it is quieter than the other air purifiers I have tested so far. It is hardly audible.
Sync with a smartphone: This Xiaomi air purifier can be paired with the smartphone through WiFi. Using the Mi Home app, you can monitor pollution level in real time or control the air purifier.
Easy filter replacement: As it has a single cylindrical filter, it is very easy to change the filters.
Mi Air purifier 2 Cons
Over the close to one year experience with this air purifier, I felt few things could have been better. Here is the list of Mi Air Purifier cons.
Cost of filter: According Xiaomi, the filter should be replaced every 4 to 6 months depending on the usage. MRP of the filter is around Rs.3,000. That means for 1 year 2 filter replacements required which cost around Rs.6,000 per year. In my usage wherein I have used the purifier almost 20 plus hours a day, I was required to replace it every 3 months. Otherwise, some bad odor starts to come in from the purifier.
Automatic shifting to auto mode after 3 hours: Irrespective of the mode you have selected and pollution level, this purifier automatically shifts to auto mode after 3 hours. So, even if the air pollution is high, you cannot run at high speed more than 3 hours continuously. Need to change the mode manually every 3 hours if required.
Filter availability: It is becoming a common problem for buying Xiaomi devices. Sometimes, filters are not available to buy. It says Out of stock.
No real-time air pollution monitor: Exact air quality can be monitored through the Mi Home App. However, if you don’t have the WiFi there is no way to see the air quality level. There is a LED indicator. But it will give only rough idea.
Mi Air purifier 2 review summary: Pricedat Rs.9,999, this air purifier offers a lot. Stylish compact design with max 310m/h Clean Air Delivery Rate (CADR) is the biggest USP. However, it lacks in few areas.
