Count Visible Sheets in a Workbook

Pradeep Kumar
Updated on 22-Aug-2023 12:39:03

581 Views

It can be difficult to keep track of how many sheets are showing at once if you've ever worked with large Excel files including a lot of sheets. Excel offers a variety of tools and capabilities to make managing and working with data easier, and counting visible sheets is no exception. We'll walk you through each step of counting the visible sheets in an Excel spreadsheet in this tutorial. This video will provide you the knowledge and abilities necessary to swiftly ascertain the number of visible sheets in your workbook, regardless of your level of Excel proficiency. So, let's dive ... Read More

List and Sort Files and Directories by Size in Linux

Prateek Jangid
Updated on 22-Aug-2023 12:39:00

3K+ Views

Listing the size of each file and directory is good because it helps a user sort them according to the size. Sorting files according to size is necessary to free up space, make them more organized, etc. You can organize the Linux file system through the command line and graphical methods. It helps you to quickly locate the files and directories as per their contents available. So in this long guide, we will explain various ways to easily List each directory and sort them according to the size in Linux. List the Size of Each File and Directory and Sort ... Read More

Count Uppercase or Lowercase Letters in Cell

Pradeep Kumar
Updated on 22-Aug-2023 12:38:10

3K+ Views

Excel is a robust programme that enables you to carry out numerous calculations and data manipulations. Extracting specific information from the text contained in cells through analysis is a frequent activity. This lesson is for you if you need to count the amount of uppercase or lowercase characters in a cell when dealing with text data in Excel. In this lesson, we'll show you how to use Excel's built-in functions and formulae to count the amount of uppercase or lowercase letters in a cell. Regardless of your level of Excel proficiency, this tutorial will give you the knowledge and abilities ... Read More

Count Unique Rows Combinations of Multiple Columns in Excel

Pradeep Kumar
Updated on 22-Aug-2023 12:37:18

2K+ Views

Excel is a strong programme that is frequently used for managing and analysing data. Finding the number of unique rows based on combinations of several columns is a typical problem in data analysis. This enables us to locate and examine particular data sets inside a dataset. When working with huge datasets or trying to find unique records in a dataset containing duplicate entries, counting the number of unique rows is especially helpful. Several built-in functions and methods in Excel can be used to efficiently complete this operation. This tutorial will take you step-by-step through the procedure, enabling you to efficiently ... Read More

Create Soft Links to Directories on Linux

Prateek Jangid
Updated on 22-Aug-2023 12:36:33

3K+ Views

A soft link (symlink or symbolic link) is generated as a shortcut to the available files or folders in the system. Usually, these soft links are used to link libraries. Soft links allow storing multiple clones of the same document in different file systems or destinations. This link refers to the path and address of the original document. The soft link contains different aspects, such as − Soft links can link to both directories and regular files. After deleting the soft link, the original document remains available. The symbolic link does not work when you move or delete the ... Read More

Find Total Size of All Files in a Directory on Linux

Prateek Jangid
Updated on 22-Aug-2023 12:33:27

5K+ Views

You can use various types of commands to get the total size of all files in a directory on Linux. There are also some GUI tools in Linux to display the total size of the directory in a more simple format. Getting the correct information about the directories can help a user to find the storage allocation of the complete system. That's why Linux users always look for ways to find the total size of the directory. In this guide, we will explain various methods to find the total size of all files in the directory on Linux. Finding the ... Read More

Multiple Digit Decimal Display to 4 Digits

Manish Kumar Saini
Updated on 22-Aug-2023 12:25:12

395 Views

What is a Multiple Digit Decimal Display? A type of electronic display which is used to show multiple digits of decimal numbers is called a multiple digit decimal display. A most extensively used type of multiple digit decimal display in digital systems is a 4-digit display. The 4-digitl display is able to display decimal numbers between 0 and 9999 (largest 4 digit number). The most common application of these multiple digit decimal displays is in digital calculators, digital watches and clocks, and in many other electronic devices that need to display information in the form of decimal numbers. Let us ... Read More

Incompletely Specified Functions in Boolean Algebra

Manish Kumar Saini
Updated on 22-Aug-2023 12:23:29

1K+ Views

What is an Incompletely Specified Function? In Boolean algebra, a Boolean function or logic function whose output values are known for a subset of its inputs and has output which is a don’t care condition for at least one of its input combinations is called an incompletely specified function. Hence, in an incompletely specified function, the value of the function for don’t care combinations can be selected either a 0 or a 1 depending on the fact that which one leads to be the more minimal solution of the function. For these combinations, the Karnaugh map (K-Map) entry is marked ... Read More

Address Registers of 8257 Chip

Arnab Chakraborty
Updated on 22-Aug-2023 12:19:39

541 Views

Here we will see the address registers of 8257 chip.Every DMA channel consists an address register and a count register. These registers are 16-bits wide in length. In each 16 bits there are four ARs marked as AR3-0. Apart from four CRs there are control and status registers also. They are separate 8-bit registers, but have the same address. Here the processor can only write in the control register but we can read in the status register.We can select any one of the above registers by the address of the four pins marked as A3-0 of 8257. The processor used here ... Read More

Run JavaTuples Program in Eclipse

Amit Diwan
Updated on 22-Aug-2023 12:15:43

841 Views

Tuples in Java are an ordered collection of objects of different types. To run Tuple in Java, you need to upload an external jar file. Here, we will be using Eclipse IDE to create a new Java Project and upload the JavaTuples external jar file. The JavaTuples jar file is to be downloaded. Let us first download the jar file, create an Eclipse project and import the downloaded jar file. Here are the steps − Step 1 − Download JavaTuples Jar library and save it on your system. Open the GitHib link github.com/javatuples/javatuples/downloads and download the “javatuples-1.2-dist.zip” as shown below ... Read More

Advertisements