SEC | S20W2 | Data Analysis with Google Sheets: (Advanced Excel formulas, and pivot tables.)

Thank you @josepha and @simonnwigwe for this wonderful lesson.

Q.1-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 formulas designed to use data in Excel more efficiently. They help you perform complex tasks such as comparing data, making calculations, and making decisions based on various conditions.

• Lookup Functions:

These formulas are used to find specific information in the data. For example, the VLOOKUP formula finds the desired value in a table.

• Logical Functions:

These formulas give results based on conditions. For example, the IF formula tests whether a condition is true or false, and returns the result accordingly.

You will see advance formulas here!

I opened my spread sheet from my mobile.
I clicked on the first sell then formulas bar appeared to me.
I moved my curser on left corner below to red circle indicating the formula bar and clicked on it.

Now I can see the result here lookup and logical function both are front of me. I will choose and click that I need.

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

Recently I applied the IF Function to calculate the for sum but it can not work. It's mean this formula will never work to calculate amount.

Now I will apply Formula for Total:
=SUM(B2, C2, D2,E2)

For Average Formula:
=AVERAGE(B2:E2)

Now I will use this formula for Grade

=IF(G2>=70, "A", IF(G2>=60, "B", IF(G2>=50, "C", IF(G2>=45, "D", IF(G2>=40, "E", "F")))))

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

Greater Than (>)

It is a system that tells us which value is greater than the other. It is usually used to analyze data.

Less Than (<)

It is a system that tells us which value is less than the other.

Equal To (=)

To check the value two numbers that are equal or not.

Not Equal To (<>)
To check the value of two numbers is different from each other.

Q.4-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.

• I put all the data in Google Sheet that can be seen below 👇

• Now I go to the pivot table or search and then apply. Finally pivot table is created result in screen shot.

---

I invite to @chant, @stream4u and @patjewell to participate.

Thank You