Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
The problem statement includes printing of the N-th centered nonadecagonal number for any positive value of N. A centered nonadecagonal numbers are numbers which are represented in a particular pattern of figure. This number can be represented in a figure as a dot in the centre surrounded by the successive layers of the nonadecagon. A nonadecagon is a type of polygon in mathematics which has 19 sides in it. The successive layers of the nonadecagon suggests that the first layer surrounding the dot in the centre will be 19 sided polygon followed by 38 sided polygon and so ... Read More
Are you tired of scrolling down lengthy spreadsheets in Microsoft Excel and missing vital details? Do you want to travel through the large amount of data while keeping your header rows or other important info in sight? You're in luck, then! Excel has a strong feature that lets you repeat rows at the top of your worksheet as you scroll, making sure that important data is always visible. This step-by-step guide will show you how to quickly freeze rows in Excel so that you may keep important data in view while you scroll down the worksheet. This method will increase ... Read More
The problem statement says to print the N-th centered dodecahedral number for any positive value of N which will be the user input. A centered dodecahedral number is a number that can be represented in a particular pattern of figure. A dodecahedron is a three-dimensional figure in mathematics which has 12 flat faces. And a centered dodecahedral number is a number which can be represented in the form of a figure with a dot in the centre surrounded by the successive layers of the dodecahedron (12 faced 3-d structure). The successive layers of the dodecahedron says the first layer will ... Read More
When you have enormous datasets that span numerous pages and want to make sure that important information stays visible at the top of each page for improved reading and context, this handy Excel tool is tremendously helpful. In this video, we'll walk you through each step of setting up row repetition in Excel so that it appears at the top of every printout. Learning this trick will surely enhance the overall presentation and usefulness of your Excel documents, regardless of whether you are working with financial reports, data tables, or any other spreadsheet containing numerous pages. So let's get ... Read More
When working with huge datasets or when you need to expand and organise your data, this effective technique lets you duplicate rows based on the value of a specific column, saving you time and effort. In this article, we'll show you step-by-step how to accomplish this work effectively utilising Excel's built-in functions and features. This technique will be quite helpful in optimising your productivity, regardless of whether you are working with sales data, survey results, or any other type of information that requires row repetition. Repeat Rows a Specified Number of Times Based on Another Column Here, we will first ... Read More
Introduction In context of distributed systems, exception handling refers to process of detecting, diagnosing, and recovering from errors that occur in a distributed system. In such systems, errors can occur at any point in communication and coordination process, including network failures, hardware malfunctions, and software bugs. Thus, effective exception handling is crucial to ensure reliability and availability of a distributed system. In this article, we will explore various techniques and best practices for exception handling in distributed systems. Importance of Exception Handling in Distributed Systems In a distributed system, multiple processes run on different machines and communicate with each other ... Read More
Introduction TCP (Transmission Control Protocol) and UDP (User Datagram Protocol) are two of most commonly used internet protocols. They are both responsible for ensuring reliable data transfer between devices connected to a network. However, way they do so differs significantly. In this article, we will discuss some examples of TCP and UDP in real life applications. TCP in Real Life TCP is a connection-oriented protocol that is commonly used when reliability is primary concern. It is responsible for establishing a reliable and ordered data transfer between two devices. Some examples of TCP in real life applications are as follows − ... Read More
Introduction Human beings are social animals. They have always found ways to communicate and connect with each other. From ancient times, people used various forms of communication like writing, oral communication, and visual arts to convey their messages to others. With advent of technology, communication has become faster, easier, and more efficient. This led to development of networks that connected people across world. In this article, we will explore evolution of networks from ancient times to modern era. Ancient Networks Ancient networks were primarily based on oral communication and visual arts. In ancient civilizations like Sumerians, Egyptians, and Greeks, people ... Read More
With the use of macros, Microsoft Excel is a strong tool that lets users automate monotonous activities. Macros are sets of instructions that can be written or recorded to carry out a particular set of tasks. Some duties, however, must be performed on a regular basis. Consider a task that must be completed every 30 minutes, such as updating a dashboard or retrieving data from a web source. This tutorial will show you how to set up an Excel macro to run automatically at predetermined times. By the time you've finished reading this manual, you'll be able to loop your ... Read More
Working with huge datasets in Excel has you continuously scrolling back up to check column headers? Do you find it difficult to remember which columns contain what data as you scroll down the rows? We have a solution for you, so don't be afraid! This lesson will walk you through the process of having Excel repeat the header row every nth row, which will make it simpler to navigate your data and keep context. In Excel, the heading row typically contains labels that describe the contents of each column. When working with lengthy datasets, the column headers may become invisible ... Read More