Page 310 - TP_IT_V1.0_C9_flipbpookl
P. 310

•  Average(): It returns the average of the given values. Let us find the average price of an article in the given sheet.
                =Average(D7:D11)
                OR
                =Average(D7,D8,D9,D10,D11)
                OR
                =Average(D7:D9,D10:D11)
                OR
                =Average(D7:D10,D11)

              Let us practise the formulas and functions learnt so far using the following spreadsheet.





















              Give answers of the following queries using functions:
                  a.  Total number of employees - To be entered at B9
                Ans.  B9=COUNT(A2:A6)
                  b.  Lowest Salary - To be entered at B7.
                Ans.  B7=MIN(B2:B6)
                   c.  Highest Salary to be entered in B8
                Ans.  B8=MAX(B2:B6)
                  d.  Total leaves of PREETI (Casual Leave + Medical leave) - To be entered at E2
                Ans.  E2= C2+D2
                  e.  Copy the formula entered in E2 for all other employees.
                Ans.  E3= C3+D3     E4= C4+D4     E5= C5+D5      E6= C6+D6
                   f.  Balance leaves of PREETI - To be entered at G2
                Ans.  G2=F2-E2
                  g.  What is the average salary of employees?
                Ans.  =AVERAGE(B2:B6)


                      FORMATTING DATA IN THE SHEET

              Data in a cell without the formatting appears to be dull and non-interesting. The same data with different formatting
              style will make it more presentable. Formatting data enhances the readability and visual appeal of your data, making it
              easier to interpret and analyse. By applying various formatting styles, such as adjusting fonts, colours, borders, etc. you
              can highlight important information, organise data logically, and ensure consistency throughout your spreadsheet. It
              will also draw attention to the important points without much effort. The Format Cells dialog box can be used to apply
              formatting to a cell or range of cell.




                308   Trackpad Information Technology (Ver. 1.0)-IX
   305   306   307   308   309   310   311   312   313   314   315