Greetings to my all STEEMIT members. Hopefully you all are fine and enjoying a great and best life on STEEMIT. I am also fine ALHAMDULLIAH. And Now I am going to share My homework task with you guys. I hope that you will appreciate me

So lets start our home work task. And I will try my best to share my best

Explain what you understand by Advanced Excel Formulas, and show us where advanced formulas such as the lookup function, and logical function are found in Excel with clear screenshots

Advanced Excel formulas are more complex functions and combinations of functions that go beyond simple math or basic operations like addition or subtraction. These formulas can manipulate data, perform logical tests, retrieve specific values, analyze large data sets, and automate tasks.

• Look up functions: These allow you to search for data within a specific range or table.

Examples: VLOOKUP(), HLOOKUP(), INDEX(), MATCH(), XLOOKUP().

First of all, we have to look at the home tab of Microsoft Excel. In it, we will find an option which is written Formulas. If we click on the formulas, there are many more options. One option would be lookupendal reference when we look at it it will bring up many many options so there are many options it's lookup and within the reference we use

• Logical Functions: These perform tests and return values based on whether certain conditions are true or false.

Examples: IF(), AND(), OR(), NOT().

Just like here, after we've seen that we've got another option within that, we've got the logical option, the enough option, we'll see it's the logical option, we've got the logical option, and we've If you click on that option, we will get more options in the same way, which we will do inside the list.

Write the IF Function formula to calculate the total, average score, and grade of students given in the table below

So, first of all, we will create a similar table in our excel sheet and then we will execute it through our formula according to the given things. will do and find the result, then first of all let's go then we create our own table and enter the data in it

And now we will make three more columns in which we will make one where we want to total, then one will be for total and after that we will make one for average and we will make one for grade because we want people to do this. If we have to find three things, then we will make three more columns

• Sum Formula:

We will add the numbers of one student by using the SUM formula and the SUM formula is

=SUM(A2:E2)

And the result is:

• Average Formula:

Now we will fine the average of marks of the students and we will use the AVERAGE formula. And the Formula is

=AVG(A2:E2)

And the Result is:

• Grade Formula:

Now we will fine the Grade of all students by using the Grade Formula. And the formula is
=IF(G2>=70 , "A" IF(G2>=60 , "B" IF(G2>=50 , "C" , IF(G2>=45, "D", IF(G2>=40, "E", "F")))))

And the result is:

Briefly discuss four IF function Operators that you have learned and tell us their functions and when we are to use them

The IF function in Excel is highly versatile and can be used in combination with different operators to perform logical tests. Here are four common IF function operators:

1. Equal to (=)
Function: This operator is used for the checking of two values that these two values are same or not.
When to Use
Use this operator when you want to test for equality between two values.

• THE RESULT OF EXAMPLE OF EQUAL TO FUNCTION:

2. Greater than (>)
Function: This checks if a value is greater than a specified number.
When to Use: Use this operator when you want to test if a value exceeds a specific threshold.
Example:

The result of the EXAMPLAE OF GREATER TO FUNCTION:

3. Less than (<)
Function: This operator checks if a value is less than a specified number.
When to Use: Use this when you need to check if a value falls below a certain limit.

And the Result is:

4. Not equal to (<>)
Function: This checks if two values are not equal.
When to Use: Use this operator when you want to test for inequality.
Example

And The Result is :

Based on the given data below: Create a pivot table that shows (see) total sales by product, by dragging the product to the Rows areas, Region to the Column area, and Sales to the Values area. Please we want to see the steps you take in adding your pivot table

First of all we will enter the data that we have been given in our spreadsheet and after we have entered the data we will go to the next step and our next step will be to go to the insert and then click on the pivot table . Click on the option as I show you

Here you can select the options in the way you want to analyze your data. Within the values ​​within the day and within the columns, you can select the way you want the data to be displayed. can be selected

After that we will show and after that we will click on the option of subtotal etc. so that it doesn't show us subtotal again and again.

Remove here will remove the blank lines so that we don't see the blank lines when there are blank objects. This option is used to move the data inside the center line. The data inside the cap box is Seen in the center

After that i apply border and apply center alligned to make data and table nice. So its final result