CFOA
ASSIGGNMENT :
5 AND 6
Question 1. Write features usage of MS Excel and explain
various types of Charts in MS Excel ?
ANSWER:-
Features usage of MS Excel :--
1. Add Header and Footer
2. Find and Replace Command
3. Password Protection
4. Data Filtering
5. Data Sorting
6. Built-in formula
7. Create different charts (Pivot Table Report)
8. Automatically edits the result
9. Formula Auditing
Types of charts in MS Excel
Column chart
Data that’s arranged in columns or rows on a
worksheet can be plotted in a column chart. A column
chart typically displays categories along the horizontal
(category) axis and values along the vertical (value)
axis, as shown in this chart:
Line chart
Data that's arranged in columns or rows on a worksheet
can be plotted in a line chart. In a line chart, category
data is distributed evenly along the horizontal axis, and
all value data is distributed evenly along the vertical
axis. Line charts can show continuous data over time
on an evenly scaled axis, so they're ideal for showing
trends in data at equal intervals, like months, quarters,
or fiscal years
Pie chart
Data that's arranged in one column or row on a
worksheet can be plotted in a pie chart. Pie charts show
the size of items in one data series, proportional to the
sum of the items. The data points in a pie chart are
shown as a percentage of the whole pie.
Doughnut
Data that's arranged in columns or rows only on a
worksheet can be plotted in a doughnut chart. Like a
pie chart, a doughnut chart shows the relationship of
parts to a whole, but it can contain more than one data
series.
Bar chart
Data that's arranged in columns or rows on a worksheet
can be plotted in a bar chart. Bar charts illustrate
comparisons among individual items. In a bar chart, the
categories are typically organized along the vertical
axis, and the value
ETC.
QUESTION 2.
Discuss the features provided by
a. MS Excel
b. MS Access
Answer :-
a.MS Excel :-
1.Autoformat: let us to choose many preset
table formatting options.
2.Autosum : help us to add the contents of a cluster
of adjacent cells.
3.List Auto fill : automatically extends cell formatting
when , a new item is added to the end of a list.
4.Autofill : feature allows us to quickly fill cells with
repetitive or sequential data , such as
chronological dates and numbers , and repeated
text
5.Autoshapes toolbar : will allow us to draw a
number of geometrical shapes ,arrows ,flowchart
element ,stars more .
6.Wizard : guide us to work effectively , while we
work by displaying various helpful tips and
techniques based on what we are doing .
7.Drag and drops : feature will help us to reposition
the data and text by simply dragging the data with
the help of mouse .
8.Charts : features will help us in presenting a
graphical representation of our data in the form of
pie,bar,linechart and more.
b. MS Access :-
1. Acess provides the facility to break large
information into small parts , so that it is easy to
access the information .
2. Data redundancy is reduced.
3. It increases the efficiency , speed and flexibility
in searching and accessing information .
4. Acess facilities sharing of data , different users
can use the same database to extract data
according to their needs.
5. Access provides data security features and
maintions integrity which is useful to make our
data more consistent and integrity .
6. Acess provides the fecility to create data forms ,
so that the user can enter the required
information in the respective fields , it also
reduces data entry errors.
Question :3
Write the features of spreadsheet.
Answer:-
1. A spreadsheet allows user to enter and calculate
numerical data .
2. Spreadsheet greatly increases productivity for
anyone who needs to manage receipts , create
budgets, generate financial reports .
3. It combines the features of a general ledger with
the flexiblility of powerful data analysis and
reporting function .
QUESTION :4
WRITE SHORT NOTES –
A. WEB BROWSING
B. ADVANTAGE OF NETWORKS
C. Batch file
Answer:-
1. Web browsing :
A web browser is an
interface that helps a computer user
gain acess to all content that is on the
interent and the hard disk of the
computer . it can view images, text
documents ,audio , files , games etc. the
user can navigate through files , folders ,
and websites with the help of a browsing
web pages , the pages may contain links
that can be opened in new browser .
multiple tabs and windows of browser
can also be opened .
2. Advantages of network :
A network
consists of two or more computers
that are linked in order to share
resources (like printer), exchange
files allows electronic
communications . The computer on a
network may be linked through
cables , telephone lines , radio waves
, satellite or infrared light beams .
3. Batch file :
Batch files allows MS-DOS or
Microsoft windows users to create a list
of commands to run in sequence once
the batch file has been executed .
For example : a batch file could be used
to run frequently run commands ,
deleting a series of files , moving files
etc.
Question 5.
Explain the three way to create
a table in MS Access.
Answer:
When we create a database , we store
our data in tables --- subject based lists
that contain rows and column . for
instance, we can create a contacts table
to store a lists of Names ,
Addresses ,and Telephone number or a
product tables to store information about
products.
1. CREATE A NEW TABLES IN A NEW
DATABASE :
A . click the Microsoft office button ,
and then click NEW.
B. In the File Name box , type a file
name for the new database .
C. To browse to different location to
save the database , click the folder
icon.
D. click Create .
2. CREATE A NEW TABLE BY USING A
TABLE TEMPLATE :
A. click the Microsoft office button ,
and then click open .
B. In the open dialog box , select
and open the database in
Which you wish to create a table.
D. On the create tab, in the tables
group , click table
Tamplates and then select one of
the available templates
From the list.
3. CREATE A NEW TABLE BY
IMPORTING OR LINKING TO
EXTERNAL DATA :
A. Click the Microsoft office button ,
and then click open .
B. In the open dialog box , select
and open the database in
Which you wish to create a new
table.
C. On the external data tab, in the
import group , click one of
The available data sources.
