- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Introduction It can be difficult to work with large datasets in Microsoft Excel, especially when you must find accurate values from complex equations. Excel facilitates an excellent technique to speed up this handle and users may create a user-defined function in Visual Basic and invoke it in a specified cell. The UDF is an efficient way to resolve complex mathematical equations. In this article, we will learn how to determine the roots of the quadratic equation through a user-defined function. Use Visual Basic Code to Evaluate the Quadratic Equation’s Root Step 1 Open a desired worksheet and enter the following ... Read More
Excel is a priceless tool when it comes to organizing and analyzing data. The let function is one such function that enables us to carry out calculations based on circumstances. While users mostly rely on it for data analysis and calculations, many overlook an underutilized feature that can greatly enhance readability, productivity, and decision- making capabilities. In this article, we will explore the fundamental concept of the Let function which is available only in Excel 365. Users can specify parameter names to the values through this function, and these parameters will be used in the generated formula much like in ... Read More
Introduction Numerous user-friendly functions are introduced in Excel 365 that boost the expert knowledge and improve their productivity. In this article, we will understand the concept of the LAMBDA function in Excel. Before implementing this function, users may either install Office 365 or use the trial version on the web. With the help of the LAMBDA function, users may develop a custom function and regenerate the function across worksheets. The following key points need to be considered while creating the Lambda function − Create the lambda function in the cell. Verify and test the lambda function. Use the Named ... Read More
Introduction In this type of article, we may go to create the data using the LAMBDA() function to check if the value can be absent and it may return true or false. The users have to use the LAMBDA() function that will check the missing value. If the value is not missing, it displays value 0. This method may be completed utilizing a straightforward way within Microsoft Excel 365 by using the LAMBDA function. This function is only not available in the older version of Excel. Isomitted Function The ISOMITTED function is utilized to check if the value is absent, ... Read More
Introduction VBA is a crucial component of Microsoft Excel that facilitates users to develop the function and subroutine that can be executed in the Excel worksheet. The value would be retrieved by the user-defined function and given to the specific cells that call it. Users must employ the indentation in the VBA code to enhance the readability of the code. In this article, we will explore the efficient techniques for calculating the area of a triangle and comparing values. Cell formatting is not done by the user-defined function. To Generate the User Defined Function to Compute the Area of the ... Read More
Using with 3d transforms, we can move element to x-axis, y-axis and z-axis. The following are some of the methods of CSS3 3D Transform − S.No. Value & Description 1 matrix3d(n, n, n, n, n, n, n, n, n, n, n, n, n, n, n, n)Used to transforms the element by using 16 values of matrix 2 translate3d(x, y, z)Used to transforms the element by using x-axis, y-axis and z-axis 3 translateX(x)Used to transforms the element by using x-axis 4 translateY(y)Used to transforms the element by using y-axis ... Read More
Inline-level elements have their CSS display property set to either ‘inline, ‘inline-table’, or ‘inline-block’ and these elements do not force a line break above and below themselves. Inline-level boxes are generated by each inline-level element which is a part of the positioning scheme as well as contains child boxes. Inline boxes are boxes which have their content follow inline formatting context. Inline boxes are split into a number of inline boxes whilst those inline boxes that are never split are called atomic inline-level boxes. Anonymous inline boxes are those boxes over which developer has no control. If a block box ... Read More
Adding CSS to an HTML document enhances the appearance of the web page. Various styles for the images, borders, margins, colors, can be easily added. To include CSS in HTML documents, we can either include them internally, inline or link an external file. Let us understand them with examples. Syntax The syntax for including CSS files in HTML is as follows − /*inline*/ /*internal*/ /*declarations*/ /*external*/ The following examples shows the linking of CSS file ... Read More
Import additional CSS files inside another CSS declaration. The @import rule is used for this purpose as it links a stylesheet in a document. This is generally used when one stylesheet is dependent upon another. It is specified at the top of the document after @charset declaration inside . With that, the element can also be used. Syntax The syntax of @import rule is as follows − @import /*url or list-of-media-queries*/ The media queries can be compound statements which may specify the behaviour of the document in different media. Import external stylesheets with @import rule The following ... Read More
The zoom an element on hover, use the :hover selector. The scale() method of the transform property is used to zoom i.e. scale an element. The transition duration is set using the transition property. Let us see how to zoom/ scale an element on hover with HTML and CSS. Scale a circle To scale a circle, first, we have set a div − The transition for the div is set using the transition property − .zoomDiv { padding: 50px; background-color: yellow; transition: transform 0.2s; ... Read More