Spreadsheets - MS Excel
Class 9 • Enter • Calculate • Discover. 10 learning modules, 30 module MCQs + 10-question checkpoint quiz.
Course Chapters & Learning Modules
Total 10 interactive modules with guided checkpoint challenges.
Module 1: Meet the Spreadsheet
Define workbooks, worksheets, cells, rows, columns, ranges, and cell addresses.
Module 2: Entering Text, Numbers, Dates and Times
Enter common data types accurately and use clear, consistent headings.
Module 3: Editing and Formatting a Worksheet
Edit cell contents and format a worksheet for readability.
Module 4: AutoFill and Series
Use AutoFill to continue number, date, day, month, and formula patterns.
Module 5: Formulas and Cell References
Create formulas using arithmetic operators and cell references.
Module 6: Functions: SUM and AVERAGE
Use SUM and AVERAGE with ranges and explain their results.
Module 7: MAX, MIN and IF
Use MAX, MIN, and a simple IF function to compare values and make a decision.
Module 8: Insert, Delete and Print
Insert and delete cells, rows, and columns carefully and prepare a worksheet for printing.
Module 9: Bar, Line and Pie Charts
Create and choose bar, line, and pie charts for suitable questions.
Module 10: Scatter and Area Charts
Explain when scatter and area charts are useful and interpret them carefully.
Learn With Pragati AI Today
Adopt your interactive companion, write live code, and earn verifiable school credentials.