If you need to do something precise when two or more circumstances are TRUE, you can use the IF function in grouping with the AND function to calculate conditions with a test, then take one action if the result is CORRECT, and (optionally) do something otherwise if the outcome of the test is FALSE. If … Read more
How to Delete data in excel Select the data you wish to delete, right click on that then choose delete choice from the menu. You’ll also delete it by pressing Delete key on the keyboard. See the image: How to Delete a Row Select the row by a left click on the row number … Read more
You have various choices after you need to put data in excel. You’ll enter data in one cell, in many cells at constant time, or on quite one worksheet at constant time. The data that you just enter is numbers, text dates, or times. You’ll format the data in a very style of ways that. … Read more
Select the data, right click on it then pick Copy option. Now pick the cell where you want to paste the data then right click on it and choose Paste option. After choosing the data, you can also press Control+C Key to copy and Control+V Key to paste the data. To undo the changes you … Read more
Select the cell to show the result e.g. cell E5 in the image shown below. Now put “=” sign in the cell and type “average” then press key opening parenthesis. Now select the data, cells from B5 to D5 then press the Enter key to get the average of selected data.
There are a range of methods to add up the numbers found in two or more cells in Excel. See the picture below showing the addition of 50, 40 and 60. Select the cell where you want to show the result as cell D7 in this example. Then type = sign in the cell, now … Read more
Absolute referencing assists multiply numerous values with a specific value. See the picture shown below. The Number 1 values are multiplied by 5, value of cell E5. In this case, we will use sign $ in the formula. So we have to alter the formula for that after putting the formula press F4 key. $ … Read more
Point defects Point defects describes the imperfections in solids alongside point defects types. The formation of crystalline solids takes place by connecting great numbers of crystals, smaller in size. After the crystallization process, various defects types are observed in the crystal. Point defects are calculated when the process of crystallization takes place at a pretty … Read more
Amines are basically derivatives of the ammonia compound. These derivatives are formed by the replacement of the hydrogen atoms by the alkyl or the aryl groups. The amines are basic in nature. This is because the nitrogen atom has high electron density, as it has two valence electrons in its orbital. Also, the alkyl and … Read more
Phenols are organic hydrocarbon compounds with a hydroxyl group directly attached to an aromatic hydrocarbon compound like Benzene Ring. Phenols are also termed as Phenolic compounds. The molecular the formula of phenols is C6H5O6. The synthesis of Phenols is Natural as well as artificial. Uses of phenol Phenols are compounds with a hydroxyl group attached … Read more