Practice essential Microsoft Excel functions with this beginner-friendly assignment. Learn how to use SUM, SUMIF, MAX, MIN, COUNT, IF, CONCAT, and more for product sales analysis, data entry, formatting, calculations, and data analysis. Perfect for students to master Excel basics and improve productivity.
Submission Date: On or before 24th October (Hard Copy)
SUMSUMIFMAXMINCOUNTCOUNTACOUNTIFPOWERPRODUCTAVERAGEIFNOWTODAYLOWER, UPPER, PROPERLENCONCATFunction: SUM
Purpose: Adds all the numbers in a range of cells.
Syntax: =SUM(number1, [number2], ...)
Example: =SUM(A1:A5) → Adds values from cell A1 to A5.
📌 Note: Assignments submitted after 24th October will not be accepted.