Set Rounding Precision in Excel As you must be aware, Microsoft Excel displays rounded numbers (for example 4.56) and not the actual numbers (4.557321) in Excel spreadsheets. However, when it comes to calculations, Excel uses the actual numbers (which can be up to 15 decimal points) and not the rounded numbers as displayed in the worksheet. This results in Excel rounding errors, which can lead to cases of clients/customers claiming errors in Excel spreadsheets, based on their manual spot checks using calculators....

Transfer WhatsApp Photos From iPhone to Mac or PC Millions of users all over the world use WhatsApp to share both personal and others photos & videos with family, friends and relatives. Over a period of time, an average WhatsApp user can end up accumulating hundreds of photos and videos, taking up most of the storage space on iPhone. An easy solution for this issue is to keep transferring WhatsApp Photos from iPhone to computer from time to time and free up storage space by deleting WhatsApp Photos from iPhone....

Unable to Wake Up Windows 10 Computer from Sleep Mode The Sleep mode feature in Windows 10 saves battery life by automatically switching your computer into Low Power mode after a certain period of inactivity. After the computer goes into sleep mode, you should be able to Wake up the computer from sleep mode by pressing any key on the keyboard of your PC or by moving the mouse. If you are unable to Wake up Windows 10 computer using keyboard or mouse, it is possible that the option to Wake up computer has been disabled or the hardware on your computer does not support this option....

What is Airplane Mode? How Does Airplane Mode Work? There is a common belief that signals from smartphones can interfere with an Airplane’s telecommunication systems and cause the plane to crash. However, this is not exactly true, as the equipment used in modern Aircraft is very robust and unlikely to malfunction or become adversely affected in any way due to interference from electronic devices. The actual reason for asking passengers to switch their phones into Airplane or Flight Mode during takeoff and landing is to prevent passenger cell phone signals from interfering with cellular networks on the ground....

Your Screen is Being Observed Message on Mac In general, users have reported “Your Screen is Being Observed” message appearing in the following modes. Message reading “Your Screen is Being Observed” appears on the Lock Screen of Mac (before logging into Mac). Mysterious “Overlapping squares” Icon (two rectangles on top of each other) appear at top-right corner of screen. When this icon is clicked, it reveals “Your Screen is being observed” message....

Disable Siri Spotlight Search Suggestions on iPhone The Spotlight Search feature on iPhone allows you to quickly search for Apps and other information by swiping down with one finger from middle of the screen and typing keywords in the Spotlight Search Bar. Whenever you access Spotlight Search on iPhone, you will always see Siri Suggestions right below the Search bar, taking up a good portion of the screen with suggested Apps, Contacts, Photos, Locations, Stocks, News Stories and more....

Find If Someone Has Blocked Your Number on Android Phone As mentioned above, it is quite possible that someone is using the Call blocking feature on his/her Android Phone to avoid your calls. It is also possible that someone has added your phone number to the block list by mistake. Whatever may be the case, it is worth checking whether or not your Contact has blocked your phone number on his/her Android Phone....

Server DNS Address Could Not Be Found Error When you try to visit any website on your computer, the web browser relies on the DNS Server to convert the website name to its IP Address or location on the world wide web. However, sometimes the DNS lookup fails and the Domain Name Servers (DNS) is unable to resolve the website to its IP Address. This prevents the Chrome browser from accessing the website and it comes up with “DNS Address could not be found” error message....

Backup iPhone to iCloud And Computer Over a period of time your iPhone will end up accumulating tons of Photos, Videos, Messages, Contacts and other data on its internal storage. All these accumulated Messages, Photos, Contacts and data can be lost, if iPhone is Lost or Stolen, gets damaged and also if the software/firmware on your device becomes corrupted. Hence, the need to Setup iPhone to automatically backup its data to iCloud and download a complete backup of iPhone on your computer....

Backup iPhone to Windows Computer While automated iCloud Backups are easy to setup on iPhone, they are not to be considered as a complete backup of iPhone. iCloud Backups, do not include iMessages, iCloud Photos, Notes, Calendars and other data which is already available on iCloud. Also, iPhone won’t be able to backup all its Data to iCloud, if you run out of storage space in your free iCloud Account (5 GB)....

Change Display Language in Chrome Browser Chrome Browser supports multiple Languages and makes it really easy to change its Display Language to Japanese, Chinese, Spanish, Arabic and a host of other Languages. This change applies only to Chrome browser Menus and Settings, the web pages will still display in the original language in which they were written. However, you can setup the Chrome browser on your computer to offer to translate web pages into any of the supported Languages....

Disable Push Notifications From Websites On Mac As soon as you start browsing any website on your Mac, you will immediately see a pop-up, prompting you to either Allow or Deny Notifications from the particular website that you are trying to browse. In case you click on Allow, you will start getting Notifications from the website, every time a new article is published on that website. As you can imagine, this feature in Safari and Chrome Browsers is good for website owners and it allows them to reach their readers....

Enable Attention Aware Features on iPhone While Face ID makes your iPhone secure, there is still the possibility of someone being able to gain access to your iPhone by holding the device to your Face, while you are asleep. Apple’s solution to this rare possibility is to make your iPhone to unlock the device only when you directly look at the screen. You can easily make Face ID more secure by enabling Attention Aware Features, as available on iPhone X and later models of iPhone....

Monitor Data Usage on Android Phone With Mobile or Cellular data being so expensive, most people prefer subscribing to Limited Data Plans. If you are on a Limited Data Plan, it is important to keep track of Data Usage on your iPhone, in order to make sure that you do not go over the allowable data limit set by your Limited Data plan. Luckily, most Android Phones have an in-built ability to Track Data Usage and you can make use of this feature to Monitor Cellular Data Usage on your Android Phone....

Password Protect Folders in Windows 10 The only native way of protecting Files and Folders in Windows 10 is to hide the File/Folder or you can Encrypt the File/Folder in case you have Professional Edition of Windows 10. However, hidden files can be easily un-hidden by anyone using your computer and this cannot be counted as a safe method of protecting files and folders. Also, the option to Encrypt files is not available in the Home Edition of Windows 10....

Reduce WhatsApp Mobile Data Usage on iPhone The default WhatsApp settings on iPhone can end up consuming an excessive amount of your expensive Cellular Data. For example, the cost of using WhatsApp on Cellular Data can be significant, if your device is set to automatically download WhatsApp Photos and Videos using Cellular Network. Luckily, it is easy to Monitor Cellular Data used by WhatsApp on iPhone and take preventive measures to reduce or even totally prevent WhatsApp from using Cellular Data on iPhone....

Clear or Reset iTunes Library Depending on the size, you can either manually clear unwanted items from iTunes Library or totally Reset iTunes Library and start from scratch. Manually removing items from iTunes Music Library will not remove the actual songs from iTunes, it only removes unwanted items from your Music Library. When you go for a Reset, your iTunes Music Library will be Reset to Factory default state and you will also end up losing all your Playlists, Ratings and Lists....

Stop Twitter News Notifications While Twitter notifies you about likes, retweets and mentions it also sends you news based “News for You” notifications. These news based notifications are designed to keep you informed about the latest news appearing on Twitter. While being in touch with the latest news events can be helpful in certain situations, most of the time news related notifications can be distracting and waste your time. If you are currently focussed on your work and life and do not want to be bothered with Twitter’s “News For you” Notifications, you will find below the steps to Stop Twitter News Notifications....

Stop Windows 10 From Sending Activity History to Microsoft Microsoft is transparent about Data Collection feature in Windows 10 (as it should be) and provides an option to View, Clear and disable Activity History via “Privacy” settings on your computer. However, many users were surprised to find their Activity History still being collected, even after disabling the option in Privacy Settings. This problem was recently discussed on Reddit, and you can confirm whether the problem still exists by going to Settings > Privacy > Activity History and disabling “Let Windows Collect my activities from this PC”....

Voice Navigation Not Working in Google Maps If Voice is delayed or not working in Google Maps on iPhone, it is most likely that you may have muted or disabled Sound in Google Maps. If the Sound appears to be delayed during Voice Navigation, the problem is usually due to Google Maps being set to play Voice Navigation over Bluetooth. With this understanding, let us go ahead and take a look at the steps to fix the problem of Delayed, Interrupted or No Sound in Google Maps on iPhone....