← Previous Page

Form 2 Computer Studies questions and answers on Spreadsheets

Differentiate between sorting and filtering of data as applied in spreadsheets.

Viewed: 1144 times

Share in:

Explanation/Answer Text:

-Sorting is arranging data alphabetically or numerically in descending or ascending order while filtering is the displaying of data rows that meet certain criteria.

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)

Form 2 Computer Studies questions and answers on Spreadsheets

Explanation/Answer Text:

Questions/Lessons List

Quick Links

Follow Us

© 2025 Afritutor.com