Current UniversityFree · Self-paced

Campus Rooms Live About

AI Academy / AI for data and spreadsheets

Final exam · 10 questions · pass with 8

AI for data and spreadsheets

Open book: you may look back at the lessons. Answers are graded on our server, and you can try again as often as you like.

Read in

1. A coworker gets a formula from an AI tool and pastes it into 2,000 rows without testing. What is the main risk?
The sheet will slow down and may stop responding completelyA wrong result may spread across every row unnoticedThe sheet will slow down and may stop respondingThe AI tool will lock the file after one paste
2. You paste a formula you do not understand. Which request teaches you the most?
Translate this formula into another programming language.Rewrite this formula so it is shorter and uses fewer functions.Explain each part simply, with an example using made-up numbers.Is this formula correct? Please answer with a clear yes or no.
3. A column of dates is stored as text and your monthly totals look wrong. What should you do?
Ask the AI to delete every row that has a date in itHide the date column so it stops affecting the totalsRound the numbers in the total column to fewer decimalsConvert the dates properly and re-run the summary
4. Why is it better to ask AI for cleaning steps than to paste back a fully cleaned file?
Steps are repeatable and you can see what changedAI tools cannot return a cleaned file back to you at allA cleaned file is usually less accurate than the originalSteps run faster because the AI skips checking the data
5. Your summary table total is lower than the accounting total. What is the most sensible next check?
Assume the accounting total is wrong because AI added it upAdd the missing amount as a manual adjustment rowChange the summary's date range until the numbers matchLook for blanks, spelling variants or rows that dropped out
6. You want to show a manager how monthly sales changed over a year. Which choice fits best?
A line chart with a clear title and labeled axesA pie chart with one slice for each of the twelve monthsA dense table of daily figures with no chart or titleA 3D bar chart in many colors so each month stands out
7. An AI tool says the average of your order values is far higher than any value in the file. What is the best response?
Treat it as a red flag and confirm it with a formulaReport it, because the AI calculated it from your own dataAsk the AI to repeat the number until it matchesSwap to the median without finding out why it differed
8. A school office worker wants AI help analyzing a sheet of student grades with names. What is the main concern?
Student names should not go into a consumer tool unless the school approved itGrades from AI charts are never accurate enough to shareTeachers are not allowed to calculate averages with AI at allThe sheet may be too large for a chat tool to read properly
9. You find that your sample for a survey includes only people who replied online. How should you handle this in a report?
Leave the limitation out so the report stays clear and shortState that the responses may not represent everyoneDouble the online counts to make up for the missing peopleAsk the AI to adjust the figures so they look balanced
10. You uploaded a CSV and the AI answers confidently. What first question confirms it read the file correctly?
Can you present the same answer again in a prettier layout?What columns and rows do you see, and what does each column mean?Which company built you, and when was the file last updated?Are you certain that your answer is correct, yes or no?

Name to print on your certificate

We don't check identity, and we don't store your name: it lives only inside your certificate link.

Answer all 10 questions and enter a name to submit.

Current University

Free courses, written to be used. Every course states what you will be able to do; every chapter ends with a practice and a check.

Catalog revised: 2026-09-26

Programs

All Programs
All our free schools
Campus: AI faculty, office hours
Learn your way (1 minute)
One lesson, every age
Core: daily study session
Founders track
AI Academy (free certificates)
Free AI skills
What improved (changelog)
Teach it (students write lessons)
Course Catalog
Certificates
Admissions

Careers

Career Path
Trade Programs
Regional Jobs
Career Assessments
AI Counselors
Discussion rooms
Study groups and project teams
Live lectures

About

Our Mission
FAQ
AI Professors
Privacy Policy
Terms of Service
How this works (AI and people)
How courses update themselves
Contact the founder
AI This Week (weekly email)
Community rules

Current University is a free, self-paced course site. Lessons were drafted with AI assistance and can contain errors (AI Academy lessons are AI-drafted and machine-checked; a person has not read every lesson), so check anything that matters against a primary source. Current University is not an accredited institution and does not grant degrees or academic credit. AI Academy courses give a free certificate of completion after a graded exam; it is not a degree, credit, license or vendor certification. Nothing here is medical, legal, financial, tax, career or investment advice.

Current University is not an accredited university. No degrees, diplomas, academic credit or CE (continuing education) credit are granted, and it is not affiliated with any university, accrediting body or government. The AI professors and counselors are AI characters, not people. General information only. This is an AI tool, not a licensed professional, and nothing here is professional advice. Using this site does not create a professional relationship. Consult a licensed professional about your situation. In an emergency call 911. If you are thinking about harming yourself: call or text 988 (US).

© 2026 Current University. All rights reserved.