4, SHORT ANSWER TYPE QUESTIONS : Ae SHORN Neer eee ee Ans. I. I. Ans. IV. Ans. What is Excel ? Microsoft Excel is a powerful electronic spreadsheet program used to create results, doing mathematical calculations and representing data in form of charts. Excel is designed to perform calculations, analyse information, and visualize data ina spreadsheet. Explain formatting in details. Formatting refers to changing the font style, size, color, bold, italic, underline ‘and other related parameters ; we can also use Format Painter option available at Home tab to apply existing formats to other text. Explain Print and Print Preview options. Print preview is a feature that displays on the: screen what a hard copy would look like when printed. Steps to preview our documents are : 1. Click on the File tab. 2. By Clicking Print (Ctrl + P) option, it will show preview. 3, Select number of copies, page range, collate etc. 4. Click on the Print button to get the print hard copy of our document. What are formulas in MS Excel ? ; A formula is an equation that makes calculations based on the data in your spreadsheet. Formulas are entered into.a cell in the worksheet. They m must begin ” with an equal sign, followed by the addresses of the all.OFFICE AUTOMATION & TYPING = Example Formulas are : =DI15 + D18 + D21, = B4-B12, = A10/B15,=(B16 + C16)*1.07 V. What do you know about the formula bar in Excel ? Ans. FORMULA BAR isthe most important components in MS Excel. It is the area at the top of the Excel window, just below the ribbon area. It is used to edit formulas and also be used to modify the ranges for individual data series that are selected in an Excel Chart. The formula bar gets activated as soon as you type an equal sign in any cell or click anywhere with in the bar. The formula bar has two parts : Name Box at the left side and right side where the entered content will be shown . VI. What are margins ? Ans. A margin is the space between the text and the edge of our document and margins are the blanks spaces between text and the top, bottom, left. and rigt edges of a document. It can be used to select one of three pre-set margins for the report, Sat Steps to change Page Margins : 1. Click on the margins tab in the page setup Dialog Box. 2; Set the Top, Bottom, Left and Right Margins as per requirement. 3. Click OK button to apply changes. PART—C 5. LONG ANSWER TYPE QUESTIONS : I. What are word processors ? Explain their uses. Ans. A word processor is software that provide for input, editing, formatting and output of tax, including creating, saving and printing documents. It enables us to write text, store it electronically, display it on a screen, modify it by entering commands and characters from the keyboard and print it. Uses of Word processor : 1. To create business docunients having various graphics including (pictures), (charts) and diagrams,24 I. Ans. Proofing helps to create errorless and accurate documents. ! .d elements such as (cover 2. To store and reuse readymade content and formate pages) and (sidebars). 3. To create letterheads for business and for personal purpose- 4. To design different document such as (resumes) or (invitation cards) etc. Describe the proofing options in MS Word. ® In MS-Word, there are many number of proofing tools. Under proofing you can correct spelling, correct the word, format text and grammar, hide spelling and grammar errors. Proofing icon present at the status bar tells if there is some proofing or not. To make word proofread our document, follow the steps given below = Auto Correct 1. Click on File Tab. 2. Click on Options. 3. Word Options dialog box will appear. 4. Click proofing option in the side bar 5. Click Auto Correct Options. Add entry to an Auto Correct list : * Go to Auto Correct tab * Inthe Replace box, type a word or pharse that you often misspell. * With in the box, type the correct spelling of the word. * Select Add. Spelling and’ Grammer : Under this option syou can check spelling and grammatical errors. It Shows redwavy underline for spelling errors and the greenwavy underline for grammatical errors, bluewavy underline for formatting inconsistencies. In order to check the spelling and grammar in our file press F7 and follow the given steps : 1. Click Review tab 2. Click (Spelling) or (Spelling & Grammer) * A dialog box appear if any misspelled word found. * Afier the first misspelling is resolved then program moves-to the next misspelled word.OFFICE AUTOMATION & TYPING TIL. Ans. 25 Explain the Page Setup nd Printing Options available in Excel. Page setup can make a world of difference, Excel gives lots of options for setting “up of our page. The page setup group ‘of the page layout tab contains the . following important command buttons in Excel. 1. Margi : It can be used to select oné of the three pre-set margins for the Teport or to set custom margins on the Margins tab of the Page Setup dialog box . 2. Orientation ; It is used to switch between portrait and landscape mode for printing. 3. Size : It is used to select one of the pre-set paper sizes, set a custom size or change the printing resolution or page number on the page tab of the Page Setup dialog box. 4. Background : It is used to open the sheet background dialog box where we can select a new graphic image or photo to use as a background for the current worksheet. 5. Print titles : It is used to open the sheet tab of the page setup dialog box where you can define rows of the worksheet to repeat at the top and column. of the worksheet to repeat at the left as Print titles for the report. What are functions in Excel ? Explain any two functions with example. - 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 find the sum, average, count, maximum value, and minimum value for a range of cells. Steps for using a funeti 1, Select an empty cell. Type an equal sign = and then type a function: Type an opening parenthesis i.e.( Select the range of cells , and then type a closing parenthesis i.e.) yeep Press enter to get the result.ACCURATE COMPUTER SCIENCi xu - Commonly used Functions : 1. SUM : The Excel SUM function returns the sum of values supplied. The SUM function adds values. Syntax : = SUM [Number i, [Number 2], [number 3], ....--] 2.. COUNT : The COUNT Function counts the number of cells the contain numbers and counts numbers within the list of arguments. Syntax : = COUNT (value 1, [Value 2], ....)- V. 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. 1. Touch Typing : Touch typing is a technique by which we can learn typing wwith'all fingers, step by step, without having to look down at the keyboard. It will increase the typing speed. 2. "Voice Typing : Voice Typing is a type of speech recognition program that converts spoken to written language. The speech — to-text converter is speech recognition software by which the software takes users speech as input and converts this speech input to téxt.