‘What if’ analysis is a feature in spreadsheets that is used to find out the
effect of changing certain values in a worksheet on the other cells.
It involves changing the values of one of the arguments in a formula in
order to see the difference the change would make on the result of the calculation.
Kavungya answered the question on June 6, 2019 at 09:41
-
a) A formula to add the contents of B5 and C4 was entered in Cell F5.
what will it become when it is copied to Cell...
(Solved)
a) A formula to add the contents of B5 and C4 was entered in Cell F5.
what will it become when it is copied to Cell H8?
b) Explain the reason for your answer.
c) What is the equivalent R1C1 reference for G20?
Date posted:
June 6, 2019
.
Answers (1)
-
The fist column in the table below contains formulas as entered into cell D46. In the second column, enter the formulas as they would appear...
(Solved)
The fist column in the table below contains formulas as entered into cell D46. In the second column, enter the formulas as they would appear when copied to cell B56.
Date posted:
June 6, 2019
.
Answers (1)
-
State the components of a Database hierarchy in ascending order.
(Solved)
State the components of a Database hierarchy in ascending order.
Date posted:
June 6, 2019
.
Answers (1)
-
Give the two classes of database software.
(Solved)
Give the two classes of database software.
Date posted:
June 6, 2019
.
Answers (1)
-
Differentiate between Tabular and columnar form layout.
(Solved)
Differentiate between Tabular and columnar form layout.
Date posted:
June 6, 2019
.
Answers (1)
-
Describe four major shortcomings of the conventional (paper )file structures that are being addressed by the database approach.
(Solved)
Describe four major shortcomings of the conventional (paper )file structures that are being addressed by the database approach.
Date posted:
June 6, 2019
.
Answers (1)
-
The following car details are to be entered in a database: Make, Date-of-manufacture, colour, and cost.
a) Prepare a suitable database structure showing field names and...
(Solved)
The following car details are to be entered in a database: Make, Date-of-manufacture, colour, and cost.
a) Prepare a suitable database structure showing field names and their field data types
b) Explain how you index the data such that cars of the same make and colour are together.
c) Write a statement that can be used to select cars of colour green.
d) Give an instruction that would:
i) Select cars whose cost is between 500,000/= and 1,000,000/=
ii) Determine the average cost of all cars.
Date posted:
June 6, 2019
.
Answers (1)
-
Differentiate between Fill and stroke
(Solved)
Differentiate between Fill and stroke
Date posted:
June 6, 2019
.
Answers (1)
-
Differentiate between Change case and drop cap.
(Solved)
Differentiate between Change case and drop cap.
Date posted:
June 6, 2019
.
Answers (1)
-
Differentiate between Margins and column guides.
(Solved)
Differentiate between Margins and column guides.
Date posted:
June 6, 2019
.
Answers (1)
-
Differentiate between pasteboard and printable page
(Solved)
Differentiate between pasteboard and printable page.
Date posted:
June 6, 2019
.
Answers (1)
-
Why is layering very useful in a desktop publisher?
(Solved)
Why is layering very useful in a desktop publisher?
Date posted:
June 6, 2019
.
Answers (1)
-
Briefly describe four factors contributing to Internet access and growth in Kenya.
(Solved)
Briefly describe four factors contributing to Internet access and growth in Kenya.
Date posted:
June 6, 2019
.
Answers (1)
-
Computer systems need maximum security to prevent an unauthorized access. State six precautions that you would expect an organization to take to prevent illegal access...
(Solved)
Computer systems need maximum security to prevent an unauthorized access. State six precautions that you would expect an organization to take to prevent illegal access to its computer-based systems.
Date posted:
June 6, 2019
.
Answers (1)
-
Give four rules that must be observed in order to keep within the law when working with data and information.
(Solved)
Give four rules that must be observed in order to keep within the law when working with data and information.
Date posted:
June 6, 2019
.
Answers (1)
-
An individual has a right to demand guarantee to privacy of personal information stored on a computer. Give three such types of information.
(Solved)
An individual has a right to demand guarantee to privacy of personal information stored on a computer. Give three such types of information.
Date posted:
June 6, 2019
.
Answers (1)
-
Clearly differentiate between data collection and data capture.
(Solved)
Clearly differentiate between data collection and data capture.
Date posted:
June 6, 2019
.
Answers (1)
-
Name the examples of industries and business organizations that extensively use distributed processing systems.
(Solved)
Name the examples of industries and business organizations that extensively use distributed processing systems.
Date posted:
June 6, 2019
.
Answers (1)
-
Describe 5 factors to be considered while choosing a programming language.
(Solved)
Describe 5 factors to be considered while choosing a programming language.
Date posted:
June 6, 2019
.
Answers (1)
-
The gross salary of employees of Mutson Chemist is based on the Basic and additional benefits. Employees with more than 10 year’s experience get an...
(Solved)
The gross salary of employees of Mutson Chemist is based on the Basic and additional benefits. Employees with more than 10 year’s experience get an additional pay of 10% of their basic salary. Bonuses are given as per employees’ sales of the month as:
>200,000 15%
100,000 – 200,000 10%
Below 100,000 5%
Draw a flowchart for the program that will calculate Gross salary and output each employee’s Basic salary, gross salary and all benefits.
Date posted:
June 5, 2019
.
Answers (1)