Assignment # 4
Computer Proficiency License (CS 001)
Fall-2010
(Total Marks: 15)
Question No 1.
What is the use of auto fill tool in MS Excel? [Marks 5]
Answer:
When we need to type a sequence of numbers into a group of cells, the AutoFill
feature is the way to go. Just let Excel know what starting number or numbers
to use and the program fills in the rest of the numbers in sequence in the blink
of an eye. Excel can also fill in a range of dates by days, weekdays, months, or
years. A more advanced fill feature lets you fill in a range of numbers using a
Growth Trend, which increases the numbers by doubling, tripling, and so on. If
you are looking to fill in a range of times, Excel can do that, too.
Question No 2.
(a) How does a user create a border around a cell in MS Excel? [Marks 5]
Answer:
ლ Select the cells that you wish to draw the border around.
ლ Right-click and then select "Format Cells" from the popup menu.
ლ When the Format Cells window appears, select the Border tab. Next select your
line style and the borders that you wish to draw. In this example, we've chosen
a double line across the bottom and a single line on the top and sides.
ლ Now when you return to your spreadsheet, you should see the border
(b) Why do we use “Sort Data” function in MS Excel?
Answer:
We use “Sort Data” function in MS Excel when we want to put a list of names in
alphabetical order or make a list of product inventory levels from highest to lowest.
Sorting data helps us quickly visualize and understand the data better, organize and find
the data that we want.
Question No 3.
Match column A with column B. [Marks 5]
Solution:
Computer Proficiency License (CS 001)
Fall-2010
(Total Marks: 15)
Question No 1.
What is the use of auto fill tool in MS Excel? [Marks 5]
Answer:
When we need to type a sequence of numbers into a group of cells, the AutoFill
feature is the way to go. Just let Excel know what starting number or numbers
to use and the program fills in the rest of the numbers in sequence in the blink
of an eye. Excel can also fill in a range of dates by days, weekdays, months, or
years. A more advanced fill feature lets you fill in a range of numbers using a
Growth Trend, which increases the numbers by doubling, tripling, and so on. If
you are looking to fill in a range of times, Excel can do that, too.
Question No 2.
(a) How does a user create a border around a cell in MS Excel? [Marks 5]
Answer:
ლ Select the cells that you wish to draw the border around.
ლ Right-click and then select "Format Cells" from the popup menu.
ლ When the Format Cells window appears, select the Border tab. Next select your
line style and the borders that you wish to draw. In this example, we've chosen
a double line across the bottom and a single line on the top and sides.
ლ Now when you return to your spreadsheet, you should see the border
(b) Why do we use “Sort Data” function in MS Excel?
Answer:
We use “Sort Data” function in MS Excel when we want to put a list of names in
alphabetical order or make a list of product inventory levels from highest to lowest.
Sorting data helps us quickly visualize and understand the data better, organize and find
the data that we want.
Question No 3.
Match column A with column B. [Marks 5]
Solution:
Column A Column B
Find and Replace Ctrl + H
Menu bar Activation F10 or Alt key
Status bar Shows Page/Section/Line No/Column No
Title bar Shows the name of document
Drawing bar Contains graphics objects
Find and Replace Ctrl + H
Menu bar Activation F10 or Alt key
Status bar Shows Page/Section/Line No/Column No
Title bar Shows the name of document
Drawing bar Contains graphics objects
Please do make changes in these assignment otherwise every one who copy this assignment as it is will awarded zero marks
NOTE: - These Assignments OR Quiz are just for idea, so kindly don't copy it, after viewing it make your own. Thanks We always try our best to upload 100% correct solution BUT it is requested that you kindly review it before submission, please BEST OF LUCK, Thanks to those students those send me Assignments and quizzes. If you have any Assignment and quiz kindly send at fascobuk@gmail.com
No comments:
Post a Comment