Get premium membership and access questions with answers, video lessons as well as revision papers.
- Production of graphs
- Automatic recalculation
- Projection of growth curves through what if analysis
- Sorting of data
Kavungya answered the question on June 25, 2019 at 07:55
- 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. Answers (1)
- 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. Answers (1)
- List any four high level programming languages(Solved)
List any four high level programming languages
Date posted: June 25, 2019. Answers (1)
- 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. Answers (1)
- 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. Answers (1)
- Define Optical fibre cables.(Solved)
Define Optical fibre cables.
Date posted: June 25, 2019. Answers (1)
- Give one advantage and one disadvantage of coaxial cables.(Solved)
Give one advantage and one disadvantage of coaxial cables.
Date posted: June 25, 2019. Answers (1)
- 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. Answers (1)
- 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. Answers (1)
- 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. Answers (1)
- 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. Answers (1)
- Define Optical Mark Reader (OMR).(Solved)
Define Optical Mark Reader (OMR).
Date posted: June 25, 2019. Answers (1)
- 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. Answers (1)
- Differentiate between primary memory and secondary memory.(Solved)
Differentiate between primary memory and secondary memory.
Date posted: June 25, 2019. Answers (1)
- 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. Answers (1)
- 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. Answers (1)
- 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. Answers (1)
- 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. Answers (1)
- 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. Answers (1)
- 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. Answers (1)