Print a worksheet MCQs Quiz | Class 9
This is a multiple-choice quiz for Class IX Computer Applications (Code 165), Unit 3: Office Tools (Spreadsheets). This quiz focuses on the topic of printing a worksheet, covering key concepts like setting the print area and basic page setup options. Attempt all questions, submit your answers to see your score, and download the PDF answer sheet for review.
Understanding How to Print a Worksheet
Effectively printing a spreadsheet is a crucial skill for presenting data professionally. Simply clicking the print button often leads to poorly formatted, unreadable documents. By using the page setup and print area tools, you can control exactly how your data appears on the physical page, ensuring clarity and professionalism in your reports.
Key Concepts in Page Setup
Page setup options allow you to customize the layout of your printed worksheet. Here are the most important settings to master:
1. Print Area
The Print Area command allows you to select a specific range of cells that you want to print. If you don’t set a print area, the spreadsheet application will try to print the entire active worksheet, which might include unnecessary data or empty cells.
How to use it: First, select the cells you want to print. Then, go to the Page Layout tab and click on Print Area > Set Print Area. To remove it, you can select Print Area > Clear Print Area.
2. Page Orientation
This setting determines whether the worksheet is printed vertically or horizontally.
| Orientation | Description | Best For |
|---|---|---|
| Portrait | The page is taller than it is wide. This is the default orientation. | Worksheets with many rows but fewer columns. |
| Landscape | The page is wider than it is tall. | Worksheets with many columns that need to fit across the page. |
3. Margins
Margins are the blank spaces around the edges of the printed page. You can choose from predefined margin settings (Normal, Wide, Narrow) or set custom margins to precisely control the placement of your data. You can also center your data horizontally or vertically on the page using the margin settings.
4. Scaling
Scaling options help you fit your data onto a specific number of pages. Common scaling options include:
- No Scaling: Prints the sheet at its actual size (100%).
- Fit Sheet on One Page: Shrinks the entire worksheet to fit on a single printed page.
- Fit All Columns on One Page: Shrinks the worksheet so that all columns fit on the width of one page, while the rows can extend to multiple pages.
- Fit All Rows on One Page: Shrinks the worksheet so all rows fit on the height of one page, while columns can extend to multiple pages.
5. Print Titles
When you have a long table that spans multiple pages, the column or row headers will only appear on the first page by default. The Print Titles feature allows you to repeat specific rows (like the header row) or columns at the top or left side of every printed page, making your data much easier to read.
Quick Revision Checklist
- Select Data: Identify the exact range of cells you need to print.
- Set Print Area: Use Page Layout > Print Area > Set Print Area.
- Choose Orientation: Decide between Portrait and Landscape based on your data’s layout.
- Adjust Margins: Set appropriate margins for a clean look.
- Configure Scaling: Use scaling options if your data doesn’t fit well on the page.
- Set Print Titles: Repeat header rows/columns for multi-page prints.
- Use Print Preview: Always check the Print Preview to see exactly how your document will look before printing to avoid wasting paper.
Practice Questions
- What is the main difference between “Fit Sheet on One Page” and “Fit All Columns on One Page”?
- How can you add the current date to the bottom right of every printed page?
- If your print preview shows 3 pages but you want it to be 2, what is the first setting you should try to adjust?
- Describe a scenario where setting a Print Area would be essential.
- Where can you find the option to clear a previously set Print Area?
