MS Excel Practice Data

03:45 0 Comments A+ a-

Here is the file and images which will make you familiarize with components and tools of MS Word...

Use Following Formulas to Make the Following Worksheets:
For Sum :  Write =sum(the cell name from which we want sum : to cell name at end)
For Max value in a column or row: 
              =max(the cell name from which we want sum : to cell name at end)
For Minimum value in a column or row: 
             =min(the cell name from which we want sum : to cell name at end)
For Average value in a column or row:
             =average(the cell name from which we want sum : to cell name at end)
For Multiplication of two cells:  =(cell 1 * cell 2)
For Division of two cells:  =(cell 1 / cell 2)
For Calculating Total Sales:  Total Sales = (Unit cost+Unit Profit)*Units Sold

Note:(The Assignment in link has formulas in related cells...)               


MS Excel Manual