Lesson 64 Quiz: AI Tools for Data and Spreadsheets

Question 1

What is one useful way AI can help with spreadsheets?

Creating and explaining spreadsheet formulas Guaranteeing that all spreadsheet data is correct Automatically removing all unusual data Replacing the need to understand the dataset

Question 2

Why should an AI generated spreadsheet formula be tested?

The formula may not produce the intended result AI cannot create spreadsheet formulas Testing formulas is never useful Spreadsheet formulas only work with text

Question 3

What should happen when AI identifies an unusual value in a dataset?

Investigate the value before deciding what to do Automatically delete the value Assume the value is always correct Ignore every unusual value

Question 4

Why is data quality important when using AI for analysis?

Poor quality data can produce misleading results AI automatically fixes every data problem Data quality only matters for printed reports AI analysis does not use the supplied data

Question 5

What should users consider before uploading a spreadsheet containing confidential information to an AI service?

Privacy and confidentiality requirements Only the spreadsheet file size Only the number of worksheets Whether the spreadsheet has charts