Sequat, sagittis nulla at, sollicitudin lorem. Orci varius natoque penatibus et magnis dis partures ient montes.Great websites add great values to your business. From wire-framing to consectetu designing, we do it all.
A cell address is used to identify a particular cell on a worksheet. It is denoted by a combination of the respective column letter and a row number.Â
As shown above, the highlighted cell belongs to the column ‘D’ and row 5, so the cell address is read as D5.
Relative cell referencing | Absolute cell referencing |
In Relative referencing, there is a change when copying a formula from one cell to another cell with respect to the destination. cells’ address | Meanwhile, there is no change in Absolute cell referencing when a formula is copied, irrespective of the cell’s destination. |
This type of referencing is there by default. Relative cell referencing doesn’t require a dollar sign in the formula. | If you don’t want a change in the formula when it’s copied across cells, then absolute referencing requires you to add a dollar sign before and after the column and row address. |
 |  |
Freeze panes keep the rows and columns visible while scrolling through a worksheet. To freeze panes, select the View tab and go to Freeze Panes.
If you are looking to freeze the first two columns of a dataset, select the 3rd column, and click ‘Freeze Panes’. A thick grey border indicates this.
1. First, choose the data you want to protect.
2. Hit Ctrl + Shift + F. The Format Cells tab appears. Go to the Protection tab. Check Locked and click OK.
3. Next, go to the Review tab and select Protect Sheet. Enter the password to protect the sheet.Â
The formula is like an equation in Excel, the user types in that. It can be any type of calculation depending on the user’s choice. | Whereas, a function in Excel is a predefined calculation which is in-built in Excel. |
Manually typing out a formula every time you need to perform a calculation, consumes more time. Ex: = A1+A2+A3 | However, performing calculations becomes more comfortable and faster while working with functions. Ex: = SUM(A1:A3) |
The order of operations in Excel is referred to as PEDMAS. Shown below is the order of precedence while performing an Excel operation.Â
As seen above, first, the data in the parentheses is operated, followed by the exponentiation operation. After that, it can be either the division or multiplication operations. The result is then added and finally subtracted to give the final result.
To write a formula for the above-stated question, we have to follow the PEDMAS Precedence. The correct answer is ((A1*10)+5)/2.
Answers such as =A1*10+5/2 and =(A1*10)+5/2 are not correct. We must put parentheses brackets after a particular operation.Â
The output will look like this:
The count function is very often used in Excel. Here, let’s look at the difference between count, and it’s variants – counta and countblank.Â
It counts the number of cells that contain numeric values only. Cells that have string values, special characters, and blank cells will not be counted. Shown below is an example of the count function.
It counts the number of cells that contain any form of content. Cells that have string values, special characters, and numeric values will be counted. However, a blank cell will not be counted. Shown below is an example of the counta function.
As the name suggests, it counts the number of blank cells only. Cells that have content will not be taken into consideration. Shown below is an example of the countblank function.
The filter mechanism is used when you want to display only specific data from the entire dataset. By doing so, there is no change being made to the data. The shortcut to add a filter to a table is Ctrl+Shift+L.
Hyperlinks are used to navigate between worksheets and files/websites. To create a hyperlink, the shortcut used is Ctrl+K.
The ‘Insert Hyperlink’ box appears. Enter the address and the text to display. Here, we are directed to the Amazon Website.
Contact us at the Consulting WP office nearest to you or submit a business inquiry online.
With MCQ Practice and Doubt Clear Sessions.
Data Scientist AI ML
Data Analytics Head
Lead Data Scientist
FullStack Developer
