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
Answer (1)
Answer:1. An electronic spreadsheet application program is a software that provides a digital spreadsheet for the analysis and presentation of data. It is commonly used for data analysis, creating graphs and charts, and presenting results in a clear format. Examples of electronic spreadsheet application programs include Microsoft Excel, Google Sheets, and LibreOffice Calc.2. Functions and formulas are both used in electronic spreadsheet application programs to give results to data. A function is a pre-programmed formula that gives a specific result to data. It is commonly used for everyday searches such as finding the average, sum, and count of data. A formula is a personal search used to give a specific result to data. It is commonly used for more complex searches such as finding percentages, finding square roots, and finding exponential values.3. Functions can be categorized based on their purpose. Some categories of functions include the following:* Math functions: These are used for everyday searches such as finding the average, sum, and count of data. They are commonly used for everyday searches such as finding percentages, finding square roots, and finding exponential values.a.) Text functions : These are used for everyday searches such as finding the names of cells, finding the names of sheets, and finding the names of cell ranges.b.) Date and time functions: These are used for everyday searches such as finding date and time functions, such as finding the current day, finding the current week, and finding the current year.c.) Logical functions: These are used for everyday searches such as finding IF statements, finding AND statements, and finding OR statements.4. Some examples of commonly used functions include the following:a.) SUM: This is used to give the total value of a range of cells.b.) AVERAGE: This is used to give the average value of a range of cells.c.) IF: This is used to give a result based on a specific condition.d.) VLOOKUP: This is used to search for a value in a range of cells based on a specific criterion.e.) INDEX-MATCH: This is used to search for a value in a range of cells based on a specific criterion.
