PSEB Punjab Board Class 9 Computer Science Textbook Solution Chapter 6 MS Excel Part – 4 Exercise Questions and Answers
Lesson No 6 – Microsoft Excel (Part – 4)
Exercise
Q1) Multiple Choice Questions :–
1) Which option belongs to Page layout tab?
a) Page Orientation b) Paper Size c) Print Area d) All of these
Answer- d) All of these
2) Which one is not a view in MS Excel
a) Formula View b) Normal View c) Page Layout View d) page Break View
Answer- a) Formula View
3) …………………. is the empty space between the worksheet data and the edges of printed page.
a) Paper Size b) Print Area c) Margin d) Print preview
Answer- c) Margin
4) …………………….. appears on the top of each page in print preview and printed sheets.
a) Footer b) Header c) Bottom Margins d) None of these
Answer- b) Header
5) We can lock our cells from being accidently changed with the help of……………
options.
a) Save As b) Save c) Print Area d) Protect Sheet
Answer- d) Protect Sheet
Q2) Write True or false :-
1) Workbook cannot be protected in MS Excel. False
2) We cannot remove Page Break once inserted. True
3) Page Orientation are of two types : Portrait and Landscape True
4) Margins can be on the top, bottom. Left, right header and footer of a page. True
5) We can use Print Area option to print a specific part of a Worksheet. True
Q3) Short Answer Type Questions :-
1) What do you mean by Margin?
Ans :- Margins in Excel are is the method of leaving the blank space between the
worksheet data and the printed page. This blank extra space is been added towards the
left, right, top and bottom directions at the end of the printed page.
2) Write a short note on page Orientation?
Ans :- It is way of displaying of the data on the page/pages i.e means how we want the
data to be appearing on the page/pages which means in horizontal or in vertical
direction and as per it the page gets adjusted.
3) What do you mean by Scaling?
Ans :- Scaling means adjusting with the contents size at the time of printing it on a
specific paper size. It helps in adjusting the large worksheet to be printed to the one or
more pages. By this option, it makes much easier to expand the small content on the
multiple pages.
4) Give the names of view in MS Excel
Ans :- Normal View, Page Layout view, Page Break Preview, Custom view, Full Screen
view are the views of MS Excel.
5) What is the use of Page Break
Ans :- Page break is the option which helps in managing how the contents are to be
splitted on different pages.
Q4) Long Answer Type Questions :-
1) What do you mean by Page Layout? Explain three Page Layout options.
Ans :- Page layout tab provides you various commands like Margin, Orientation, Paper
size, Print area etc which helps us to perform some settings related to the worksheets
that is inserted in our workbook. This commands are very useful and are in relation to the printing of worksheets. Some of the commands are been explained below :-
a. Margins :- Margins in Excel are is the method of leaving the blank space between the worksheet data and the printed page. This blank extra space is been added towards the left, right, top and bottom directions at the end of the printed page. Margins are much helpful in adjusting the margins to the page by increasing or decreasing the space
around the data contents from all the sides. The margins adjusted to the page can be removed by only setting the value as zero.
b. Orientation :- It is way of displaying of the data on the page/pages i.e means how we want the data to be appearing on the page/pages which means in horizontal or in vertical direction and as per it the page gets adjusted. In every programs, you may find two orientation which are
- Portrait :- This orientation is used when our data is much longer as
compared to a page, and less number of columns. When the Portrait
orientation is activated, the page gets displayed into the Vertical form. This
page orientation is by default. - Landscape :- This orientation is used when our data is much wider as
compared to a page, and has more number of columns. When the
Landscape orientation is activated, the page gets displayed into the
Horizontal form.
c) Size :- This is an important option the page Layout tab which helps us to set
the worksheet contents on a specific paper size. There are different types of
sizes in which we can change contents layout size which are Letter, A4, Legal
different types of envelopes etc. The contents can be printed on the specific size
of the paper as it is been chosen.
2) Explain any two views of MS Excel in detail.
Ans :- Below are the two views of MS Excel are been explained in detail :-
a) Normal view :- In Excel, you may find this view as by default i.e means
whenever anyone opens up MS Excel program, then you may notice that your
worksheet is displayed in Normal mode. In this view, the we can easily perform
the tasks related to data managing, formulas creation and formatting to the
rows and columns. In this view you may also see that every particular row or
column is along with their row and columns headers, which is much helpful in
identifying the names of the row or column. This view also facilitates the best
zooming, we can create a new spreadsheet or edit the existing one by applying
/make use of different formulas or functions. Normal view is available on the
first ribbon of the View tab. Below you may find the diagram of the
spreadsheet, that is viewed in Normal view are :-
b) Page Break view :- This view comes in relation with the printing of worksheet.
In this view, you can arrange the worksheet in to pages by manually moving the
page break which helps in printing. In MS Excel, blue lines are used as Page
breaks in the form of breaking the rows and columns of the worksheet as the
blue line is moved. The page breaks arranged in the worksheet gets same
printed as it is. Page break view option is available as the third ribbon on the
View tab. Below you may find the diagram of the spreadsheet, that is viewed in
Normal view are :-
Dear Student, I appreciate your efforts and hard work that you all had put in. Thank you for being concerned with us and I wish you for your continued success.
For more update, follow this page ⇒ PSEB Notes and Solutions