Excel
- If marks in cell B2 are greater than or equal to 35, then show “Pass” otherwise “Fail”.
- If age in cell A2 is 18 or above, then display “Eligible” otherwise “Not eligible”.
- If revenue is greater than cost, then show “Profit” otherwise “Loss”.
- If value is greater than 0, then display “Positive” otherwise “negative”.
- If marks is greater than 90 display grade as “A”,if marks > 80, “b”, if marks > 70, “c”, if marks >60, “d”, if marks >50, “d” otherwise “fail”.
- If employee salary is less than 20,000 then show commission 5%, if salary is less than 50,000 then show 10%, otherwise 15%.
- If an employee’s leave is more than 2 days, the salary should be deducted, otherwise they should receive their full salary.
- If there are two values, and the sum of those two values is greater than 1000, then a 10% calculation will be applied; otherwise a 5% calcualtion will be applied.
If the two values are 600 and 500, what percentage calculation will be applied? - If A is greater than B, it should display “A greater”, if B is greater than A, it should display “B greater”, otherwise it should display “Equal”.
- If Account No. 1 is the same as Account No. 2, it will show “match”, otherwise it will show “doesn’t match”.
- If the person has a visa, has a passport, and the ticket amount is more than 35,000 then it will show “Eligible”, otherwise it will show “Not Eligible”.
- If both values are greater than 50, it will show “yes”, otherwise it will show “no”.
- If either of the two values is greater than 2600, it will display “Qualified” otherwise the cell will remain blank.
- If the department is either Finance or Operational and the salary is greater than 15,000 it will show “Selected” otherwise it will show “Not Selected”.
- If the salesman has sold all three items (LED,LCD, and Speaker) for more than 50,000 each, he will get 12% commission otherwise, it will show “Work Hard”.
- Find an employee’s salary based on their ID number using formula of VLOOKUP.
- How do you use VLOOKUP to search for a student’s grade from a table of marks?
- How can you use VLOOKUP to retrieve data from another worksheet?
- Find an employee’s leave based on their ID number using formula of HLOOKUP.
- Count how many times the word “Apple” appears in a list of fruits using formula of COUNTIF.
- Sum the marks of students who scored more than 70 using formula of SUMIF.
- Sum sales where the product is “laptop” and the region is “East” using formula of SUMIFS.
- Sum sales where the color is “RED” and the name is “Ansh” using formula of SUMIFS.
- Count the number of students who scored more than 70 and belong to class A using formula of COUNTIFS.
- Write a formula to count sales that are greater than 1000 and where the region is “East.”
- Find the largest number among three values A,B,C using formula of nested IF .
- Apply a filter on a data to display only the rows where the “Department” column is equal to “Sales”.
- How can you use the Filter feature to show only the students who scored more than 80 marks?
- Convert (transpose) data from vertical to horizontal format using a keyboard shortcut.
- If A is greater than B, then multiply both values otherwise add.
- If A is greater than B, then return the value of A otherwise return the value of B.
- You have purchased a bike with the following details:
- Item: Bike
- Loan Amount: 150,000
- Down Payment: 30,000
- Interest Rate: 10% per annum
- Loan Period: 3 years
- EMI (Equated Monthly Installment)
- IPMT (Interest portion of the payment for each period)
- PPMT (Principal portion of the payment for each period)
33. If an employee’s location is Patiala and the salary is greater than 15,000 then display Selected otherwise, Not Selected.There are four columns: Name, Location, Salary, and Selection.
34.Create an attendance sheet. The sheet should record daily attendance for employees as Present (P), Absent (A), Half Day (HD), and Leave (L).
Calculate the total number of Present, Absent, Half Days, and Leaves for each employee.
35. How to calculate the sum of values from different cells using a keyboard shortcut by holding the Ctrl key.
