Form 2 Computer Studies questions and answers on Spreadsheets

Describe the following components of spreadsheet:
i)Worksheet ii)Database
iii)Graphs

Viewed: 912 times

Share in:
Explanation/Answer Text:
i)Worksheet-this is the working area in a spreadsheet. It is made up of rows and columns where data is entered.
ii)Database-these are related data items organized
in rows and columns that can be manipulated using database function. These features include filtering records, using forms, calculating subtotals and data validation among others.
iii)Graphs-these are pictorial representations of data on a worksheet which enable a user to represent data
elements and their relationships. Examples include pie charts, line charts and bar graphs
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)


7. Give the default function of these control keys as used in spreadsheets: i)Left arrow ii)Tab iii)Enter iv)Shift +tab v)Home ( free lesson)


8. A student obtained the following marks in an examination: 70, 80, 60, 33, and 76. If the values are written at cells C5 to C9, write a formula that will be used to sum all marks greater than 50. ( free lesson)


9. A project manager is currently working on a workbook named “Nairobi City”. She would like to save it with the new name “Beautiful City”. Outline the steps to follow. ( 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)


13. Describe the following terms as used in electronic spreadsheet: a)Automatic recalculations b)Data range ( 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)


16. The formula =F24 + N$18 was typed in cell J25 and copied to cell L21 of a spreadsheet. Write the formula in destination cell. ( 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)


26. Consider the data in the cells below entered in a worksheet. a)Name the data types in the cells i)D13 ii)E20 iii)E21 b)Give the values in cells i)E20 ii)E22. ( 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)


33. Explain how spreadsheets can be used in these areas: i)statistical analysis ii)Accounting iii)Data management iv) Forecasting ( 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)


36. Give the function of the following types of charts: bar graph, line graph, pie chart and scatter chart. ( free lesson)


37. List any two data management tools in spreadsheets. ( free lesson)


38. For each of the following. State the type of cell referencing that has been used in: (i)A6 (ii) $F$7 ( free lesson)