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)
-
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)
-
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)
-
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)
-
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)
-
Mr. Charles Midika operates a computer bureau which specializes in preparing customers'
curriculum vitae (CVs) and in developing and printing organizations’annual
Required:
Identify four features of computer software...
(Solved)
Mr. Charles Midika operates a computer bureau which specializes in preparing customers'
curriculum vitae (CVs) and in developing and printing organizations’annual
Required:
Identify four features of computer software which would be suitable for Mr. Charles Midika's
bureau.
Date posted:
May 13, 2019
.
Answers (1)
-
A systems developer requires a range of software utilities.
Required:
Define the term "software utility" and describe three types of software utilities.
(Solved)
A systems developer requires a range of software utilities.
Required:
Define the term "software utility" and describe three types of software utilities.
Date posted:
May 13, 2019
.
Answers (1)
-
The following diagram gives an overview of computer software:
Required:
Identify two examples of each of the following computer software’s:
i. General purpose application programs.
ii. Application specific...
(Solved)
The following diagram gives an overview of computer software:
Required:
Identify two examples of each of the following computer software’s:
i. General purpose application programs.
ii. Application specific programs.
iii. System management programs.
iv. Systems development programs.
Date posted:
May 13, 2019
.
Answers (1)
-
People who use modern general purpose computers usually observe three layers of computer
software performing a variety of tasks
Identify and briefly describe the three layers of...
(Solved)
People who use modern general purpose computers usually observe three layers of computer
software performing a variety of tasks
Identify and briefly describe the three layers of computer software as usually observed by
general purpose computer users
Date posted:
May 13, 2019
.
Answers (1)
-
(i) Briefly explain the term "machine level programming language".
(ii) State two advantages and three disadvantages of a machine level programming language.
(Solved)
(i) Briefly explain the term "machine level programming language".
(ii) State two advantages and three disadvantages of a machine level programming language.
Date posted:
May 13, 2019
.
Answers (1)