Author: Ogechukwu Anthony

The ROUND function in Google sheets is to reduce any value by a specific number of decimal places. When you do that, the final digit is rounded either up or down. There are different rounding functions — ROUND, ROUNDUP, ROUNDDOWN, MROUND. The ROUND function has standard rules which is applicable when it takes a number to a certain number of decimal places. The standard rules indicates that when rounding to a particular decimal place, the most significant digit to the right is considered. If this digit is greater than or equal to the number 5; the digit is rounded up.…

Oculus Quest 2 Black Screen Of Death is an error that occurs while using Oculus Quest or Oculus Quest 2. Even though Oculus Quest and Oculus Quest 2 are the best virtual reality headset out there, they are still prone to technical issues like the black screen of death which is the common error. This error comes up as a black screen, the screen is totally black or sometimes lit up but with a blank screen with the Oculus Quest logo appearing before it finally slips into black screen of death. There are many reasons black screen of death error…

Galaxy Watch 4 was announced in 2021, it happens to be one of the first set of watch to run Wear OS 4 developed by Samsung in collaboration with Google. This smart watch has multiple sensors capable of measuring heart rates, blood oxygen level, blood pressure, ECG reading which is a sensor for measuring body composition. These sensors makes it one of the best smartwatch out there therefore people will want to protect their gadget from damages. However the question remains, is Galaxy Watch 4 Waterproof? Several Samsung gadgets have some form of water resistance example the Galaxy Z Flip…

With Discord you can make internet voice calls and send texts messages. It is one of the popular and fast growing social media platforms boasting of millions of active users who use the platform on daily basis. Discord can be accessed via the mobile app or the official website. The Discord application is prone to bugs that causes errors such as Discord Awaiting Endpoint Error or Discord unknown network error. You don’t need to worry, do these few things and get rid of the discord Unknown network error. Reasons for Discord unknown network error There are a few reasons this…

A reset can help you fix any issue with your PS5 controller; You either do a hard reset or a soft reset. However it’s advisable to start with a soft reset. A reset is necessary especially if you are having connectivity issues with your controller. Here’s how to do a soft and hard reset on your PS5 controller: How to do a soft reset on your PlayStation 5 controller A soft reset is needed if you are experiencing minor with the wireless connection. Issues like; input lag, loss of pairing. A soft reset involves turning the DualSense off and back…

We all use our system to create important documents for clients or for personal use. And sometimes while creating these documents we can make mistakes or do things we’d like to change. However, you can undo any recent changes you made to a document. You can also redo these changes if you want. How to undo pages in Mac There are two ways to undo a page in Mac. You can use the Edit button or use the Menu bar. How to undo pages using the menu bar On the menu bar you will see Files > Go to Edit…

Grindr is one of the popular social media dating apps that caters mainly for the LGBT community. Looking for a way to delete your Grindr account? Here is how to delete Grindr account. How to delete Grindr account on Android To delete Grindr account, the steps are very easy: How to delete Grindr account on iPhone To delete Grindr account on iPhone, follow these steps: Note that deleting your profile will not cancel your premium subscription. Only your personal identification that will be removed from Grindr’s system once you delete your account. So cancel all your subscriptions before deleting the…

*67 is used to hide your number from someone you want to call. You can use the code to hide your mobile number from showing on the recipient’s call interface. This code works on both Android and iOS devices. On the other end, the recipient will see this message if you use *67 to call them, ‘Blocked’ ‘Private Number’. All you have to do is just add *67 before the number you are about to call before dialing it. And you must enter it each time you dial the number. This code does not work when you call toll free…

Netflix Error Ui3012 is a common error Netflix users encounter while streaming a Netflix content. This error occurs when you want to open Netflix site or app or trying to watch something. The Error Code is accompanied by this message : There are several reasons for this error. Ranging from poor signal strength, device interference, incorrect settings, bad cables and a whole lot more causes.Here are few methods to troubleshoot this error and enjoy an error free streaming on Netflix. This error occurs if there is an issue with the network connectivity that prevents your computer from reading the Netflix…

Amazon Firestick is a Bluetooth remote controller that has voice support. It’s one of the popular Alexa devices widely used across the globe, users love it for its sleek and minimalistic design. Your Firestick is connected to Alexa app and cannot function without the app. But you might want to remove Firestick sometimes, especially if you notice it’s malfunctioning. Although Firestick was built to last, a malfunction is still inevitable. If this happens, a factory reset usually brings it back to normalcy. If not, then you need to replace a malfunctioning Firestick device. However before replacing your Firestick, look out…

Airpods are designed to give listeners an immersive audio experience, it is a wireless designed earbuds that provides comfort and mobility for its users. If you accidentally washed Airpods in washing machine while doing the laundry, sorry about that. The good news is that you can salvage the situation and save your Airpods from damage. This article holds all the details. There is a good chance you can restore your washed Airpods because Airpods are somewhat designed as waterproof, splashproof, heat and dust resistant. Meaning it can survive a water incident as long as it doesn’t stay long in the…

Instagram has a feature introduced in 2013 known as Instagram direct, with Instagram direct, users can send a direct message (DM) to other Instagram users whether they follow each other or not. How to send an Instagram direct message You want to send a direct message to someone on Instagram, here’s how to: How to send a direct message to a non follower If it is a non-follower you want to send a direct message to: How to send direct message to a group conversation Also,you can send a direct message to a group conversation on Instagram, here’s how to:…

Facebook is a very popular platform where users get to connect with each other. One way of connecting is by sending out invited to your friends, invites to join a group that you find interesting and you’d like your friends to join and enjoy the fun. It’s also common to see group invites from our friends on Facebook but we can ignore them and later find out it’s an important invite. If you lost a Facebook group invite, finding it can be hard and quite tricky. But this article tell you how to see group invites on Facebook . How…

Instagram Reels is a feature on Instagram recently introduced to the platform where Instagram users get to post video reels on their Instagram page. While adding reels to your Instagram page, you could use some words to enhance your reel. This article highlights how to add text to Instagram Reels at different times, how to add plain texts, multiple texts and how to add disappearing text, and also how to edit the timing of your reel text and take it to another level. You can do this on your Android and iPhone device. First of all you have to have…

You try to share snaps on Snapchat and you realize the audio is not working even though the video is playing. The problem is most likely an issue with your Snapchat app or with your phone. Your phone might be having technical issues, the volume is down, you have not granted Snapchat permission to access microphone, or you connected your device to a Bluetooth device and the sound is playing on the device instead of your speaker. #1. Your phone volume is down If you turned down the volume on your phone, Snapchat sound will not work. So be sure…

Life360 is an American based infotech company that specialists in providing location based services like sharing and notifying consumers globally of the location of their family circle. It enables friends and family members to share their location with each other. This service is 100% free of charge, you just have to download the app into your iOS, Android or Windows. But to enjoy more benefits, you can pay for membership. What does the heart icon mean in Life360? The heart icon is found in the assets library and appears on certain occasion for users in Life360. In reality, we associate…

Snapchat is now a worthy competitor with Facebook, Twitter, Instagram, and other big social media platforms. It appeals to its users especially Gen Z’s because it incorporates beautiful features for a better user experience. What’s even better is that they keep rolling out new and amazing features for its users. Snapchat gives utmost priority to users privacy, there are settings that allows you protect your privacy on the platform. One feature of Snapchat is the icon which represents a lot of things. Snapchat uses icons to describe status and various activities on the platform. Knowing what these icons means will…

iPhone is embedded with the location sharing feature, people get to share their location with their friends, family and loved ones so they know they are in safety. However for privacy reasons, Apple has made it possible that people can stop sharing their location with others at anytime they want without the other party knowing about it. Why you can’t see someone’s location #1. Location is turned off If the other party has turned off their location, you won’t be able to locate them. If you turn off your location, they also will not be able to locate you. #2.…

iPhone’s gyroscope together with accelerometer is responsible for screen rotation and speed movement and gesture. Gyroscope will obtain the coordinates that will enable screen rotation to either portrait or landscape mode. So if gyroscope has problems, screen rotation will not work. How to fix iPhone Gyroscope not working If your iPhone Gyroscope not working, here are a few fixes to try out: #1. Reboot your iPhone A simple reboot can solve the issue, here’s how to reboot: #2. Force start iPhone If the iPhone’s gyroscope is not working after rebooting, try forcing your device to restart. Press and quickly release…

Have you tried adjusting volume with the standard Roku remote control but you realize Roku volume not working on remote. Even though Roku remote control can have problems, it usually does not affect the volume buttons. But, here’s how you can fix it. Step #1. Replace batteries Batteries can run out so you have to replace them after a while. Sometimes you might not place the batteries well so also Check and see if battery replacement is in order. Step #2. Check if TV is muted If your remote can adjust volume button as shown on the screen, but the…