Remainder
Source: This question is taken from the Microsoft Excel MCQs
Formula
Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024
Searches for a value in the column
Source: This question is taken from the Canal Patwari (BS-11) Irrigation ppsc past papers
COUNT
To add up a range of cells
Source: This question is taken from the Assistant director (Bs-17) local government & community development department PPSC 2024
To perform a vertical lookup and return a value based on a specified criteria
MAX
AVG
Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024
To find a value in a table based on a matching value in the first column
To perform a logical test and return a value based on the result
Source: This question is taken from the Assistant BS-16 & Junior Clerk BS-11 Agriculture Department
Source: This question is taken from the Junior Clerk Deputy Commissioner Office BOR