All Formula of MS Excel

      All Formula of MS Excel    

  1- Total = SUM(Range)

  2- Average = Average (Range)

  3- Percentage = Part/Whole

  

  1- Count (Number) = count(range)

  2- Count ( Number and texts) = counta(range)

 3- Count (Blank cells) = countblank (range)

 4- Count (condition) = countif(range,criteria)


         1-VLOOKUP - Vertical lookup

 = vlookup(lookup value, table array, column index number, range lookup)

Comments

Post a Comment

Popular posts from this blog

Self Introduction Practice

Communicative English Self Introduction Practice 1:- Greetings :- Good morning Sir/ Madam 2:- Name & Place :-                        I am Sishupal Mirdha       OR.          My Name is Sishupal Mirdha                        I am from Bargarh       OR.           I belongs to bargarh 3:- Qualifications :-  I have completed my Matriculation in the year 2010 from Laxmi Narayana High school, Nuagarh and I have completed my +2 in the year 2014 from Kamgaon Junior College, Kamgaon. and I have completed online training youth4jobs in the year 2020 from Youth4jobs Foundation Bhubneswar. and I am Continuing/taking online training at/ from grow center dr. Reddy's foundation bhubneswar. I am simple honest and hardworking boy in my school college time. 4:- Family Details:-     ...
Read more

Aptitude Test-1

  Aptitude Test-1   1. Question: Multiply 38.639×2.08.                         Answer: 38.639                × 2.08              ----------------               309112               00000             77278            -------------------             80.36912 Answer is : 80.36912  2. Question: Divide 2747÷ 16 Answer:                         16| 2747 |171.6875                   | 16      |               --------------------                     114         ...
Read more

What is Pivot Table ?

  What is Pivot Table ?       Pivot table is a systematic table which counts all data like sum, average, counts and many more.     We can change row date to column and also column dates to row.     We can summarise large mount of dates into small spce.     Steps to create a pivot table  --> Open WPS office app + Ss Bs  --> Write some datas  --> Now select all datas  --> Then go to insert tab  --> Then click pivot table  --> Then click ( done ) option  --> Now new window will open  --> You can see 3 fields  --> Then click and drag one by one field according to our recruitment  --> Finally click Export option  
Read more