Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
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
Media Queries are used on a web page to set the responsiveness. It allows a user to set different styles based on different screen sizes. These screen sizes are mainly desktop, tablet, and mobile devices. Let us first set the different screen sizes i.e., where we will set the common device breakpoints. Different screen sizes The common device breakpoints are the different devices with its screen size i.e. Phones − Screens less than 768px wide Tablets − Screens equal to or greater than 768px wide Small laptops − Screens equal to or greater than 992px wide Laptops and Desktops ... Read More
The Google Font is a free font service for computer and web. It launched in the year 2010 and owned by Google. In 2021, open-source icon support was added. It includes 1, 576 font families that includes 352 variable font families. The official website of Google Font is fonts.google.com. Just like the Font Awesome icons, the Google Fonts are added to a website using the element. Let us see how to add and use Google Font on a web page. Features Easily insert Google Fonts on your web page It is having more than 1k font families While ... Read More