MCQs > IT & Programming > Google Sheets > Consider the four columns in a Google Sheets spreadsheet having titles colA, coIB, coIC and coID respectively. If you want to execute a query on these columns having a group by clause, then what will be the correct syntax for the query?

Google Sheets MCQs

Consider the four columns in a Google Sheets spreadsheet having titles colA, coIB, coIC and coID respectively. If you want to execute a query on these columns having a group by clause, then what will be the correct syntax for the query?

Answer

Correct Answer:

=QUERY(Sheet1!1:1000,"select colD,max(colC) group by colD")

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Google Sheets Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

More Google Sheets MCQ Questions

search

Google Sheets Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it