Columns and Rows
- A spreadsheet is a grid consisting of columns and rows. Rows are labeled with numbers,
and columns are labeled with letters, giving each cell a unique address consisting of a
number and a letter. If you are familiar with the old game "Battleship", you'll be quite
comfortable with cell addressing.
- A cell may contain labels or values. A label is a text entry, such as TOTAL, that cannot
be manipulated by the spreadsheet. A value can be a number, a date, a formula, or the
answer of a formula.
- A single "grid", or page, is usually referred to as a worksheet.
Formulas
- Formulas are used to express mathematical relationships between cells. For example,
C1=A1+B1 would calculate and display the sum of cells. Al and B1 into cell Cl. It could
also be a simple mathematical formula, such as (100 * 3) / 40. Formulas are not displayed
on spreadsheets. What you see in the cell is the result of the formula.
- Don’t forget about order of operations; anything inside parenthesis happens first,
followed by multiplication and division, followed by addition and subtraction. When in
doubt, use parenthesis to say exactly what you mean.
Functions
Functions are used as shortcuts when performing .mathematical calculations. They are preprogrammed
formulae that give power and flexibility to spreadsheet calculations. They prevent
the user from having to continually enter long and cumbersome expressions. Some examples are
SUM, AVERAGE, MAX, and MIN. Ranges A range is a block of cells. Formulas can act on
single cells or be directed to act on a range of cells. For example, the range A1:D1 includes the
cell Al, Bl, Cl and D1. Any calculation performed in Al will also be performed in Bl, Cl and Dl,
Graphs and charts
- Data in spreadsheets can be displayed in a graphic form. Spreadsheets allow the£
numerical' data in the cells to be displayed as a graph or chart. These graphics, which
illustrate the meaning of the numbers in the spreadsheet in different ways, can be used to
stimulate interest and help make a point.
- There are several different types of graphs that can be made. Area graphs, bar and
column graphs, line graphs, pie charts, scatter plot diagrams and 3-D graphs are some
examples.
Kavungya answered the question on May 14, 2019 at 06:50
- Explain three advantages of a centralized database.(Solved)
Explain three advantages of a centralized database.
Date posted: May 14, 2019. Answers (1)
- Outline four major steps/or mail merging a document in word processing.(Solved)
Outline four major steps/or mail merging a document in word processing.
Date posted: May 14, 2019. Answers (1)
- Highlight two uses of each of the following application packages in business:
i) Presentation program,
ii) Database program,
iii) Spreadsheet program,(Solved)
Highlight two uses of each of the following application packages in business:
i) Presentation program,
ii) Database program,
iii) Spreadsheet program,
Date posted: May 14, 2019. Answers (1)
- Briefly explain the features of the following- file system
i) Disk file system
ii) Network file system
iii) Flash file system
iv) Special purpose file system(Solved)
Briefly explain the features of the following- file system
i) Disk file system
ii) Network file system
iii) Flash file system
iv) Special purpose file system
Date posted: May 13, 2019. Answers (1)
- a) Describe four aspects of file design that should be considered for a file in which
performance has high priority.
b) Outline four differences between a file...(Solved)
a) Describe four aspects of file design that should be considered for a file in which
performance has high priority.
b) Outline four differences between a file system and a database management system.
Date posted: May 13, 2019. Answers (1)
- Identify five types of file extensions.(Solved)
Identify five types of file extensions.
Date posted: May 13, 2019. Answers (1)
- Explain the following methods of organising computer file:
i. Sequential file organisation.
ii. Hash access file organisation.(Solved)
Explain the following methods of organising computer file:
i. Sequential file organisation.
ii. Hash access file organisation.
Date posted: May 13, 2019. Answers (1)
- Mr. Jackson Wabengo, the information communication manager of Vijana Enterprises Ltd.
intends to change the operating system platform in his organisation. He intends to embrace open
source...(Solved)
Mr. Jackson Wabengo, the information communication manager of Vijana Enterprises Ltd.
intends to change the operating system platform in his organisation. He intends to embrace open
source platforms in order to save the cost of annual licenses.
Required:
i) Define the term "open source platform".
ii) Briefly explain three advantages of open source platforms.
Date posted: May 13, 2019. Answers (1)
- Briefly describe the following types of operating systems:
i) Real time operating systems.
ii) Multi-user operating systems.(Solved)
Briefly describe the following types of operating systems:
i) Real time operating systems.
ii) Multi-user operating systems.
Date posted: May 13, 2019. Answers (1)
- The operating system acts as the resource manager of a computer system
Highlight four functions which are performed by an operating system in managing a computer
system's...(Solved)
The operating system acts as the resource manager of a computer system
Highlight four functions which are performed by an operating system in managing a computer
system's resources.
Date posted: May 13, 2019. Answers (1)
- The operating system primarily provides services for running applications on a computer
system Briefly discuss the need for an operating system(Solved)
The operating system primarily provides services for running applications on a computer
system Briefly discuss the need for an operating system
Date posted: May 13, 2019. Answers (1)
- a) Briefly explain six functional areas Served by a computer operating system.
b) Outline six activities undertaken during the information system implementation and
evaluation stage.
c) Highlight eight...(Solved)
a) Briefly explain six functional areas Served by a computer operating system.
b) Outline six activities undertaken during the information system implementation and
evaluation stage.
c) Highlight eight situations in a typical, office environment where connection between
computing devices might be required.
Date posted: May 13, 2019. Answers (1)
- Highlight ten tasks performed in the creative stage of systems development life cycle.(Solved)
Highlight ten tasks performed in the creative stage of systems development life cycle.
Date posted: May 13, 2019. Answers (1)
- Identify five activities of tin operating system in regard to file management.(Solved)
Identify five activities of tin operating system in regard to file management.
Date posted: May 13, 2019. Answers (1)
- (i) State three activities that take place during computer booting process.
(ii) Identify three features of a Basic Input/output system,(Solved)
(i) State three activities that take place during computer booting process.
(ii) Identify three features of a Basic Input/output system,
Date posted: May 13, 2019. Answers (1)
- a)Explain how operating systems create an impression of doing several jobs at the same time.
b)i) Define the term "real-time processing system".
ii) State two examples of...(Solved)
a)Explain how operating systems create an impression of doing several jobs at the same time.
b)i) Define the term "real-time processing system".
ii) State two examples of real-time processing systems
Date posted: May 13, 2019. Answers (1)
- Distinguish between the following terms as used in the context of information technology:
i) Closed source and-open source operating systems,
ii) Beta and integrated software,(Solved)
Distinguish between the following terms as used in the context of information technology:
i) Closed source and-open source operating systems,
ii) Beta and integrated software,
Date posted: May 13, 2019. Answers (1)
- Differentiate between:
i. Multitasking and single tasking operating system
ii. old booting and warm booting(Solved)
Differentiate between:
i. Multitasking and single tasking operating system
ii. old booting and warm booting
Date posted: May 13, 2019. Answers (1)
- Define the following terms as used in computer networks
i. Unguided media.
ii. Router.
iii. Network interface card
iv. Hot Spot
v. Wi-Fi(Solved)
Define the following terms as used in computer networks
i. Unguided media.
ii. Router.
iii. Network interface card
iv. Hot Spot
v. Wi-Fi
Date posted: May 13, 2019. Answers (1)
- Fourth generation languages (4GL’s) consist of a variety of software tools which enable end
users to .develop software applications with minimal or no technical assistance or...(Solved)
Fourth generation languages (4GL’s) consist of a variety of software tools which enable end
users to .develop software applications with minimal or no technical assistance or that enhance
the productivity of professional programmers.
Required:
Describe the features of 4GLs which make them to be preferred by programmers for application
development.
Date posted: May 13, 2019. Answers (1)