ADDITIONAL FEATURES OF MS EXCEL
AUTOCOMPLETE: - This is a feature in Microsoft excel that recognizes the
first few characters of the commonly used words and provides you with a list of
words which you can automatically use to insert the whole word. The
Human Computer Interface (HCI)
It is the method of interaction between the computer and the user
that determines how easily one can operate the computer.
It is the OS that determines how the display appears to the user.
There are 3 main types of HCI:
A named storage location where related files can be stored for easy access.
Folders enable one to divide a larger storage media into manageable storage
The folder tree structure allows the user to organize and keep track of a large
Disk management using an operating system
Disk formatting is the process for preparing a hard disk or other storage medium for its
first use by imprinting new tracks and sector on the disk surface so that the operating system can
1. Define the following terms:
i) A file: A collection of related information stored in one location
and given a unique name that enable the OS to identify it during
storage and retrieval
ii) Folder: A named storage area for related files.
INSTALLING WINDOWS OS
Since the OS is the supervisor of all other programs, it must first be installed
in the computer's hard disk before any other program.
Installation: Is the process of copying executable program files onto
the hard disk.
Q: How differ
COMMON FEATURES IN WINDOWS OS
Most PCs are running on Microsoft Windows. In fact Microsoft Corporation
Company dominates the software market: In Operating systems and
application software. E.g. Windows 95/98/2000/me/XP/Vista etc.
Other OS that rival Micro
FEATURES OF WINDOWS DESKTOP
A desktop: A display on the computer screen that appears after the OS has
been loaded in the main memory of the computer.
The desktop consists of; Icons, task bar and the background.
Icons: Small pictures that represent comman
After many files have been written to and erased from a disk, fragmentation can occur. Fragmentation happens when
pieces of single files are inefficiently distributed in many locations (several tracks and sectors) on a dis
RESOURCES UNDER OS CONTROL
1. The processor
Since the processor is a scarce resource that may be required to
perform several tasks at a time, the OS arranges the tasks according
to priority for execution.
The OS also has the ability to stop a particular t
MANIPULATING FILES AND FOLDERS WITH THE OS
Files and folders can be managed or manipulated using Windows Explorer or My
Either of the two lets you to view the arrangement of storage devices/ their
storage locations, files and folders.
It is a tool that re-arranges scattered files and folders on a storage
media for easy and faster access.
When files are stored on a new computer's hard disk, they are
normally stored contiguously. After using the computer for sometime
MAGNETIC INK CHARACTER RECOGNITION
Documents are difficult to forge
Documents can still be read after being written on, folded, soiled etc
MICR readers are expensive
The system can accept only a few characters
MACHINE CYCLE (H
Is the process of dividing a large physical disk into 2 or more sections/
parts with different volumes called logical drives.
A logical drive: A drive accessed as if it is a separate disk and is even
assigned a drive letter and yet in ac
Disk partitioning is the process or practice of dividing a large storage device into
separate data areas known as partitions or logical drives. Though in the same storage
device, a logical drive is treated as a spate independent drive an
An important feature of virtual memory is Paging. Paging allocates disk storage
for data which does not fit into physical memory in fixed size chunks called page.
It helps in removing the inactive pages from physical memory (RAM). Paging is
THE APPLICATION WINDOW
A rectangular area on the screen where text or graphical images are entered.
You can open an application file by:
Double clicking a file icon from the start menu / desktop.
Using My Computer icon, display the Explorer window,
COPYING AND MOVING WORKSHEETS
After creating a worksheet at times sit is important to use the contents of a given worksheet as a
base of another worksheet thereby instead of retyping the same contents in a new worksheet you
can easily copy the wo
Definition of an operating system:-As a supervisor of Hardware and
Devices under the control of the OS: Processor, Main memory,
secondary storage, I/O devices etc
Functions of the OS
Classification of OS: Number
1. Define the following terms as used in disk management.
Formatting: Imprinting tracks and sectors on the surface
of a disk.
Partitioning: Dividing of a large physical disk into 2 or
more sections of different volumes called logical
ADDING CELL BORDERS AND SHADING
A border can appear on all four sides of a cell or on only the selected side. To add a border, do
Select a cell or range of calls you want to apply borders to, then from format
submenu click cel
FUNCTIONS OF AN OS
The OS controls/ determines which task will use what resource and at
what time based on priority and the nature of request. For example,
since the processor can handle only one task at a time, the OS wi
FINDING DATA USING DATA FORM
To find individual records in a database, you use the criteria form in which you tell excel the
specific information or range of information you want to find the criteria. You can look for
something specific as a person with t
TYPES OF OPERATING SYSTEMS
Operating systems are classified based on:
Number of users
Number of tasks
Human computer interface
Size of the computer
1. Number of users
Single user operating system
It is an OS that allows only one person to access
MS EXCEL GRAPHS:
Are graphical representation of your data in your worksheet. They represent the matching data
that are in a range of cells in a given worksheet. By creating charts, the work sheet is converted
from rows to columns into visual form
Editing an entry means altering the existing data rather than replacing it with an entire new data.
This is done by clicking on the cell that contains incorrect value where the value appears in the
formula bar then use the backspace key t
1. Explain how Windows organizes information in reference to files and folders.
It stores related data and information in files. Related files
are stored in folders and sub-folders and the related folders are
kept in drives.
2. Why must an OS b
APPLICATION AREAS OF A SPREADSHEET
a. Statistical analysis
Spreadsheets provide the user with a variety of statistical functions that will enable him to
perform both simple and complex statistical operations such as computing the mean, standard
FORMATING TEXTAND NUMBER ON A CHART:
All the text on a chart appears inside its own text box. To format text or numbers on your chart,
click/select text number to be formatted or just select it from the chart object drop down list on
the chart toolbar.
A formula is a sequence of values, set references, names, functions or mathematical operators in
a single cell or a range of cells.
A formula can also be defined as a user defined mathematical expression used to solve
mathematical problems. I.e.