I'm not sure what the 'following formats' are, but simply putting a $ in front of the letter will lock the column reference, and putting a $ in front of the number will lock the row reference. Putting a $ in front of both will allow you to keep the cell reference the same. For example:
A1 should be A$1$ in an equation to keep the reference as A1 for all 'filled down' equations.
Answer:
a. data processing
b. data collection
c. data input
d. data output
Explanation:
An information system is a system used to filter, process, collect, distribute and create data.
Information system can be a work system whereby humans and machine perform processess using informations gathered, process it to solve the needs of their customers in the form of goods and services.
Answer:
Algorithms.
Explanation:
Computer system is an electronic machine that receives input data, processes or executes these data and outputs the results. It comprises of two parts, the hardware and software components.
The computer receives data created by a process and inputted by individuals. The software components are the operating system and the application softwares running in the operating system. The application software follows a well defined stages of task to execute a task. This is called algorithm.
The application uses the algorithm to execute the task on the input data to give the required result.
