Class-X-Solved Exercise:
Unit-8 Spreadsheet (Intermediate)
Session-4 Set Page Breaks
Session-5 Set Page Layout
I. Objective Type Questions:
1. Fill in the blanks:
a. Page breaks can be inserted _________ or vertically.
Answer: Horizontally
b. Page Break view option is under_______ tab on the ribbon.
Answer: View
c. To insert a ________ page break, select the row below where you want to insert the page
break.
Answer: Horizontal
d. To insert a ________ page break, select the column to the right where page break needs to be inserted.
Answer: Vertical
e. Margins option is available under __________ group in the _________ tab.
Answer: Page setup, page layout
f. Two types of page orientation are _______ and __________.
Answer: Portrait, landscape
g. Print settings for a worksheet can be done using the ______ group in the Page Layout tab.
Answer: Page setup
h. Page breaks are visible in _________ preview.
Answer: Page Break
i. To print particular area of a worksheet, select _____ option.
Answer: Print Area
j. Spreadsheet software provides various page layout options using the ______ view.
Answer: Workbook
2. Write T for true and F for false against the statement.
a. A page break can be given to divide a worksheet horizontally or vertically.
Answer: T
b. Page breaks are visible in normal view.
Answer: F
c. Page break cannot be removed.
Answer: F
d. The page setup option in under insert tab.
Answer: F
e. Page orientation once set cannot be changed.
Answer: F
II. Short Answer Questions.
1. What is the need of Page Breaks in a worksheet?
Answer: To print a worksheet with the exact number of pages that you want , you can adjust the page breaks in the worksheet before you print it.
Page breaks are dividers that break a worksheet into separate pages for printing.
2. Ravi has prepared a worksheet and now he wants to perform certain tasks related to it but he is confused that which command option he should use for particular tasks. Help him by matching task with correct command option.
Answer:
1. To observe the page breaks inserted in the worksheet---- View worksheet in page break preview.
2. To find how much area of worksheet can be printed on one A4 size---- Set Print Area
3. To increase the left Margin of the paper before printing--- Select margins from page setup dialog box.
4. To print data in landscape orientation--- Select orientation option under page layout tab.
3. What are the different options available under the Page setup dialog box?
Answer: The page setup dialog box provides us with many options as below:
1. Page- Orientation, Size
2. Margins- Top, bottom, left and right margin.
3. Header/Footer
4. Sheet tab.
4. Write steps to insert a Page break in a worksheet.
Answer: Steps for insert a page break in a worksheet.
1. Click on the page layout tab.
2. Select Breaks button.
3. Select Insert Page Break option from the drop down menu.
4. Observe the page break inserted in the worksheet at cell pointer position.
5. Write steps to remove a page break from a worksheet.
Answer: Steps for removing Page Break:
You can also remove the page breaks by clicking the remove page break option in breaks drop down list.
1. Click on Page layout tab.
2. Click on Break option.
3. Click on Remove Page break.
Some other links:
No comments:
Post a Comment