criteria; Select Operator as “AND” Select Field name as Class Select Condition as = Type or select Value as XII- H2 Figure . Standard Filter Chapter Step : Click “OK” Now, the table displays only the recods which are match for the given two criteria. Refer Figure . .
Remove Standard Filter: Select Data → Filter → Remove Filter Figure . Class XII student of group Figure . Page Style dialogue box “Header” tab is used to create header “Footer” tab is used to create footer Chapter . Setting the page size, Orientation and Margins To set page size, select Format → Page Page style dialoge box will appears as shown in figure .
. “Page” tab is used to change page size, orientation and margin “Header” tab is used to create header “Footer” tab is used to create footer Workshop . Create a worksheet with following data Emp. No Name of Emp.
Basic DA HRA CCA MA GPF IT HF Manivannan M 25500 % of Basic % of Basic and DA % of Basic % of Gross Kannan K 20200 Gowrishankar N V 24300 Lenin K 23400 Suryanarayanan T 24100 Ramesh K 18500 Govindasami A 13200 Kannan S 20250 Penchil Rao K 28300 Logeswaran M 30200 Arumugam E 12000 Vasu G N 25000 Based on the above data, ( ) Calculate the Gross Salary, Total Deductions and Net Salary ( ) Insert “IT Cess” column and calcualte % of cess to all employees Chapter . Setting the page size, Orientation and Margins To set page size, select Format → Page Page style dialoge box will appears as shown in figure . . “Page” tab is used to change page size, orientation and margin “Header”