A. Fill in the blanks:
1. Microsoft Excel is a Spreadsheet application.
2. A file in Excel is called a workbook.
3. You can insert or delete cells,
column or rows using right
click shortcut menu.
4. Text alignment
on the Alignment tab provides options to select the appearance of text in the
selected cells.
5. The speed key used pasting cell
contents Ctrl + C.
6. Each workbook contains three pages
called Worksheets.
7. A cell
is the basic unit of a spreadsheet.
8. By default, Excel aligns text along the left margin and numbers along the right margin of a cell.
9. You can also right click the
selected cells and select copy
or Paste from the selected cut
menu.
10. To copy the data, press and hold Ctrl key while dragging.
11. Excel has pre-define width and height for each cell.
12. Excel displays height in a pop-up box as you drag.
13. The intersection
of a row and column is called a cell.
14. Pressing the Ctrl + Z on the keyboard repeats the last
actions.
15. The alignment tab gives us options
to choose the alignment of the data
in a cell.
16. We can fill color or pattern in a worksheet.
17. You can also choose with specific
borders to be highlight and color the border to be used.
B.
Answer
the following:
1. Describe the
advantages of Spreadsheet software?
Some benefits of
Spreadsheet software are:
i)
Organized
data: we can organize our data in a good way. We can put chart and graph to
represent our data.
ii)
Easy
to use: new user can easily understand and use the spreadsheet. The data is
easy to enter and sorting and filter of data is easily don.
iii)
Modification:
The data can be edited in spreadsheets easily. We can store the data in
different worksheets in a common file.
iv)
Easy
to Format: The data can be easily formatted in a spreadsheet.
2. What are the different
methods to edit data in cell?
There are two different
methods to edit data in cell they are:
i)
Double
click on the cell.
ii)
Select
the cell and press F2 from the keyboard.
3. Lists two ways by
which you can move data from one cell to another.
The two ways by which we
can move data from one cell to another are:
i)
Right
click the selected cell and select Cut or Paste from the short cut menu.
Or You can also use the
shortcut key Ctrl + C to cut from the selected cell and Ctrl + V to paste to a
new cell, without right click on the cell.
ii)
To
move the data, press and hold the Ctrl key while dragging.
4. Give the different steps
of changing the column width.
The different steps of
changing the column width are given below:
|
Using Mouse |
Using Ribbon |
|
i)
Move the mouse pointer to
the right border of the column heading whose width you want to change ii)
Click and drag the pointer
to left or right to decrease or increase the column width. iii)
Release the mouse button
and the column is change |
i)
Select column(s) to be
adjusted ii)
Click the Home tab from the
Ribbon. iii)
In the cells group, click
format. (a menu appears) iv)
Click the column width. v)
The column width dialog box
appears. vi)
Type the width you want to
set for the selected column(s). vii)
Click Ok Excel Change the new column width.
|
5. How can you insert a
column row in the spreadsheet?
To insert a column row
in the spreadsheet.
i)
Select
the location where the new row is to be inserted.
ii)
Click
the Home tab from the ribbon.
iii)
In
the cells group, click insert.
The menu appears
iv)
Click
insert sheet row
v)
The
insert dialog box appears on the screen
vi)
Select
entire row.
vii)
Click
OK.
You can see that a new row
has been inserted.
6. How can you format
data using Ribbon?
We can format data using
Ribbon by following the steps given below:
i)
Select
the cell whose data you want to format.
ii)
Click
the Home tab.
iii)
In
the cell group click on format.
A menu appears
iv)
Select
the Format cells option.
v)
The
Format Cells dialog box appears having many tabs containing different formatting
options.
vi)
You
can choose any tab to format your data.
7. What is the use of Number
Tab?
Number tab gives us
options to choose the default type of the data to be entered in a cell.
8. What is the use of
Alignment Tab?
Alignment tab gives us
options to choose the alignment of data in a cell.
9. What is the default
alignment in excel for text and number?
Excel aligns text along
the left margin and number along the right margin.
10. Why we use cell border
formatting?
Cells border formatting can
be used to highlight the data in our worksheet. Formatting borders make our data
appear in organized and easy to visualize.
11. What is Text Control?
Name it options.
Text Control provides
options to select the appearance of the text in the selected cells.
These options are:
i)
Wrap
Text
ii)
Shrink
to fit
iii)
Merge
cells
0 Comments