Found 1163 Articles for Computers

Binary Space Partitioning

Tapas Kumar Ghosh
Updated on 20-Apr-2023 12:28:26

6K+ Views

A binary space partition is a data structure used in computer graphics and algorithmic geometry to divide a space into smaller parts. BSP was developed in the environment of 3D computer graphics. BSP includes applications such as operation with geometrical shapes, geospatial, and ray tracing. It is a two-step procedure Step 1 − Creation of BSP tree. Step 2 − Display a tree. Creation of BSP tree Visual Representation of Binary Space Partitioning The binary Space Partitioning algorithm recursively divides the space into two half-spaces. So keep in account that there is a dividing region in every polygon figure. ... Read More

Difference Between Bacterial Computing and Computers

Vineet Nanda
Updated on 17-Apr-2023 17:44:30

359 Views

The technological revolution has caused computers to literally evolve. It would appear that computers have taken over every aspect of our lives. There have been other non-economic factors in the past that have contributed to the computer's rise to prominence. While the primary function of early computers was calculation, this is now the least essential function of modern computers. Electronic digital computers were first developed for the sole purpose of solving equations. In order to get more done in less time, humans drove the development of computers. As the IT industry is concerned about the rise of mobile devices like ... Read More

Difference Between TN and PVA Panels

Md. Sajid
Updated on 17-Apr-2023 17:16:41

478 Views

PVA (Patterned Vertical Alignment) and TN (Twisted Nematic) are two kinds of LCD (Liquid Crystal Display) technologies used in the manufacture of computer monitors and televisions. TN panels are less expensive and have faster response times, but they have limited viewing angles and color reproduction. PVA panels provide greater color accuracy and wider viewing angles but are slower and more expensive. Read this article to find out more about TN and PVA panels and how they are different from each other. What are TN Panels? TN panels are less expensive to manufacture and have faster reaction times, which makes them ... Read More

How to highlight rows based on date in Google sheet?

Namita Aggarwal
Updated on 17-Apr-2023 15:12:53

2K+ Views

In the article, the user will understand the process of highlighting the rows that contain date-type data within the Google sheet. There are several features available in the Google sheet such as conditional formatting, cell formatting, and many other features by using which users can perform the same required tasks. This article guide contains two examples, both the provided examples will allow the user to understand the way to handle the provided date data type effectively and efficiently. Both the provided examples are precise and accurate. To highlight rows that contain date-type data in the Google sheet: Example 1: ... Read More

How to handle if cell contains a word, then put a text in another cell?

Namita Aggarwal
Updated on 17-Apr-2023 15:07:56

2K+ Views

Excel is a famous spreadsheet-based tool, used to manipulate and process available data. For this provided scenario, the user needs sample string data, to check the presence of the required string. To solve the provided problem statement, the user needs to create a formula by using the search function. The search function will allow the user to search some specific data from the provided cell value, and to generate the results according to the presence and absence of data. Example 1: To handle a cell that contains a word, by putting data text in another cell by using the user-defined ... Read More

How to get the same or first day of next month on a given date in Excel?

Namita Aggarwal
Updated on 17-Apr-2023 15:06:55

2K+ Views

This article briefs learners about the way to generate the same or the first day of the next month from the provided date in Excel. This article contains a stepwise explanation for both the discussed practices. The first example allows the learner to obtain the same-day date of the next month, this means if they pass “12-03-2023” as input then the generated output will be “12-05-2023”. Next example, allow leaner to get the first day of next month. This simply means if the input date “15-04-2023” then the generated output should be “01-05-2023”. Example 1: To get same day of ... Read More

How to get subtotals based on invoice number in Excel?

Namita Aggarwal
Updated on 17-Apr-2023 15:05:35

1K+ Views

Calculating the subtotal of an invoice is an important component of an invoice. It allows the user to understand the total amount after putting in the total invoice amount. In this article, the learner is guided through the process of generating a subtotal of the provided invoice number. For example, if invoice 101 has three entries of 100, 200, and 300, then the calculated subtotal amount will become 600. In this article, the user implements the Subtotal value by using the formula, method. Example 1: To get subtotals based on invoice numbers in Excel by using the formula: Step ... Read More

How to get row or column letter of the current cell in Excel?

Namita Aggarwal
Updated on 17-Apr-2023 15:04:44

5K+ Views

Excel spreadsheet store data in table format. Every Excel sheet is made up of rows and columns. Rows are the horizontal record fields available in the Excel sheet. On the other hand, columns are the vertical record fields available in the Excel sheet. Row address values are represented by using numbers. While column data values will be represented by using the alphabet. Since row data is represented by using numbers, therefore, they are required to be get converted into an alphabet value. While column data is already available in the form of letters. Example 1: To get row letter ... Read More

How to get month from week number and year in Excel?

Namita Aggarwal
Updated on 17-Apr-2023 15:03:19

31K+ Views

This article briefs learners about the way to generate the month-from-week number and year in Excel. This article describes two strategies to achieve the required task. The first example guides the learner to use the predefined methods, in the form of user-defined formulas. The second method guides the learner about the use of VBA code. Please note that VBA is a programming language that can work only when written properly within a proper format. This article contains stepwise explanations for both the discussed practices. Example 1: To get month from week number and year in Excel by using the formula: ... Read More

How to get the current workbook name in Excel?

Namita Aggarwal
Updated on 17-Apr-2023 15:01:16

421 Views

A workbook is a type of document used to organize and manage data or information in a structured format. MS Excel is also an example of a workbook. It is categorized as a software application used to process and manipulate data. This tutorial provides two examples to obtain the current workbook name. The first method is based on the use of VBA code. This method allows the user to define a module, to obtain the required output. On the other hand, the second method is based on the use of Kutool plus extension. Example 1 − To obtain the current ... Read More

Advertisements