MS Excel Practice Data
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
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