PSEB Class 12 Computer Education Chapter 1: Office Tools is a crucial topic that focuses on enhancing students’ understanding of various office productivity tools. In this chapter, students are introduced to popular office tools such as word processors, spreadsheets, presentation software, and databases.
The chapter delves into the functionalities of each tool and educates students on their practical applications in real-world scenarios. Students learn how to create professional documents, develop complex spreadsheets, design captivating presentations, and manage data efficiently using these tools.
Packed with practical exercises and examples, PSEB Class 12 Computer Education Chapter 1 equips students with the necessary skills to navigate and utilize office tools effectively. It emphasizes the importance of digital literacy and prepares students for successful careers in various fields that require proficiency in office tools.
By mastering this chapter, students gain a competitive edge in the digital era and develop essential skills that are highly sought after in the professional world.
Table of Contents
Office Tools
Que:1 Multiple Choice Questions:
I. Which of the following is an example of office tool?
a. MS Word b. Google Slides c. MS PowerPoint d. All of these
II. Which of the following is the example of Word Processor?
a. Google Docs b. Google Sheets c. Google Drive d. MS Excel
III. Which of the following is not an example of Google’s Online Office Tool?
a. Google Slides b. Google Docs c. OpenOffice Writer d. Google Sheets
IV. Which softwares are designed to operate, control and extend the processing capabilities of the
computer itself?
a. Application Software b. System Software c. Google’s online office tools d. All of these
V. __ is a set of programs that enable a user to perform some specific task.
a. Software b. Hardware c. Language Translators d. Prog. Languages
VI. After setting the option “Anyone with the link”, we can set one of the following access levels using the drop-down menu for sharing the file created in Google Docs?
a. Viewer b. Commenter c. Editor d. Any of these
Que:2 Fill in the Blanks
Q1 Application Softwares are also known as ________
. End-User Applications
Q2 System softwares are usually written in _ Computer Programming Languages.
Low-Level Programming languages
Q3 Various types of Office Tools also fall in the category of __ softwares.
Application Softwares
Q4 ____is a software that allows users to process and analyze tabular data easily.
Spreadsheet
Q5 ____ is a free online word processor.
Google Docs
Que:3 Short Answer Type Questions
Que:I Define the term Office Tools?
Ans: Those softwares which are designed to make computer users more productive and efficient at their workplace, are known as Office Tools. Office Tools includes some application softwares such as Word Processors, Spreadsheets, Presentation softwares etc. These tools help users to save their large amount of time and effort.
Que:II What is Application Software?
Ans: Applications softwares are also known as End-User Applications. These softwares are mostly designed and developed to perform specific tasks for users. These softwares are usually written in various types of High-Level Programming languages. Application software cannot run without the support of Operating System. MS Word, Excel, PowerPoint etc. are the examples of Application Softwares.
Que:III Write some examples of Word Processor Tools?
Ans: Examples of Word Processor Tools/Software are given below:
Microsoft Word
Google Docs
OpenOffice Writer
WordPad
Word Perfect
Que:IV Write about Multimedia Tools.
Ans: Multimedia is a form of communication that combines different forms of contents such as text, audio, images, animations, or video into a single presentation. Multimedia tools allow users to create multimedia applications/contents using various forms of contents. Adobe Flash, Media Players and Real players are the examples of multimedia tools.
Que:V Explain Google Docs.
Ans: Google Docs is a free online word processor. It is a Web-based document management application for creating and editing documents. It helps us in real time online word processing. Google Docs allows us to export its document file in all major file types including .docx, .pdf, .odt, .rtf, .txt, and .html.
Que:4 Long Answer Type Questions
Que:I What are Softwares? Explain different types of softwares?
Ans: Software is a set of programs that enable a user to perform some specific task or used to operate a computer. Without software, a user can’t perform any task on a computer. Software can be divided into mainly two types:
Application Software and System Software.
System software: System software is a collection of system programs. These softwares are designed to operate, control, and extend the processing capabilities of the computer itself. These softwares are usually written in Low-Level Computer Programming languages.
Some examples of system software are Operating System, Language Translators, etc.
Applications software: Applications softwares are also known as End-User Applications. These softwares are mostly designed and developed to perform specific tasks for users. These softwares are usually written in various types of High-Level Programming languages. Application software cannot run without the support of Operating System. MS Word, Excel, PowerPoint etc. are the examples of Application Softwares.
Que:II What are the advantages and disadvantages of using online office tools?
Ans: Following are some of the common advantages and disadvantages of using online office tools:
Advantages of Using Online Office Tools:
● The cost of using online office tools is either very low or there is no specific charge for using these services.
● There is no need to download or install these online tools/software.
● Online office tools can run on thin clients (N Computing) with minimal hardware requirements.
● Online office tools provide the ability to share files.
● Online office tools are portable.
Disadvantages of Using Online Office Tools:
● For accessing these tools, high speed internet connectivity is required always.
● There is a lack of advanced features in the online tools as compared to offline tools.
● The user has no control over the version of the software used.
Que:III Compare Offline and Online Office Tools.
Ans: Following table shows the comparison between Offline and Online Office-Tools:
Offline Office Tools Online Office Tools
| Offline Office tools | Online Office tools |
| 1. No internet connection is required for using thesetools | Internet connection is required for using these office tools. |
| Files created in offline office tools are stored in the local storage of computer system | Files created in online office tools are stored on the cloud storage. |
| Files can be accessed only on the local computer system where they are stored | Files can be accessed from anywhere in the world as files are stored at online storage media |
| Files cannot be shared easily. | File can be shared easily using inbuilt options. |
| Multiple people cannot work easily on the same file created in these Apps. | Multiple people can work on the same file created in these Apps. |
| Examples: MS Word, Excel, PowerPoint etc | Examples: Google Docs, Google Sheets, Google Slides etc. |
EXTRA QUESTIONS CH 1 OFFICE TOOLS
PSEB 10th Class Computer Guide Office Tools Important Questions and Answers
Multiple Choice Questions
Question 1. What are the types in which PowerPoint files can be saved?
(a) PDF
(b) Video file
(c) Presentation
(d) All of the above
Answer:
(d) All of the above
Question 2. What are the extension of an image file?
(a) .jPg
(b) .gif
(c) .bmp
(d) All of the above
Answer:
(d) All of the above
Question 3. Which one is system software?
(a) Word
(b) Excel
(c) Windows
(d) PowerPoint
Answer:
(c) Windows
Question 4. Mail merge is a feature of which software?
(a) Word
(b) Excel
(c) Windows
(d) PowerPoint
Answer:
(c) Windows
Question 5. Which one is not a type of office tools?
(a) Word Processing
(b) DBMS
(c) Multimedia Software
(d) None of these
Answer:
(d) None of these
Fill In The Blanks
1. Word processing tool prepares ………….. .
Answer: Documents
2. Theme helps to choose ……………… in PowerPoint.
Answer: Background
3. …………. is pre defined document structure.
Answer: Template
4. ……………is used for calculation.
Answer: Excel.
True Or False
Question 1. Application software is used for specific work
Answer: True
Question 2. Any document can have two orientations.
Answer: True
Question 3. Presentation can be saved as PDF.
Answer: False
Question 4. We cannot do calculations in Excel.
Answer: False
Question 5. Page margins are empty space in mid of page.
Answer: False
Very Short Answer Type Questions
Question 1. What are the different type of Softwares?
Answer: System Software and Application Software.
Question 2. Beneficial software for our work are called?
Answer: Office tools.
Question 3. Note pad is an example of?
Answer: Word processing tool.
Question 4. Give an example of spreadsheet software.
Answer: MS Excel.
Question 5.mPowerPoint is an example of?
Answer: Presentation tool.
Short Answer Type Questions
Question l. What are Page Margins?
Answer: Page margins pre the blank space around the edges of the page. In general, we insert text and graphics in the printable area inside the margins. When we change a document’s page margins, we change where text and graphics appear on each page.
Question 2. Write steps of setting predefined page margins.
Answer:
- On the Page Layout tab, in the Page Setup group, click Margins. The margins gallery dropdown menu Will appear.
- Click the margin type that we want to apply
Question 3. Write steps to change Page Orientation.
Answer:
- On the Page Layout tab, in the Page Setup group, click Orientation.
- Click Portrait or Landscape.
Question 4. Write steps to apply different page orientations.
Answer:
1. Select the pages or paragraphs that we want to change to portrait or landscape orientation.
2. On the Page Layout tab, in the Page Setup group, click Margins.
- Click Custom Margins at the bottom of the dropdown menu.
- A Page Setup dialog box will appear.
- On the Margins tab, click Portrait or Landscape.
- In the Apply to list, click Selected text or This point forward.
Question 5. Write steps to apply custom margins.
Answer:
- On the Page Layout tab, in the Page Setup group, click Margins.
- At the bottom of the margins gallery dropdown menu, click Custom Margins.
- The Page Setup dialog box will appear.
- Enter new values for the margins in all or some of the top, bottom, left or right text boxes.
- Click OK.
Question 7.mExplain PPT broadcast slide show.
Answer: PowerPoint 2010 offers users to broadcast their presentations on the internet to audience worldwide. Microsoft offers the free broadcast Slide Show service; all we need to do is share the link with our audience and they can watch the presentation from anywhere. There is no special setup or charges required to do this, all we need is a Windows Live account.
Question 8. What is PPT Packaging Presentation?
Answer: Certain presentations are better suited for distribution as a CD to audience. In such cases, we can create a CD packaging which can be burned into a CD and distributed. These CDs are called PPT packaging presentation.
Long Answer Type Questions
Question 1. Write steps to save a presentation as a Video file.
Answer: Saving Presentation as Video File:
PowerPoint allows presentations to be saved as files that can be posted on video sharing platform like YouTube or just played on any other-media.
Steps to save a presentation as a video file are:
- Go to the backstage view under the File tab.
- Click on Save As to open the Save As dialog.
- Add a proper name to the file.
- Select the file type as .wmv from the list of supported file types and click Save.
- The video creation is not an instant process like other file types as PowerPoint needs to create the video file. We can track the progress of video creation at the bottom of our presentation window.
- Once the creation is complete, the video file is created in the specified location.
Question 2. What are the steps of clearing Tab stops.
Answer:mClear Tab Stops: We can clear tab stops in a variety of ways, the simplest is going to the ruler, click and hold on the tab stop and drag in down towards the document. The tab stop will disappear. To quickly clear multiple tab stops and start fresh:
- Click the Home tab, click the Paragraph Dialog Box Launcher.
- A Paragraph box will appear, click on the Tabs button at the bottom left of the dialog box.
- A Tabs dialog box will appear.
- In the list under Tab stop position, click the tab stop position that we want to clear, and then click Clear. To remove the spacing from all manual tab stops, click Clear All.
- Click OK.
Question 3. What are the ways to use Spell Check feature?
Answer: Using the “Spell Check” Feature:
As we type our document, red wavy lines will appear under any word that is spelled incorrectly. The fastest way to fix spelling errors is to:
- Put the cursor over the misspelled word and right click.
- A drop down box will appear with correct spellings of the word.
- Highlight and left click the word you want to replace the incorrect word with.
To complete a more comprehensive Spelling and Grammar check, we can use the Spelling and Grammar feature:
- Click on the Review tab.
- Click on the Spelling & Grammar command.
- A Spelling and Grammar box will appear.
- We can correct any Spelling or Grammar issue within the box.
Question 4. Write steps to print a document.
Answer:mPrint Command:
The Print tab is the place to go to make sure that we are printing what we want.
- Click the File tab.
- Click the Print command to print a document.
- Click the Print button to print your document.
- This dropdown shows the currently selected printer. Clicking the dropdown will display other available printers.
- These dropdown menu show currently selected Settings. Rather than just showing us the name of a feature,, these dropdown menu show us what the status of a feature is and describes it.
Question 5.mWrite a note on Transition in PowerPoint.
Answer: Transitions in MS – Power Point:
PowerPoint supports slide transition feature which allows us to specify how the slides should transition during the slide show.
PowerPoint presentation that had special effects between each slide, are slide transitions. A transition can be as simple as fading to the next slide or as complex as a flashy effect. This means we can choose transitions to fit the style of any presentation. There are three categories of unique transitions to choose from, all of which can be found on the Transitions tab:
1. Subtle (slight transitions)
2. Exciting (Strong Transition)
3. Dynamic Content (strong transitions that affect only the content, such as text or images)
The steps to add and preview slide transitions are:
1. Select the slide to which we want to apply the transition.
2. Go to the Transition Scheme under the Transitions ribbon.
3. Select one of the transition schemes from the list available. PowerPoint will instantly show us a preview of the scheme. If we are not satisfied, we can pick an alternate scheme. The last selected scheme will apply to the slide.
4. We can change the effects on the selected transition scheme from the Effect Options menu. Every scheme has a unique set of effect options.
We can also modify the transition timing settings from-the Timing section. To preview the slide transition, click on Preview.