Artificial intelligence features in software tools

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. Copilot in Excel is an example of which kind of feature?

A An AI feature built into a software tool

B A separate hardware device you plug in

2. You type 'Which subject has the highest average mark?' into a spreadsheet assistant. What is this called?

A A natural-language question

B A formula error

3. A spreadsheet assistant suggests =AVERAGE(B2:B9) after you describe what you want. What is it doing?

A Suggesting a formula

B Deleting your data

4. After you select your data, the software suggests a column chart and a line chart. This is called:

A Data validation

B Chart suggestions

5. A tool scans your sales data and tells you 'Sales peak every December'. This is an example of:

A Manual sorting

B Automated insights

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Copilot in Excel		AAI features are built into many everyday tools, such as spreadsheets, word processors and presentation or search software, not just Excel.
2Analyze Data / Ideas		BRecommended Charts
3A natural-language question lets you ask about your data in plain English instead of writing a formula.		CA built-in AI assistant that can suggest formulas, build charts and answer questions about the data in your spreadsheet.
4A chart suggestion feature recommends a chart type that suits the selected data.		DWhich student scored the highest Maths mark?
5Copilot's suggested formula was pasted in and used without checking the result.		EAI suggestions can be wrong, so the output must be checked against the data, for example with a hand-calculated answer, before it is trusted.
6Built-in AI features only work in Excel and cannot suggest anything in other software.		FAn automated insights feature that scans a table and suggests charts, trends and patterns without you writing any formulas.

Definitions

built-in AI features

Fill in the Blanks

Complete each line of code by filling in the missing parts.

Prompt: add up all the Maths marks =___(B2:B9)

Prompt: what is the average English mark? =AVERAGE(_____)

Prompt: how many Maths marks are 80+? =_______(B2:B9,">=80")

Insight: highest Science mark =___(D2:D9)

Prompt: mark each Maths result pass or fail =IF(B2__50,"Pass","Fail")

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Prompt: Average Maths mark

B Suggest: =AVG(B2:B9)

C Review the result

D Accept if it matches the data

Question 2

A Select data A1:B8

B Open Recommended Charts

C Choose pie chart for trend

D Add title and axis labels

Question 3

A Ask in binary code only

B Q: Who has the top Maths?

C Answer: Mia (95)

D Verify against the sheet

Question 4

A Select the Rain column

B Click Analyze Data

C Insight: Fri is driest

D Check insight in the data

Question 5

A Prompt: Count marks over 80

B Suggest: =COUNTIF(B2:B9,>80)

C Result: 3

D Compare with a manual count

Answer Key

Artificial intelligence features in software tools

Section A: Quick Questions

A — An AI feature built into a software tool

A — A natural-language question

A — Suggesting a formula

B — Chart suggestions

B — Automated insights

Section B: Match the Pairs

Copilot in Excel → A built-in AI assistant that can suggest formulas, build charts and answer questions about the data in your spreadsheet.

Analyze Data / Ideas → An automated insights feature that scans a table and suggests charts, trends and patterns without you writing any formulas.

A natural-language question lets you ask about your data in plain English instead of writing a formula. → Which student scored the highest Maths mark?

A chart suggestion feature recommends a chart type that suits the selected data. → Recommended Charts

Copilot's suggested formula was pasted in and used without checking the result. → AI suggestions can be wrong, so the output must be checked against the data, for example with a hand-calculated answer, before it is trusted.

Built-in AI features only work in Excel and cannot suggest anything in other software. → AI features are built into many everyday tools, such as spreadsheets, word processors and presentation or search software, not just Excel.

Section C: Definitions

built-in AI features — Smart tools inside everyday software, like Copilot in Excel, that suggest formulas and charts, answer plain-English questions and find insights automatically.

Section D: Fill in the Blanks

Prompt: add up all the Maths marks
=SUM(B2:B9)

Prompt: what is the average English mark?
=AVERAGE(C2:C9)

Prompt: how many Maths marks are 80+?
=COUNTIF(B2:B9,">=80")

Insight: highest Science mark
=MAX(D2:D9)

Prompt: mark each Maths result pass or fail
=IF(B2>=50,"Pass","Fail")

Section E: Spot the Error

B — AVG is not a spreadsheet function. The AI suggestion should use =AVERAGE(B2:B9) to find the mean.

C — A trend over days is best shown with a line chart. A pie chart shows parts of a whole, so it is the wrong pick.

A — Natural-language questions let you ask in plain English. You do not need binary code or any special syntax.

C — Friday has 22 mm of rain, the highest value, so it is the wettest day. The insight should say Fri is wettest.

B — The condition in COUNTIF must be in quotes. It should be ">80".