These are Microsoft Excel exercises where you can learn different formulas. The formulas used in these exercise are  SUM(), AVERAGE(), COUNT(), COUNTIF(), IF(), VLOOKUP(), HLOOKUP().

SUM() is use to calculate the sum of the range you specify. E.g. =sum(f2:f10)

Average() is use to find the average of the range you specify. E.g. =Average(f2:f10)

COUNT() is use to count the values in the given range of cells, it only counts the numeric values, e.g. =count(f2:f10)

COUNTIF() is use to count the values based on the condition, e.g. =countif(Range,Condition)

IF() is use to check the values in a cell and print the respective data based on condition, e.g =if(Condition,TRUE Value, FALSE Value)

VLOOKUP() is use to search a given value in a set of range written in vertical order.

e.g =VLOOKUP(“Value to be searched”, Where to search,Which column you want to print, Value should match or not)

HLOOKUP() is use to search a given value in a set of range in horizontal order.

e.g =HLOOKUP(“Value to be searched”, Where to search,Which row you want to print, Value should match or not)

 

1. Exercise one in Microsoft Excel Create  a Sample Bill

 

Excerise 1

2. Exercise one in Microsoft Excel Create  a Product List and use different formulas.

 

product list

3. Exercise one in Microsoft Excel Create  a Student details and use the formulas

 

 

student list