Form 2 Computer Studies questions and answers on Spreadsheets
i)statistical analysis
ii)Accounting
iii)Data management
iv) Forecasting
Viewed: 947 times
Explanation/Answer Text:
some statistical functions include average and median.
-Accounting-accountant use the provided tool to record daily transactions and keep financial records. Accountant can track the values of assets over time, calculate profits and prepare budgets using the spreadsheet tools.
-Data management-spreadsheet contain tool such as sorting, filtering and forms that enable a user to organize large related data.
-Forecasting-it has automatic recalculation features which enable the user to predict happenings using “what if” analysis technique. This involves changing the value of one of
the arguments in a formula to see the difference the change would make on the result of the calculation
Questions/Lessons List
1. Define the term spreadsheets. ( free lesson)
2. Describe two types of spreadsheets. ( free lesson)
3. Give four advantages of the electronic spreadsheet over the manual spreadsheet. ( free lesson)
4. List two components of a spreadsheet. ( free lesson)
5. State four application areas of spreadsheet ( free lesson)
6. Define the term active cell. ( free lesson)
10. Outline the steps for setting the automatic save of a workbook. ( free lesson)
11. Differentiate between workbook and a worksheet. ( free lesson)
12. List two logical functions in a spreadsheet. ( free lesson)
14. Differentiate between a formula and a function. ( free lesson)
15. Explain the term “what if analysis” as used in spreadsheet. ( free lesson)
17. Give examples of spreadsheet packages. ( free lesson)
18. List four data types available in spreadsheets ( free lesson)
19. Give two different ways in which a sheet name in a workbook can be renamed. ( free lesson)
20. Give three component of a worksheet. ( free lesson)
21. Define the following terms as used in spreadsheet graphs. a)Legend b) Data series ( free lesson)
22. Differentiate between sum and sumIf functions. ( free lesson)
23. Define the term data filtering as used in spreadsheets ( free lesson)
24. Differentiate between a label and a value used in spreadsheets. ( free lesson)
25. List three sections of a function ( free lesson)
27. Differentiate between sorting and filtering of data as applied in spreadsheets. ( free lesson)
28. Mention two types of cell referencing. ( free lesson)
29. Describe four cell data types as used in spreadsheets. ( free lesson)
30. Define the term cell reference. ( free lesson)
31. Explain three types of cell referencing techniques. ( free lesson)
32. Describe the following components of spreadsheet: i)Worksheet ii)Database iii)Graphs ( free lesson)
34. Name any two types of charts in a spreadsheet. ( free lesson)
35. Define the term cell as used in spreadsheet. ( free lesson)
37. List any two data management tools in spreadsheets. ( free lesson)
