Get premium membership and access questions with answers, video lessons as well as revision papers.
- The first column in the table below contains the formulae as stored into the
cell F10 of a spreadsheet. Enter the formulae, as they would appear...(Solved)
The first column in the table below contains the formulae as stored into the
cell F10 of a spreadsheet. Enter the formulae, as they would appear when
copied to the cell M20 of the same spreadsheet.
Date posted: June 25, 2019.
- A 3 by 4 matrix M is to be added to another 3 by 4 matrix array N so as to
give a third 3 by...(Solved)
A 3 by 4 matrix M is to be added to another 3 by 4 matrix array N so as to
give a third 3 by 4 matrix array P. Using a high level programming language,
write a program segment that assigns the sum of M and N to P.
Date posted: June 25, 2019.
- List any four high level programming languages(Solved)
List any four high level programming languages
Date posted: June 25, 2019.
- Compare the two types of diskettes used in microcomputers in terms of physical size and densities.(Solved)
Compare the two types of diskettes used in microcomputers in terms of physical size and densities.
Date posted: June 25, 2019.
- Andrew, Jane, David and Zablon had tea, sausages and bananas for
breakfast. They took one sausage, two sausages, three sausages and one sausage
respectively. In addition, they...(Solved)
Andrew, Jane, David and Zablon had tea, sausages and bananas for
breakfast. They took one sausage, two sausages, three sausages and one sausage
respectively. In addition, they took a cup of tea and two bananas. Tea, sausages
and bananas cost Kshs 10, 15 and 5 respectively.
By naming columns A, B, C … and rows 1, 2, 3 …………….
(a) Construct a worksheet showing the above information
(b) State the expression you would use to obtain:
(i) Total expenditure by David
(ii) Total number of sausages taken
(iii) The cost of the cheapest item
Date posted: June 25, 2019.
- Define Optical fibre cables.(Solved)
Define Optical fibre cables.
Date posted: June 25, 2019.
- Give one advantage and one disadvantage of coaxial cables.(Solved)
Give one advantage and one disadvantage of coaxial cables.
Date posted: June 25, 2019.
- Give one advantage and one disadvantage of twisted pair cables.(Solved)
Give one advantage and one disadvantage of twisted pair cables.
Date posted: June 25, 2019.
- A program is required for reading in a student’s name and scores obtained in two
subjects. The output of the program will consist of the student’s...(Solved)
A program is required for reading in a student’s name and scores obtained in two
subjects. The output of the program will consist of the student’s name, the two
scores, the average of the two scores and comment. The comment is based on the
average as follows:
Write a program to solve the problem using a high level language.
Date posted: June 25, 2019.
- What is the use of the search? Replace future in a word-processor.(Solved)
What is the use of the search? Replace future in a word-processor.
Date posted: June 25, 2019.
- In the following flowchart, what will be the value of the sum when printed?
Show how you arrive at your answer(Solved)
In the following flowchart, what will be the value of the sum when printed?
Show how you arrive at your answer
Date posted: June 25, 2019.
- Define Optical Mark Reader (OMR).(Solved)
Define Optical Mark Reader (OMR).
Date posted: June 25, 2019.
- List the steps that you would use to correct wrongly spelt words in a document using the spell-checking feature.(Solved)
List the steps that you would use to correct wrongly spelt words in a document using the spell-checking feature.
Date posted: June 25, 2019.
- Differentiate between primary memory and secondary memory.(Solved)
Differentiate between primary memory and secondary memory.
Date posted: June 25, 2019.
- Briefly explain any two advantages and two disadvantages of using a database(Solved)
Briefly explain any two advantages and two disadvantages of using a database
Date posted: June 25, 2019.
- The roots of the equation ax2 +bx + c= 0 are by the formula
a) Draw a flowchart to compute the roots of the equation.
b) Using...(Solved)
The roots of the equation ax2 +bx + c= 0 are by the formula
a) Draw a flowchart to compute the roots of the equation.
b) Using the flow-chart write a program that will compute the roots and
if b2 – 4ac is negative, the program should display the message
“NEGATIVE
Date posted: June 25, 2019.
- Give any two types of data entries that may be input into a worksheet cell.(Solved)
Give any two types of data entries that may be input into a worksheet cell.
Date posted: June 25, 2019.
- As regards to communication within a computer network, what do you
understand by the following terms:
i) Point –to-point
ii) Broadcast(Solved)
As regards to communication within a computer network, what do you
understand by the following terms:
i) Point –to-point
ii) Broadcast
Date posted: June 25, 2019.
- Name any two types of graphs that are supported by spreadsheets.(Solved)
Name any two types of graphs that are supported by spreadsheets.
Date posted: June 25, 2019.
- Worksheet cells are referenced using the column letter and row number e.g.
D2 is cell in column D and row 2.
Use the sample worksheet provided to...(Solved)
Worksheet cells are referenced using the column letter and row number e.g.
D2 is cell in column D and row 2.
Use the sample worksheet provided to answer the questions below
a) Write down the data type that is stored in cell C5
b) What cell contains the data items representing transport for the
month of February?
c) Write down the formula that may be used to compute the total in cell
f6.
Date posted: June 25, 2019.
- Give two types of storage devices used in a computer giving an example of each.(Solved)
Give two types of storage devices used in a computer giving an example of each.
Date posted: June 25, 2019.
- State one advantage and one disadvantage of a laser printer(Solved)
State one advantage and one disadvantage of a laser printer
Date posted: June 25, 2019.
- What is a distributed system?(Solved)
What is a distributed system?
Date posted: June 25, 2019.
- State two operational methods of an organization ensuring of data.(Solved)
State two operational methods of an organization ensuring of data.
Date posted: June 25, 2019.
- Explain the difference between the printing of multiple copies and the
printing of multiple pages(Solved)
Explain the difference between the printing of multiple copies and the
printing of multiple pages
Date posted: June 25, 2019.
- A spreadsheet has the following entries:
Provide a formula for cell C% that can be copied onto cell D5 and the reange C6..
D10 to give a...(Solved)
A spreadsheet has the following entries:
Provide a formula for cell C% that can be copied onto cell D5 and the reange C6..
D10 to give a uniform increase of 10% of the previous year’s value for each item.
Date posted: June 25, 2019.
- Briefly explain the following terms:
i) Cell
ii) Range
iii) Label
iv) Value
v) function(Solved)
Briefly explain the following terms:
i) Cell
ii) Range
iii) Label
iv) Value
v) function
Date posted: June 25, 2019.
- Students sat for a test in computer studies. The table below gives the marks obtained
and the number of students obtaining the marks.
Write a program in...(Solved)
Students sat for a test in computer studies. The table below gives the marks obtained
and the number of students obtaining the marks.
Write a program in a structured high level language to calculate the mean of the result.
The formula for the mean is given in the table below.
Date posted: June 25, 2019.
- For each of the following file organization methods, state an appropriate storage
medium.
a) Serial
b) Random
(Solved)
For each of the following file organization methods, state an appropriate storage
medium.
a) Serial
b) Random
Date posted: June 25, 2019.
- In which memory would the monitor program would be stored?(Solved)
In which memory would the monitor program would be stored?
Date posted: June 25, 2019.