Test spreadsheet elements (functions, validation, formatting)

A spreadsheet is like a digital notebook where you can write numbers, words, and formulas in a grid of rows (horizontal lines) and columns (vertical lines). Each intersection is a cell that can hold data or a calculation.

• Cells – the building blocks.
• Formulas – start with =, e.g., =A1+B1.
• Functions – pre‑built formulas like SUM, AVERAGE.
• Formatting – colours, fonts, borders.
• Data Validation – restrict what can be entered.

The sum of a series can be written in maths as: $$\sum_{i=1}^{n} x_i = x_1 + x_2 + \dots + x_n$$

Imagine you’re filling out a form for a school club. You want to make sure everyone picks a valid club from a list and that ages are between 13 and 18.

1. Highlight the cells you want to validate.
2. Go to Data > Data Validation.
3. Choose List and type: Drama,Music,Art,Science.
4. For age, choose Whole number between 13 and 18.

Now, if someone tries to type “Football” or “10”, the spreadsheet will warn them.

• Number formats – currency, percentage, date.
• Conditional formatting – highlight cells that meet a rule, e.g., Score < 50 turns red.
• Cell styles – bold headers, shaded rows.

Example: To show a 10% increase, use =A1*1.10 and format the cell as Percentage.

Conditional formatting rule can be expressed as: $$x < 50 \;\Rightarrow\; \text{red background}$$

• Read the question carefully – look for keywords like “sum”, “average”, “conditional”.
• Check cell references – absolute ($A$1) vs relative (A1).
• Use named ranges to make formulas easier to read.
• Double‑check data validation rules – they can be the key to the correct answer.
• Always format numbers appropriately before submitting.

1. In a table of test scores (cells A2:A11), calculate the average score and display it as a percentage.
2. Use a data validation list to allow only the grades A, B, C, D, or F in column B.
3. Write a formula that returns “Excellent” if a score in C2 is above 90, “Good” if between 70 and 90, and “Needs Improvement” otherwise.
4. Apply conditional formatting to highlight any score below 50 in red.

Spreadsheets are powerful tools that combine data entry, calculations, and visual presentation. Mastering functions, validation, and formatting will help you solve exam questions efficiently and produce clear, error‑free work.