Please refer to Office Automation & Typing Class 12 Computer Science Important Questions with solutions provided below. These questions and answers have been provided for Class 12 Computer science based on the latest syllabus and examination guidelines issued by CBSE, NCERT, and KVS. Students should learn these problem solutions as it will help them to gain more marks in examinations. We have provided Important Questions for Class 12 Computer Science for all chapters in your book. These Board exam questions have been designed by expert teachers of Standard 12.
Class 12 Computer Science Important Questions Office Automation & Typing
Very Short Answer Type Questions :
Question: Write the name of four types of alignments.
Ans: Left, Center, Right, Justify
Question. Write the name of any two fonts that can be used to type in Punjabi Language.
Ans: AnmolLipi, Raavi, Joy, Asees
Question: Write the full form of WYSIWYG.
Ans: What You See Is What You Get
Question: Which Excel function is used to combine contents from different cells into one cell?
Ans: Concatenate()
Question: Write the Short cut keys to move text in Word Document.
Ans: Ctrl+X , Ctrl+V
Short Answer Type Question:
Question: What are Margins?
Ans: A margin is the space between the contents and the edge of our document. We can set the margins at all the sides (Top, Bottom, Left, Right) of the page. By default, a new document’s margins are set to Normal, which means it has a oneinch space between the contents and each edge. Word allows us to change the margin size in our document as per our requirement.
Question: Explain Print & Print Preview options.
Ans: Print preview is a feature that displays on the screen what a hard copy would look like when printed. When we click the Print option in File menu, it automatically will show the preview of our document. It means Print Preview option is used to preview our document on the screen before getting its hard copy while Print command is used to get the hardcopy of our document by printing it on the paper.
Question: What is Excel?
Ans: Microsoft Excel is a powerful electronic spread sheet program. Usually, we can use it to automate accounting work, organizing data, and for performing a wide variety of tasks. We can use it to prepare results, doing mathematical calculations and representing data in pictorial form with the help of charts.
Question: Explain formatting in details?
Ans: Formatting refers to changing the font style, for example: increasing or decreasing the font size, performing bold, italic and underline operation on text. We can change the appearance of text and graphics with the help of formatting options. Text Formatting options are available on the Home tab in MS Word/Excel/PowerPoint.
Question: What do you know about the formula bar in Excel?
Ans: Formula Bar is one of the most important components of MS Excel. The Formula Bar is available at the top of the Excel window, just below the ribbon area. The Formula Bar has two parts: left and right side. Left side is Name Box which shows the name or address of current selection while right side shows the contents of the currently selected cell.
Question: What are formulas in MS Excel?
Ans: In MS Excel, Formulas are used to perform different types of calculations. Formulas can be used to perform different types of calculation for preparing results and fee related data. In Excel, a formula always begins with equals to (=) symbol. Usually, we use cell references in formulas along with the operators to perform calculations. Some of the examples of formulas are:
=D15+D18+D21
=(B16+C16)*1.07
Long Answer Type Question:
Question: Explain the various methods of Typing?
Ans: Typing is the process of writing or inputting text by pressing keys on a typewriter, computer keyboard, cell phone, or calculator. Text can be in the form of letters, numbers and other symbols. For typing on computer system, we can use the following techniques:
• Touch Typing: Touch typing is a technique by which we can learn typing with all fingers, step by step, without having to look down at the keyboard. It helps us to increase our typing speed. Any typing-tutor software can be used for learning this technique.
• Voice Typing: In this type of typing technique, speech recognition programs are used for typing that converts spoken words into text. Voice-to-text technique was originally developed as an assistive technology for the visually impaired or handicapped persons. For typing in punjabi language, we usually use Lipikar punjabi app in mobiles.
Question: Describe the Proofing options in MS Word?
Ans: Word can also proof read our document to highlight other possible mistakes. For example: misplaced commas or correctly spelled words that may be used incorrectly etc can be highlighed using Proofing option. To make word proof read our document, Click the Proofing icon at the bottom of the document window. Following are the options that can be used for proofing:
• Auto Correct: This option helps us to replace a misspelled word with the correct one automatically during typing text.
• Spelling and Grammer: MS Word also helps us to find and correct grammer and spelling errors in our document. Word displays a red wavy line under the misspelt word while green
wavy line is used to show the gramatical error in the document. A new blue wavy line has also been added in the new versions of word which represents the formatting inconsistency. For checking and correcting spelling and grammer mistakes, function key F7 can be used.
Question: What are Word Processors? Explain their uses.
Ans: A word processor is an application software that is used to prepare different types of documents. MS Word and WordPad are the common examples of word processors. Common uses of Word Processors are explained below:
• To prepare documents, letters etc.
• To format the documents.
• To prepare letterheads for personal and business purpose.
• To design different types of documents such as resumes or invitation cards etc.
Question: What are functions in Excel? Explain any two functions with example.
Ans: A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly perform
calculations, for example: SUM, AVERAGE, COUNT, MAX and MIN etc. Following is the explanation of two functions:
• MAX: This function is used to find the largest numeric value from a range of values. It ignores empty cells, the logical values TRUE and FALSE, and text values. Example: =MAX(A1:C1)
• MIN: This function is used to find the smallest numeric value from a range of values. It ignores empty cells, the logical values TRUE and FALSE, and text values. Example: =MIN(A1:C1)
Question: Explain the Page Setup and Printing Options available in Excel.
Ans: Page Setup allows us to change the structure and layout of pages in a document. The “Page Setup” group on the “Page Layout” tab contains buttons that allow us to make changes in the page setup of document. Using these options, we can change the margins, page orientation (portrait or landscape), paper size (A4, Legal, Letter) etc. We can do these operations using the Page Setup dialog box. This dialog box can be opened by clicking on the dialog launcher icon present at the bottom-right corner of Page Setup group.
Printing options include Print Preview and Print commands. Print preview is a feature that displays on the screen what a hard copy would look like when printed. When we click on Print option in File menu, it automatically shows the preview of our document. It means Print Preview option is used to preview our document on the screen before getting its hard copy while Print command is used to get the hardcopy of our document by printing it on the paper.
