MS Excel 2007
Exercise Solution
A.Tick (P) the correct alternative :
1. An Excel file is called as :
(a) Spreadsheet
(b) Worksheet
(c) Document
(d) None of these
2.The basic unit of a spreadsheet
is :
(a) Row
(b) Column
(c) Cell
(d) Both (a) and (b)
3. A cell with a dark border around
it.
(a) Cursor
(b) Pointer
(c) Active Cell
(d) Column
4.The cell labeled F5 refers to :
(a) Row F column 5
(b) Columns
(c) Column F row 5
(d) All of these
B. Write 'T' for true and ‘F’ for false statement:
1. A spreadsheet is software for handling and manipulating
numbers. - True
2. An Excel file is called a worksheet. - True
3. Cell is the basic unit of spreadsheet. - True
4. A cell is the intersection of a row and column. - True
5. In Excel 2007 there are 1,048,576 rows. - True
C. Define the following terms:
1. Cell Address - It is location of a cell on the worksheet and
defined by column letter and row number.
2. Columns -
Columns are arranged vertically and are named from A to Z .
3. Worksheet - A worksheet is a grid of cells.
4. Formula bar -
It displays the cell entries and provides the line for working with formulas.
5. Active cell -
A cell with a dark border around it.
D. Fill In the blanks:
1. Microsoft Excel is a member of MS Office Software.
2. Calculations are error
free.
3. Cell in MS Excel is the basic unit of spreadsheet.
4. A worksheet is a grid of cells.
5. Formula entered into a cell begins with an
equal = sign.
6. A spreadsheet is software for handling and
manipulating numbers.
7. In Business, to track profit or to store customer and employee data.
E. Answer the following questions:
1. What is a
spreadsheet?
Ans: It is software for handling and manipulating
numbers.
2. What is MS
Excel?
Ans: MS Excel is a spreadsheet
package and a member of MS Office software.
3. Write the
advantages of using MS Excel software?
Ans:
1)
Entering
data is faster and easier.
2)
Making
changes are easier.
3)
Calculation
are error free.
4. Mention three areas where MS Excel can be used
as a good computing tool. justify your answer with examples.
Ans:
1)
In schools,
to organize and track fee or marks information.
2)
At home, it
can be used to monitor monthly expenses.
3)
In business,
to track profit or to store customer and employee data.
5.Name three places where can a
spreadsheet be used.
Ans: School, home and business.
6.What is a worksheet?
Ans: A spreadsheet is a software for handling and
manipulating numbers.
7. Write some advantages of using
spreadsheet software.
Ans:
1)
Entering
data is faster and easier.
2)
Making
changes are easier.
3)
Calculation
are error free.
No comments:
Post a Comment