how to make student result sheet in excel(Make consolidated result sheet in pakistan)

how to make student result sheet in excel

Share this video:
   • how to make student result sheet in e...  

Formulas
One of the most fundamental features of spreadsheets is the ability to
perform calculations using data contained in the cells and to display the
results. This is achieved by entering formulas. A formula is entered in the
cell in which the result is to be displayed and is begun by typing =. Data is
included in a formula by using its cell reference. For example, to add two
numbers contained in A1 and B1, putting the result in C1, select C1 and in the
formula bar type ‘=A1+B1’. Confirm the formula by pressing the ENTER key.

Formatting Cells
A wide range of formats can be applied to
cells, depending on their contents. The Font
and Alignment for each cell or a range of
cells can be specified from Cells on the
Format menu.
Number from Cells in the Format menu can
be used on cells containing numbers to
specify a type of number e.g. date, currency,
decimal, percentage etc. When cells have
been formatted with a particular number type, Excel automatically performs
any necessary rounding and adds appropriate symbols (e.g. £, $, %).

The SUM Function
To add up a row or
column of numbers
(probably the most
common function
required of Excel) the
SUM function is used.
To achieve this, select
the cell in which the
total is to appear. In
the formula bar type =SUM(?:?). Replace the question marks with the
references for the first and last cells in the row or column of numbers.
Press ENTER and the total should appear.


Averages
Excel can also calculate the average of a column or row of numbers. To do
this, select the cell where you want the average to appear and in the formula
bar, type ‘=AVERAGE (?:?)’, replacing the question marks with cell
references for the first and last numbers of the column or row to be
averaged.

Subscribe our YouTube Channel:
   / @thesoftsense  

Facebook:


Google:
https://plus.google.com/u/0/111849326...

Twitter:
  / nouman86ryk1  

If you like this video so share it and subscribe our Channel now for more videos.

how to make student result sheet in excel