Page 278 - Trackpad IT-402_Class-IX
P. 278

Give answers to the following queries using functions:

        1. Total number of employees. (To be entered at B9)
        2. Lowest Salary (To be entered at B7)

        3. Highest Salary (To be entered at B8)
        4. Total leaves of PREETI (Casual Leave + Medical leave) - To be entered at E2
        5. Copy the formula entered in E2 for all other employees.

        6. Balance leaves of PREETI (Sanctioned Leaves - Total) - To be entered at G2
        7. What is the average salary of employees?

        8. Total number of Medical leaves to be entered in D9.


                FORMATTING DATA IN THE WORKSHEET


        Data in a cell without the formatting appears to be dull and non-interesting. The same data with different font types
        and sizes along with borders will make it more presentable. It will also draw attention to the important points without
        much effort.
        The Format Cells dialog box in the toolbar can be used to find more about formatting a cell or range of cell.



























        We can format the data by using any of the given ways:

        Click on Format → Cells... It will open the Format Cells dialog box as shown above.
        OR

        Use the Formatting Toolbar present just below the Standard toolbar.
        OR

        Right-click on the cell to open the Shortcut → Select 'Format Cells…' .
        The formatting of the data can be done by using some of the given tools:
        •  Font Name: It is used to change the font type to Algerian, Calibri, Century Gothic, etc.
        •  Font Size: The default font size is 10 which can be increased or decreased.
        •  Bold: It makes the selected text appear thick.
        •  Italic: It makes the selected text appear slightly tilted.


          278   Trackpad Information Technology-IX
   273   274   275   276   277   278   279   280   281   282   283