Online Knowledge Zone

We use Microsoft Excel in our daily professional or Personal Life for the Data Maintenance & Reporting. Whenever we need to record our some data, we jumps towards Microsoft Excel for the Numerical Data Preparation. If you are in Technical & Finance Field then you can understand how important Microsoft Excel is. There are numerous of Excel Features are available which can’t be count. Apart from Fixed Formulas, we can create our own string as per the understanding. Today we will introduce you all about a New Feature of Microsoft Excel which is called  “Flash Fill” What is Flash Fill in Microsoft Excel & How Flash Fill Works? Flash Fill auto suggest you to update your data when it senses/track a pattern of the data entered by you in Certain Excel Workbook Microsoft Flash Fill is like an AI (Artificial Intelligence) feature which automatically tracks the pattern of your inputs and suggest you the auto populated date to fill automatically in next cells. Let’s Understand th...

We use Computer on Daily basis. To surf internet, media consumption, reading, writing and many more. We are well familiar with its parts like Mouse, Keyboard, CPU, Monitor etc. Every part has its own separate work. Keyboard is also one of the most important part to access computer and its workings. You can’t type or write on computer without using Keyboard. Keyboard allows us to write or type keywords in computer. It works as input provider to complete our tasks. Keyboard is the medium to put our thought from our mind to computer with the use of Fingers. We don’t know how many of you have noticed that there are small bumps/Ridges or extra design on F & J buttons on keyboards. Ever thought: Why there are special designs, Ridges or bumps on F & J words on Keyboard? This is because: F & J buttons/keys are designed as bumped or with ridges on Keyboard to help users/typer to locate or type correct keys without looking Then another question arises: Why just only F & J Keys...

From the past few decades, google is the most important part of our daily life. We use Google services on daily basis. From Searching, E Mailing, Video Chats, Payments, Games, Movies, Music etc. From time to time, Google is updating its policies & updating its services to provide the better services to its users. Recently google updated all the Logos, designs, interface & looks of many applications and services. Google made some changes in Google Photos that customers need to pay for some editing tools. Now, another news comes that the Google is implementing its new policy from 1 st June 2021 according to which the some google accounts may close after the implementation of this policy. What is in the New Policy of Google from June 2021? According to new google policy which will be implemented from June 2021, its is said that If you are not using or not active for 2 years on Gmail, Google Drive and Google Photos then google will remove all the contents from them and close...

Before OTT platforms we used to watch movies in theaters. The web series which we are watching todays were comes in the form of 2 Hours Movie which we have to watch on Theaters. After the introduction of OTT Platforms like Netflix, Amazon Prime Video, Sony Liv, Zee 5, Disney Hotstar etc. the enjoyment of theaters comes in our Mobile Screen. Now we can watch hundreds of Amazing Web Series without visiting Movie Theaters. OTT Platforms are also providing quality and entertaining contents and customers are enjoying these very much. Shows like Sacred Games, Mirzapur, Scam 1992, Aashram, Patal Lok etc. has its ow separate fan base in India. OTT Platforms got the stage and opportunity where they are preparing contents which every audience can relate themselves with the show. Things which we were not allowed to watch in theaters are now providing by OTT Platforms. These web series come with real life incidents & the stories which makes so much sense not like trash Bollywood movies. From...

Almost Everyone are using Smartphone in current Generation. Smartphones or Mobile Phones became one of the most important parts of our life. To use internet, Calling, Payments, Banking, Photos, Videos etc. We store lots of data in our phone on daily basis. Smartphones makes our life easier & simpler. It's also the main source of entertainment. We are using mobiles on daily basis but do we know everything about it. No, that's not possible but we need to know some major parts of mobiles. These will helps in case of any mishappening. So, today we will give you some information of one of the most important part which we call " IMEI" Number What is IMEI Number ? IMEI Stands for International Mobile Equipment Identity. IMEI Number is 15 Digit numerical code which is different in every mobile. This is the unique identity of every single device. How to know/find IMEI number in mobile ? 1. We can know our Mobiles IMEI Number by just entering *#06# in dial pad. It will sho...

Whenever we visit websites and try to Register or Login to get the Services required, we need to enter or re-type some strange lying & strangely written text & numbers or Need to select some objects as per the instruction to prove that we are not Robots. Have you ever thought why these are for ? Why we need to enter Captcha Codes or select "I am not a Robot Option" to Register of Login ? Today we will discuss about these. What is Captcha Code ? CAPTCHA Refers to "Completely Automated Public Turing test to tell Computers and Humans Apart".   It perform a test depend on which the website will automatically track whether the thing trying to enter in the website is an actually a Human or Robot. Captcha Creates a task for the humans to verify that they are really humans not computer generated bots.  Today in the digital era, you can perform many tasks on Website with the help of bots (System Generated Signals to perform task automatically). If these occupy all th...

We all know the Indian - China - Pakistan conflicts. These situations are increasing day by day. We hear conflicts, wars, border & Privacy issues on daily basis. Some of the hashtags are getting famous over the internet like: #boycutchinaproducts #ckmkb #pkmkb India also banned 118 Chinese Mobile Applications because it is said that these applications are taking crucial and private data of Indian Citizens and using against our brave soldiers who are saving us from external forces. Government of India's this step was really amazing. In this line up, Indian army also introduced its Own (Self/Home build) Mobile Application for Messaging which will be called "SAI - Secure Application for the Internet" This Applications is built specially for Indian Army & Indian Armed Forces to communicate internally with secured platform. This Application supports End-to-End Encrypted Text, Voice & Video calling. The messages & documents shared on this app will be totally enc...

In todays world Internet has been an important part of our life. We are not able to imagine our daily life without using internet. Chatting, Social Media, Videos, Shows, Work, Learning etc. in everywhere we use internet. The consumption of Contents depends on the Internet Speed & Its Prices. Although with introduction of new technology the Internet is available in low cost but with huge consumption and huge user base, the speed is not on that top limit where it should be. Today we will introduce the Top 10 countries where internet speed is on the top as compared to others (*) Countries Having Fastest Mobile Internet in the World: 1. South Korea - 121 Mbps 2. China - 113.25 Mbps 3. United Arab Emirates - 109.43 Mbps 4. Qatar - 92.85 Mbps 5. Netherlands - 79.70 Mbps 6. Norway - 79.49 Mbps 7. Saudi Arabia - 76.37 Mbps 8. Canada - 75.71 Mbps 9. Bulgaria - 75.66 Mbps 10. Australia - 72.39 Mbps Countries Having Fastest Fixed Broadband Internet in the World: 1. Singapore - 226.60 Mbps 2. ...

We search many things on Google on a daily basis. What we deal with always is "Search" Button on Search page but we always see "I'm Feeling Lucky" Tab there but we always ignore this. Have you ever thought Why there is "I'm feeling lucky" button beside of Search Button on Google Home Page ?  As per the Wikipedia: Google's homepage includes a button labeled "I'm Feeling Lucky". This feature originally allowed users to type in their search query, click the button and be taken directly to the first result, bypassing the search results page. It means whenever we search something in Google, we press enter and it shows us the various results in different pages but If you write search description and click on "I'm feeling lucky" then Google will redirect you to the first search result and open that Web Page. For Example: Just Type Facebook on Google and click "I'm feeling lucky" then google will directly open...

Micromax has a separate part in our life. There was a time when Micromax used to Lead the market of Smartphones. Their Canvas & Feature Phones used to rock the market. There were no competitors for the Company. At least once, we used Micromax smartphones. Due to some reasons Micromax failed to serve its customers its best services & devices. Following are the reasons why Micromax failed in Indian Market: 1. Lack of Upgradation of Technology in Smartphones 2. Competition of Cheap Chinese Products 3. No Support from Government 4. Launch of Cheap 4G by Jio 5. Failed to tackle the technological changes etc. But, here's the good news from Micromax India. The most loving Indian Brand will going to bang the market with it's amazing products again. As per the latest Tweet from Micromax India, they are planning to launch its new Smartphone or New Product in Indian Market. As per the Tweet, it may possible the New Product of Micromax will be naming "IN Mobiles" or ...

Whats App has various features which makes our chatting experience so easy & fast. Mute Chats is one of those features where Whats App allows users to Mute Certain Chats for 8 Hours, One Week and One Year. Whats App Mute Notification Feature blocks the Notifications from muted person or groups. Messages will receive as usual but don't show in the notification panel. Now, As per the latest Reports: Whats App Added the Feature of Lifetime Notification Feature naming "Mute Forever". This update is available on the Beta Version. Once the Testing will complete, it will also available for all global users. As per the reports, it may possible this features will roll out in the Month of October 2020. How to Mute Chats on Whats App ? To Mute certain Personal Chats or Group Chats you have to follow these steps: 1. Open Whats App 2. Go to Individual Chats or Group Chats which you want to Mute 3. Then click on 3 dots showing on the Top Right Corner 4. Various Options will Show th...

Computer is now one of the most used part of our daily life. We are using Computer in many places like in Offices, Schools, Library, Hospitals etc. Computer has many parts like Mouse, Keyboard, CPU, Speaker etc. Every Part has its own work but we use Keyboard & Mouse physically on a daily basis the most. Today we are here to teach you the most hidden 20 Amazing Keyboard Shortcuts which will able to ease your work & you can work smartly. 1. "F7" on Word File:  Want to check Spelling of the Words Instantly. Just Press F7 and a popup will open which allows to Correct the Grammar instantly 2. Window Button + D:  Want to directly jump into the Desktop without manually Minimizing the Multiple opened windows. Just Press Window Key + D. This will open your Desktop instantly 3. Window Key + Control + D: Want an instant switch between your Own Work & Official One. Just Create a Second Window and Do your Multiple tasks in just a Switch. To create another Desktop just press ...