Set 44 Practical Question

⭐ Q44 – Employee Spreadsheet (Count + Filter + Salary > 5000 + City Filter)

Example Code (Read Only):


=COUNTIF(C:C,"HR")
Data → Filter → Standard Filter
Dept = "MD"
3. List Name + Dept where Address = Chandigarh
Filter:
Address = "Chandigarh"
Filter: Dept = "TRG"

M1 - MS Office Practical

Open Office Online

Open Word Online Open Excel Online Open PPT Online

Sample Files

Download .docx Download .xlsx Download .pptx

Upload Your Practical File