Excel Functions Complete Notes + Exam
Questions (Easy & Clear Guide)
These notes are designed to help you quickly understand Excel in a simple and practical way. They
are perfect for revision, assignments, and exam preparation.
1. Basic Concepts
1 Cell: A box where you enter data (e.g., A1)
2 Row: A horizontal line (1, 2, 3...)
3 Column: A vertical line (A, B, C...)
4 Workbook: The Excel file
5 Worksheet: A sheet inside the workbook
2. Common Excel Functions
1 SUM: Adds numbers together (Example: =SUM(A1:A5))
2 AVERAGE: Finds the mean (Example: =AVERAGE(A1:A5))
3 IF: Used for decisions (Example: =IF(A1>50,'Pass','Fail'))
4 COUNT: Counts numeric cells (Example: =COUNT(A1:A10))
3. Simple Spreadsheet Diagram
4. Exam Questions
1 What does the SUM function do? Answer: It adds a range of values.
2 What is the difference between relative and absolute reference? Answer: Relative changes
when copied, absolute stays fixed using $.
3 Write an IF function for marks above 70: =IF(A1>70,'Good','Try Again')
Questions (Easy & Clear Guide)
These notes are designed to help you quickly understand Excel in a simple and practical way. They
are perfect for revision, assignments, and exam preparation.
1. Basic Concepts
1 Cell: A box where you enter data (e.g., A1)
2 Row: A horizontal line (1, 2, 3...)
3 Column: A vertical line (A, B, C...)
4 Workbook: The Excel file
5 Worksheet: A sheet inside the workbook
2. Common Excel Functions
1 SUM: Adds numbers together (Example: =SUM(A1:A5))
2 AVERAGE: Finds the mean (Example: =AVERAGE(A1:A5))
3 IF: Used for decisions (Example: =IF(A1>50,'Pass','Fail'))
4 COUNT: Counts numeric cells (Example: =COUNT(A1:A10))
3. Simple Spreadsheet Diagram
4. Exam Questions
1 What does the SUM function do? Answer: It adds a range of values.
2 What is the difference between relative and absolute reference? Answer: Relative changes
when copied, absolute stays fixed using $.
3 Write an IF function for marks above 70: =IF(A1>70,'Good','Try Again')
