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

