4.) If you have a list of numbers in cells B2 through B20 and you wanted the average of these numbers, what would be the formula? 5.) Assume you are copying cell A1 to cell C3. If cell A1 contains the formula =$B1+$C$1, how would this formula change when copied to cell C3? PLS ANSWER ALL THIS QUESTIONS NO NEED TO EXPLAIN follow up question earlier

So which of the following above is the correct answer a,b,c or d?

Please complete the exercise as instructed and do not use global variables. Thank you!

PQ TT FT TF FF The definition of "P if and only if Q" (abbreviated Piff Q and symbolized as or ) is defined to be". Construct a truth table to show that "iff" means the same thing, as "has the same true value as". Be sure the explain how the truth table helps you answer this question.

The Python code for step 7 is needed. Step 6 has been attached for data reference

In python don't import libraries

What's wrong with this cell?

- Find all employees who makes more than that all SALESMEN make - Delete all the employees in the department that has less than 3 employees

Please label each part!!

COLLEGE (CollegeName, ZipCode, CarnegieClass)LECTURER (LectureID, Name, Email, PhoneNumber)EXPERTISE (TopicOfExpertise, LevelOfExpertise, LecturerID)CONTRACT (ContractDate, CollegeName, LecturerID, Salary)ZIP (ZipCode, City, State) Also assume that there are frequent queries involving the following information:a. List of colleges sorted by zip code.b. Access to information on a specific lecturer—their name, email address, and phone number.c. List of lecturers sorted by their area of expertise and within each area of expertise, their expertise level.d. List of colleges sorted by their CarnegieClass and within the CarnegieClass by zip code.e. Access to information on a specific lecturer based on their email address. For each situation above, specify the types of index(es) you would recommend. Justify your decisionsbased on the given relational model.