By use of examples, differentiate between a function and a formula in spread sheets. (2mks)
-Functions are in built predicted formulae that the user can quickly use instead of having to create
a new each time
e.g. –Sum (B1+b4)
-A formula is a mathematical expressions that create a relationship between cells to return a new
value
e.g. –D3+D4
8.
gideon1 answered the question on September 25, 2017 at 09:06
- State two types of charts found in spread sheets.(Solved)
State two types of charts found in spread sheets.
Date posted: September 25, 2017. Answers (1)
- State two types of database models.(Solved)
State two types of database models.
Date posted: September 25, 2017. Answers (1)
- Explain one area computers can be used in science and research.(Solved)
Explain one area computers can be used in science and research.
Date posted: September 25, 2017. Answers (1)
- State two advantages of using biometric devices in voting.(Solved)
State two advantages of using biometric devices in voting.
Date posted: September 25, 2017. Answers (1)
- Discuss the following types of computers (i) Dedicated purpose computers (ii) Embedded computers.(Solved)
Discuss the following types of computers
i) Dedicate purpose computers.
ii) Embedded computers.
Date posted: September 25, 2017. Answers (1)
- 1.(i) What is an Uninterruptible Power Supply (UPS)
(ii) State the functions of the uninterruptible Power Supply (UPS)(Solved)
1.(i) What is an Uninterruptible Power Supply (UPS)
(ii) State the functions of the uninterruptible Power Supply (UPS)
Date posted: September 25, 2017. Answers (1)
- Define a computer laboratory(Solved)
What is a computer laboratory?
Date posted: September 25, 2017. Answers (1)
- Give the functions of control unit in computer(Solved)
What are the functions of control unit in a computer?
Date posted: September 25, 2017. Answers (1)
- Define a system unit.(Solved)
Define a system unit.
Date posted: September 25, 2017. Answers (1)
- Briefly explain the development of the computers(Solved)
Briefly explain the development of the computers
Date posted: September 25, 2017. Answers (1)
- Give three parts of a computer mouse(Solved)
Give three parts of a computer mouse
Date posted: September 24, 2017. Answers (1)
- List five types of computer mice(Solved)
List five types of computer mice
Date posted: September 24, 2017. Answers (1)
- What are the functions of a computer mouse?(Solved)
What are the functions of a computer mouse?
Date posted: September 24, 2017. Answers (1)
- What is a computer mouse?(Solved)
what is a computer mouse?
Date posted: September 24, 2017. Answers (1)
- What is an output device?(Solved)
What is an output device?
Date posted: September 24, 2017. Answers (1)
- Give three input devices(Solved)
Give three input devices
Date posted: September 24, 2017. Answers (1)
- What is an input device as used in computer studies?(Solved)
What is an input device as used in computer studies?
Date posted: September 24, 2017. Answers (1)
- State three types of computer keyboards(Solved)
State three types of computer keyboards
Date posted: September 24, 2017. Answers (1)
- What is an embedded computer?(Solved)
What is an embedded computer?
Date posted: September 24, 2017. Answers (1)
- List five types of computers(Solved)
List five types of computers
Date posted: September 24, 2017. Answers (1)