MENU
Educational Resources
Form 1 Videos
Form 2 Videos
Form 3 Videos
Form 4 Videos
Grade 4 Videos
Grade 5 Videos
Grade 6 Videos
Grade 7 Videos
Class 8 Videos
Form 1 Exams
Form 2 Exams
Form 3 Exams
Form 4 Exams
KCSE Videos
Class 8 Exams
Grade 5 Exams
Grade 4 Exams
Grade 3 Exams
Grade 2 Exams
Grade 1 Exams
Online Tests
Online Tuition
Sign In
Join
Get access to thousands of educational resources
Get premium membership
and access revision papers with marking schemes, video lessons and live classes.
OR
Processing. Please wait.
Form 2 Computer Studies Questions and Answers on Spreadsheets
List two logical functions in a spreadsheet.
(0m 27s)
708 Views
SHARE
|
« Previous
Next »
1.
Define the term spreadsheets.
2.
Describe two types of spreadsheets.
3.
Give four advantages of the electronic spreadsheet over the manual spreadsheet.
4.
List two components of a spreadsheet.
5.
State four application areas of spreadsheet.
6.
Define the term active cell.
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
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.
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.
10.
Outline the steps for setting the automatic save of a workbook.
11.
Differentiate between workbook and a worksheet.
12.
List two logical functions in a spreadsheet.
13.
Describe the following terms as used in electronic spreadsheet: a)Automatic recalculations b)Data range
14.
Differentiate between a formula and a function.
15.
Explain the term “what if analysis” as used in spreadsheet.
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
17.
Give examples of spreadsheet packages.
18.
List four data types available in spreadsheets.
19.
Give two different ways in which a sheet name in a workbook can be renamed.
20.
Give three component of a worksheet.
21.
Define the following terms as used in spreadsheet graphs. a)Legend b) Data series
22.
Differentiate between sum and sumIf functions.
23.
Define the term data filtering as used in spreadsheets.
24.
Differentiate between a label and a value used in spreadsheets.
25.
List three sections of a functions
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.
27.
Differentiate between sorting and filtering of data as applied in spreadsheets.
28.
Mention two types of cell referencing.
29.
Describe four cell data types as used in spreadsheets.
30.
Define the term cell reference.
31.
Explain three types of cell referencing techniques.
32.
Describe the following components of spreadsheet: i)Worksheet ii)Database iii)Graphs
33.
Explain how spreadsheets can be used in these areas: i)statistical analysis ii)Accounting iii)Data management iv) Forecasting
34.
Name any two types of charts in a spreadsheet.
35.
Define the term cell as used in spreadsheet.
36.
Give the function of the following types of charts: bar graph, line graph, pie chart and scatter chart.
37.
List any two data management tools in spreadsheets.
38.
For each of the following. State the type of cell referencing that has been used in: (i)A6 (ii) $F$7
×
Share Content Via:
Facebook
Twitter
WhatsApp
Close
Get premium membership