Mastering Microsoft Excel with Copilot

What is required to access Copilot in Microsoft Excel?

• A Windows operating system

• An internet connection

• A standalone Excel license

• A Microsoft 365 subscription

What function does Copilot suggest using to fill in prices in a spreadsheet?

• HLOOKUP

• XLOOKUP

• VLOOKUP

• INDEX

How does Copilot help in cleaning data?

• By highlighting errors

• By merging duplicate entries

• By deleting unnecessary rows

• By separating and formatting columns

What feature does Copilot use to highlight rows with a profit margin exceeding 50%?

• Data Validation

• Conditional Formatting

• Data Bars

• Color Scales

Which tool does Copilot use to summarize data by region?

• Chart

• Data Table

• Graph

• Pivot Table

What new capability does Python integration bring to Excel?

• Creating macros

• Exporting to PDF

• Generating word clouds

• Running VBA scripts

How does Copilot assist in analyzing customer feedback?

• By deleting negative feedback

• By translating feedback

• By generating a word cloud

• By sorting feedback alphabetically

What is the purpose of the Copilot Prompt Gallery?

• To provide sample prompts for using Copilot

• To display recent Excel updates

• To manage Excel add-ins

• To store user-generated prompts

Which of the following is NOT a feature of Copilot in Excel?

• Explaining formulas

• Creating a drop-down menu

• Adding a total row

• Baking cookies

What is the benefit of using Copilot in Excel?

• It replaces the need for Excel training

• It is only available on Mac

• It requires no internet connection

• It automates repetitive tasks