1. What is an electronic spread sheet application program? 2. Differentiate functions from formulas. 3. Explain the different categories of functions 4. Give examples of commonly used functions (subject TLE ICT) grade 6

1. An electronic spreadsheet application program is a computer software used to organize, analyze, and store data in tabular form, using rows and columns. It allows users to perform calculations, create charts, and manage data efficiently. Examples include Microsoft Excel and Google Sheets.2. The difference between functions and formulas in a spreadsheet:Formula is a user-defined calculation written by combining numbers, cell references, and operators (e.g., =A1+B1).Function is a pre-built calculation or operation in the spreadsheet software that performs specific tasks, such as SUM or AVERAGE (e.g., =SUM(A1:A5)).3. Different categories of functions:Mathematical Functions - Perform arithmetic operations (e.g., SUM, ROUND).Statistical Functions - Analyze data sets (e.g., AVERAGE, COUNT).Text Functions - Manipulate text strings (e.g., CONCATENATE, LEFT).Logical Functions - Perform logical comparisons (e.g., IF, AND, OR).Date and Time Functions -  Handle date and time data (e.g., NOW, DATE).Examples of commonly used functions:=SUM() — adds numbers in a range=AVERAGE() — calculates the average of numbers=IF() — makes logical comparisons=COUNT() — counts the number of cells with numbers=NOW() — shows the current date and time

Answered by Sefton | 2025-08-10