HR Executive

The role of an HR Executive within the PPHI (People’s Primary Healthcare Initiative) framework is a cornerstone of public sector efficiency in Pakistan. Mastering this domain is not merely about understanding administrative workflows; it is about grasping the delicate intersection of human resource management and public health delivery. For aspirants targeting competitive examinations—including SPSC, HEC-conducted tests, and specialized recruitment drives—this subject represents a high-weightage area where theoretical HR principles meet real-world organizational governance. At Professional Academy (MM Online), we recognize that success in these exams requires moving beyond rote memorization. Candidates must develop a nuanced understanding of recruitment policies, grievance handling, performance appraisal systems, and the legal frameworks governing healthcare personnel. Our curated quiz is designed to challenge your analytical reasoning and test your grasp of the regulatory nuances that define the PPHI structure. To excel, do not simply focus on definitions. Instead, prioritize the application of HR strategies within a resource-constrained public sector environment. Analyze how policy decisions impact frontline health service delivery, as examiners frequently prioritize scenario-based questions that test your problem-solving capabilities. This assessment serves as a strategic diagnostic tool, highlighting your proficiency gaps and refining your readiness for the actual examination. Engage with these questions with precision, as they mirror the complexity and professional rigor expected of a high-performing HR professional in the modern Pakistani civil service.

Practice questions

SUM formula in Excel calculates:
- Average
- Total of selected numbers
- Maximum
- Minimum
Conditional formatting is used to:
- Format all cells same
- Highlight specific conditions
- Delete cells
- Insert row
Pivot table helps in:
- Printing only
- Summarizing & analyzing large datasets
- Recruitment
- Payroll deduction
Mail merge in Word is used for:
- Email only
- Sending letters to multiple recipients
- Graphs
- Formatting only
Excel filter helps to:
- Delete data
- Show only specific rows based on criteria
- Copy
- Format
Data validation prevents:
- Errors
- Invalid data entry
- Formatting
- Sorting
VLOOKUP in HR can be used to:
- Recruitment
- Find employee data from a table
- Payroll calculation only
- Attendance sheet
Protect sheet ensures:
- Auto formatting
- Prevents unwanted changes
- Delete all
- Print
Excel chart helps in:
- Salary only
- Visual representation of data
- Recruitment only
- Leave
Freeze panes helps in:
- Salary
- Keep headers visible while scrolling
- Filter
- Pivot table
Word table is used for:
- Graph
- Structured data representation
- Formula only
- Mail merge
Track changes in Word helps:
- Delete text
- Review edits by multiple users
- Merge mail
- Format
Find & Replace in Word:
- Finds only
- Finds and replaces text
- Deletes page
- Prints
Data sorting in Excel helps:
- Delete
- Organize data ascending/descending
- Filter
- Mail merge
HR can use Excel to track:
- Media only
- Attendance, payroll & leave
- Patients only
- Marketing
Word templates help in:
- Data analysis
- Standardizing letters & reports
- Payroll calculation
- Leave
Formula for average salary:
- =SUM()
- =AVERAGE(range)
- =COUNT()
- =MAX()
Protect document ensures:
- Open to all
- Prevents editing by unauthorized users
- Printing
- Mail merge
Conditional formatting can highlight:
- Salaries > threshold
- Attendance < standard
- Both A & B
- None
Excel sheet linking is used to:
- Merge mail
- Track only
- Connect multiple sheets for calculations
- Filter