Ques:- What you can do in a excel ? Give some formulas ?
Right Answer:
In Excel, I can perform various tasks such as data entry, data analysis, and creating charts. Some common formulas include:
1. **SUM**: `=SUM(A1:A10)` - Adds all numbers in the range A1 to A10.
2. **AVERAGE**: `=AVERAGE(B1:B10)` - Calculates the average of numbers in the range B1 to B10.
3. **COUNT**: `=COUNT(C1:C10)` - Counts the number of cells with numeric entries in the range C1 to C10.
4. **IF**: `=IF(D1>100, "High", "Low")` - Checks if the value in D1 is greater than 100 and returns "High" or "Low".
5. **VLOOKUP**: `=VLOOKUP(E1, A1:B10, 2, FALSE)` - Looks for the value in E1 within the first column of the range A
In Excel, I can perform various tasks such as data entry, data analysis, and creating charts. Some common formulas include:
1. **SUM**: `=SUM(A1:A10)` - Adds all numbers in the range A1 to A10.
2. **AVERAGE**: `=AVERAGE(B1:B10)` - Calculates the average of numbers in the range B1 to B10.
3. **COUNT**: `=COUNT(C1:C10)` - Counts the number of cells with numeric entries in the range C1 to C10.
4. **IF**: `=IF(D1>100, "High", "Low")` - Checks if the value in D1 is greater than 100 and returns "High" or "Low".
5. **VLOOKUP**: `=VLOOKUP(E1, A1:B10, 2, FALSE)` - Looks for the value in E1 within the first column of the range A