MASTERING MS EXCEL FORMULA 

IMPORTANT FORMULA 


Basic Arithmetic Formula Used in MS EXCEL

=SUM(range): Adds all numbers in a specified range.


=AVERAGE(range): Calculates the arithmetic mean of a range.

=MAX(range) This is used for Highest Value

=MIN(range): lowest value in a dataset.


Counting Data

=COUNT(range): Counts only cells that contain numbers.

=COUNTA(range): Counts all non-empty cells (includes text, numbers, and symbols)

 

Important Formula

=VLOOKUP 

Searches for a value in the first column and

returns a value from another column in the same row.

 

 

  

Comments

Post a Comment

Popular posts from this blog

  Commonly Used Shortcuts in MS OFFICE WORD  Ctrl + N: Create a new document. Ctrl + O: Open an existing document. Ctrl + S: Save the current document. Ctrl + Z: Undo the last action. Ctrl + Y: Redo the last action. Ctrl + P: Open the Print window. Ctrl + W: Close the active document. BEST OFFICE VERSION- 2021 AND 2024 VERSION
Read more
  Expert Strategy for Clerk Reasoning Preparation To clear the  clerk exam cutoff , you need a blend of speed and accuracy. Here is how to tackle the questions and find good answers by comparing the values    Focus on these type of questions and try to solve them daily 05 questions.   Statements: ·          Only a few Apples are Oranges. ·          All Oranges are Bananas. ·          No Banana is a Mango. Conclusions: I. All Apples can never be Mangoes. II. Some Oranges are not Mangoes.   Statement: P ≥ Q > R < S ≤ T; R = U ≥ V Conclusions: I. P > U II. T > V ONE VALUE IS BIG, ANOTHER IS SMALL COMPARE VALUES  Coding-Decoding (Pattern-Based) In a certain code language: ·          "study hard get job" is written as "ka pa ra ta" ·     ...
Read more