Class 7th
Subject : Computer
Lesson 3 : Advance
features of Microsoft Excel
Paste and label component of
Ms Excel Window
A. Fill in the blanks
Cell Chart Three
Print 16384
1. There are 16384 columns in a
worksheet.
2. The intersection
of row and column is known as cell .
3. Chart is a graphical representation of data.
4. There are three (3) types of referencing in MS Excel.
5. Print option is
used to print a worksheet.
B. True or False
1.
Wrap text is used to move your text in multiple lines. True
2.
In absolute referencing & symbol is used. False
3.
Bar and columns are two types of charts. True
4.
The cell with highlighted boundary is known as Active cell. True
5.
In relative referencing value is copied instead of formula. False
C. Short answer type
questions.
1. Write any four
components of MS Excel.
Ans:
Components of
Ms-Excel are :
1. Worksheet : A worksheet is made up of
rows and columns. By default, work book
has three worksheets.
You can add any number of worksheets in a workbook.
2. Row Heading : Each row in excel
represent a specific number and it is present
on the left side of a
worksheet. There are 1,048,576 rows in a worksheet.
3. Column Heading : Each column in excel
represent column heading and it is present on the top of a worksheet. There are
16,384 columns in a worksheet.
4. Cell : It is a intersection of row
and column. Each cell has its unique address. Example of cell address is A1, F5
or T7. It contains letter and number.
5. Active Cell : The cell with highlighted
boundary is known as active cell.
6. Name Box : It displays the location of
the cell pointer.
7. Formula Bar : It shows the character or
formulas that you enter in active cell
2. Name three types
of referencing
Ans: REFERENCING : The cell address in a formula is known as the cell referencing.
By using it you can use the data in different parts of a worksheet. There are
three types of referencing.
1.
Relative Referencing
2.
Absolute Referencing
3.
Mixed Referencing
3. List various types
of charts you use in MS Excel
Ans: There are various types of chart available in MS Excel
1. Bar
chart
2.
Column chart
3. Line
chart
4. Area
chart
5. XY
Scatter chart
6. PIE chart
7.
Doughnut chart
8. Radar chart
9.
Bubble chart
D. Long answer type questions.
1. What is the use of
Excel?
Ans: MS Excel is a powerful spread sheet component which allows us to
calculate, manipulate our data. It consists of rows and columns to make our
work easier.
2. Differentiate
between ROW heading and COLUMN heading.
Ans: Row Heading : Each row in
excel represent a specific number and it is present on the left side of a
worksheet. There are 1,048,576 rows in a worksheet.
Column Heading : Each column in
excel represent column heading and it is present on the top of a worksheet.
There are 16,384 columns in a worksheet.
3. Write the steps to
apply WRAP TEXT?
Ans: Steps to apply
Text Wrap
Step 1. Click
on the cell in which you want to move the text in next line.
Step 2. Select
HOME button choose WRAP TEXT on Alignment group. Now your text will represent in multiple lines.
4. What is chart?
Also draw diagram of any two types of charts after seeing in your computer.
Ans: CHARTS : Charts are the
graphical representation of your worksheet data. It make it easy to represent
our data in comparison manner or to show it in relational manner.
No comments:
Post a Comment