easyMultiple SelectObjective-mapped
Generative AI Leader Practice Question: A data analyst wants to use Gemini for Google…
A data analyst wants to use Gemini for Google Workspace to assist with Sheets. Which two capabilities does Duet AI in Sheets provide? (Choose TWO)
⚠ Common exam trap
Many exam-takers confuse Duet AI's formula suggestion capability with broader automation features like custom scripting or image-based chart creation, which are not supported in the current Duet AI for Sheets implementation.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Generate formula suggestions based on natural language descriptions
Duet AI in Sheets can interpret natural language descriptions of desired calculations and automatically generate the corresponding formula. This leverages Gemini's language understanding to translate user intent into spreadsheet functions, significantly reducing the need to manually recall or construct complex formulas.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Generate formula suggestions based on natural language descriptions
Why this is correct
Users can describe what they want, and Duet AI suggests the formula.
- ✓
Classify and tag data in columns automatically
Why this is correct
Duet AI can detect data types and suggest classifications.
- ✗
Apply conditional formatting rules based on patterns
Why it's wrong here
Conditional formatting is a standard manual feature, not Duet AI.
- ✗
Create charts from images pasted into the sheet
Why it's wrong here
Chart creation from images is not a Duet AI Sheets feature.
- ✗
Write custom Apps Script code automatically
Why it's wrong here
Duet AI does not generate Apps Script code; it assists with formulas.
Go deeper
Related to this question
About these practice questions
This Generative AI Leader question is part of Courseiva's 683-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This Generative AI Leader practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Generative AI Leader exam.