Get premium membership and access questions with answers, video lessons as well as revision papers.

Form 2 Computer Studies Questions and Answers on Spreadsheets

Form 2 Computer Studies Questions and Answers on Spreadsheets

Lessons (38)

• 1.    Define the term spreadsheets.
  0m 56s

• 2.    Describe two types of spreadsheets.
  1m 24s

• 3.    Give four advantages of the electronic spreadsheet over the manual spreadsheet.
  2m 5s

• 4.    List two components of a spreadsheet.
  0m 19s

• 5.    State four application areas of spreadsheet.
  0m 41s

• 6.    Define the term active cell.
  0m 35s

• 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
  1m 27s

• 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.
  0m 59s

• 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.
  1m 34s

• 10.    Outline the steps for setting the automatic save of a workbook.
  0m 47s

• 11.    Differentiate between workbook and a worksheet.
  0m 33s

• 12.    List two logical functions in a spreadsheet.
  0m 27s

• 13.    Describe the following terms as used in electronic spreadsheet: a)Automatic recalculations b)Data range
  0m 40s

• 14.    Differentiate between a formula and a function.
  0m 47s

• 15.    Explain the term “what if analysis” as used in spreadsheet.
  0m 26s

• 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. =H20+P$18
  0m 42s

• 17.    Give examples of spreadsheet packages.
  0m 27s

• 18.    List four data types available in spreadsheets.
  0m 18s

• 19.    Give two different ways in which a sheet name in a workbook can be renamed.
  1m 12s

• 20.    Give three component of a worksheet.
  0m 25s

• 21.    Define the following terms as used in spreadsheet graphs. a)Legend b) Data series
  0m 39s

• 22.    Differentiate between sum and sumIf functions.
  0m 46s

• 23.    Define the term data filtering as used in spreadsheets.
  0m 42s

• 24.    Differentiate between a label and a value used in spreadsheets.
  1m 1s

• 25.    List three sections of a functions
  0m 50s

• 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.
  2m 2s

• 27.    Differentiate between sorting and filtering of data as applied in spreadsheets.
  0m 27s

• 28.    Mention two types of cell referencing.
  0m 54s

• 29.    Describe four cell data types as used in spreadsheets.
  2m 10s

• 30.    Define the term cell reference.
  0m 50s

• 31.    Explain three types of cell referencing techniques.
  2m 20s

• 32.    Describe the following components of spreadsheet: i)Worksheet ii)Database iii)Graphs
  1m 12s

• 33.    Explain how spreadsheets can be used in these areas: i)statistical analysis ii)Accounting iii)Data management iv) Forecasting
  1m 44s

• 34.    Name any two types of charts in a spreadsheet.
  0m 23s

• 35.    Define the term cell as used in spreadsheet.
  0m 23s

• 36.    Give the function of the following types of charts: bar graph, line graph, pie chart and scatter chart.
  1m 5s

• 37.    List any two data management tools in spreadsheets.
  0m 33s

• 38.    For each of the following. State the type of cell referencing that has been used in: (i)A6 (ii) $F$7
  0m 26s