POP QUIZ!Quiz: Intermediate Sheets Functions | Question 3Note: Make sure to put your answer in all capital letters (e.g. AVERAGE). Use functions from Google Sheets Functions 2023What function would you use to add up all sales made by employee John Doe?

POP QUIZ!Quiz: Intermediate Sheets Functions | Question 4Note: Make sure to put your answer in all capital letters (e.g. AVERAGE). Use functions from Google Sheets Functions 2023What would you use to highlight all cells that are above the average value in the column?

POP QUIZ!Quiz: Question 1Note: Make sure to put your answer in all capital letters (e.g. AVERAGE). Use functions from Google Sheets Functions 2023What function would you use to find how many times "John Doe" appears in a column with assorted names?

Which of the following functions can be used to calculate the total income received by all of the AI companies as displayed in cell C15?(1)Group of answer choices=SUM=COUNT=AVERAGE=TOTAL

Question 3You are working on the sales data for office desks and want to calculate the total profits for the year 2020. What function would you use to calculate the total profits, which are located in the cell range B2 to B220?1 point= TOTAL (B2 : B220)= B2 + B220= B2 : B220= SUM ( B2 : B220)

Explain the functions used for Calculating the following for a Column in MS-Excel:  a)Averageb)Total b)Minimum c)Maximum[5]