Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
If you've ever required to work on many Excel workbooks at the same time, you may have noticed that Excel opens them all by default in the same window. This may be restrictive, particularly when comparing or copying data between workbooks. But there is a straightforward fix—just open each workbook in a separate window. You'll get the freedom to organise and manage your workbooks more skilfully, increasing productivity and optimising workflow. To enable you to work on many files at once, we'll walk you through the process of opening Excel workbooks in new windows in this article. So, let's examine ... Read More
Microsoft Excel is a robust spreadsheet application that provides a variety of tools to boost productivity and simplify your job. One of these features is the ability to easily access the folder that contains the worksheet you are now working on. When you need to search, organise, or share your Excel files, this tool can be quite helpful. This article will walk you step-by-step through the process of opening the current workbook's enclosing folder in Microsoft Excel. No of your level of experience, learning this trick can help you streamline your file management process and save you time. By the ... Read More
Microsoft Excel is a robust spreadsheet programme that is frequently used for data organisation and analysis. The initial step in working with data or editing an existing workbook is frequently opening an Excel file. Even though the File menu in Excel allows you to access previously used files, there are instances when you might need to open a file from a specific location on your computer or network. In this article, we'll walk you through how to use Excel's browse window to access an Excel file. Using this technique, you can choose the specific Excel file you wish to open ... Read More
In this tutorial, we will learn to remove the decimal part of the number in JavaScript. While working with JavaScript, many times, developers need to play with the numbers stored in the database and needs to convert float and double numbers into the pure decimal or integer number.In this situation, developers can have multiple methods to truncate the decimal part of the number. We will see different approaches to overcome the above problem.Using the Math.trunc() methodUsing the Bitwise operatorsUsing the Math.ceil() and Math.floor() methodUsing the Math.Trunc() methodThe Math.trunc() is the most popular method to remove the decimal part of JavaScript. ... Read More
Powerful spreadsheet programmes like Microsoft Excel are frequently used for data analysis, computation, and organisation. The ability to design interactive user interfaces using forms and controls is one of its most useful capabilities. You may improve user experience and simplify navigation in your workbooks by carefully following the offered step-by-step instructions. You will have a thorough understanding of the methods required to create a combo box, link it to a list of worksheets, and implement the code necessary to dynamically launch the selected worksheet by the end of this tutorial. Open a Specific Worksheet by the Selected Value of ... Read More
Context Switching involves storing the context or state of a process so that it can be reloaded when required and execution can be resumed from the same point as earlier. This is a feature of a multitasking operating system and allows a single CPU to be shared by multiple processes.A diagram that demonstrates context switching is as follows −In the above diagram, initially Process 1 is running. Process 1 is switched out and Process 2 is switched in because of an interrupt or a system call. Context switching involves saving the state of Process 1 into PCB1 and loading the ... Read More
In System Design, there are two types of approaches followed namely, the Bottom-Up Model and the Top-Down Model. The bottom-up model is one in which the different parts of a system are designed and developed and then all these parts are connected together as a single unit. On the other hand, the top-down model is one in which the whole system is decomposed into smaller sub-components, then each of these parts are designed and developed till the completed system is designed. Read this article to find out more about the bottom-up model and the top-down model of system ... Read More
Operating Systems have evolved over the years. So, their evolution through the years can be mapped using generations of operating systems. There are four generations of operating systems. These can be described as follows −The First Generation ( 1945 - 1955 ): Vacuum Tubes and PlugboardsDigital computers were not constructed until the second world war. Calculating engines with mechanical relays were built at that time. However, the mechanical relays were very slow and were later replaced with vacuum tubes. These machines were enormous but were still very slow.These early computers were designed, built and maintained by a single group of ... Read More
The type of materials whose conductivity is greater than insulators but less than conductors are known as semiconductor materials. In other words, a material is said to be semiconductor, if it has 4 electrons in its outermost shell. The semiconductor materials are broadly classified into two categories viz. intrinsic semiconductors and extrinsic semiconductors.Extrinsic semiconductors are further classified into two types as −P-Types SemiconductorN-Type SemiconductorIn this article, we will compare the P-type and N-type semiconductors by considering various factors such as type of impurity added, nature of doping, majority charge carriers, density of charge carriers, fermi level, etc. But, before going ... Read More
In this tutorial, we will learn how to pad a number with leading zeros in JavaScript. Padding a number can be done in different ways in JavaScript. In this tutorial, we will see the two most popular ways of doing it − Using the String padStart() method Using the Array object constructor and join() method Using the String padStart() Method In JavaScript, the String object’s padStart() method is useful to pad a number with leading zeros. It takes two parameters, the first one is the total length of the targeted or desired string, and the other one is ... Read More