Prasanna

You can Download Chapter 15 Word Processing Questions and Answers, Notes, 1st PUC Computer Science Question Bank with Answers Karnataka State Board Solutions help you to revise complete Syllabus and score more marks in your examinations.

Karnataka 1st PUC Computer Science Question Bank Chapter 15 Word Processing

1st PUC Computer Science Word Processing One Mark Questions and Answers

Question 1.
Define word processor.
Answer:
Word Processor is an application software that enables you to create, edit, print and save documents for future retrieval and reference.

Question 2.
Mention any two general word processing software.
Answer:

1. Word perfect
2. MS Word

Question 3.
Mention anyone important feature of a word processor.
Answer:
In a document file, you can make changes without retyping the entire document. If you make a typing mistake, you simply back up the cursor and correct your mistake.

Question 4.
What is the general default extension file name for word documents?
Answer:
The default extension file name for word documents is *.doc.

Question 5.
What does the title bar contain?
Answer:
The title bar contains filename, extension file name and application name.

Question 6.
Define menu in a window.
Answer:
A menu is a collection of options that perform specific activities on the document.

Question 7.
What does the toolbar contain?
Answer:
The toolbar contains various tools or shortcut buttons, that are used in document processing activities.

Question 8.
What is the use of vertical scroll bar?
Answer:
The vertical scroll bar is used to view the contents by moving the page upwards or downwards on the screen.

Question 9.
What is the use of horizontal scroll bar?
Answer:
The horizontal scroll bar is used to view the contents by moving the page towards left or right sides of the screen.

Question 10.
What is the function of a ruler in a word processor?
Answer:
The ruler bar allows the user to format the vertical alignment of text in a document.

Question 11.
What is workspace?
Answer:
Workspace is the area in the document window where users enter/type the text of a document.

Question 12.
Give the procedure to create a document file.
Answer:
The document file can be created using the ‘file’ menu with option ‘new’ or by pressing the keyboard keys Alt + F and select ‘New’.

Question 13.
What are the shortcut keys to create a document file?
Answer:
The shortcut keys to create a document file are Ctrl+N.

Question 14.
What are the shortcut keys to open a document file?
Answer:
The shortcut keys to open a document file are Ctrl+O and choose the filename from the list.

Question 15.
How is a file closed in word processor?
Answer:
The file can be closed by selecting close in the file menu.

Question 16.
How is a word processor software closed?
Answer:
The word processor software is closed by selecting the ‘exit’ option from the file menu.

Question 17.
Define formatting.
Answer:
Formatting is the process of changing the attribute of a text, document.

Question 18.
What is a font style?
Answer:
A font style is a list of predefined font name, size, and alignment for various kinds of text elements.

Question 19.
What is the use of font dialogue box?
Answer:
The font dialogue box contains the tool buttons like font name, font size, font bold, etc.,

Question 20.
Write the utility of clipboard.
Answer:
Clipboard is used to place the previously done activities so that they can be recalled or redone.

Question 21.
What are bullets?
Answer:
Bullets are special symbols that can be used in a list of items.

Question 22.
What is a header?
Answer:
A header is a special area a|the top of every page normally allocated in the top margin area.

Question 23.
What is a footer?
Answer:
Footer is a special area at the bottom of every page normally allocated in the bottom margin area.

Question 24.
Where are page numbers inserted in word processor?
Answer:
The page numbers can be inserted either in top or bottom margins.

Question 25.
What is spell checker?
Answer:
A utility that allows he user to check the spelling of the words. It will highlight the words that it does not recognize.

Question 26.
Define a table.
Answer:
A table is a collection of rows and columns.

Question 27.
What is the use of a print preview option?
Answer:
The print preview option allows the user to view the document content as to how it will get printed on the paper, before actually printing it.

1st PUC Computer Science Word Processing Two/ Three Marks Questions and Answers

Question 1.
Write any two advantages of a word processor.
Answer:
Two advantages of word processor are

1. Font size and type of fonts can be changed.
2. Spelling can be checked and corrections can be made automatically in the entire document.

Question 2.
Mention any two important features of to latest popular word processor software.
Answer:
Two important features of the latest popular word processor software are,

1. One can publish a word document file as a PDF file.
2. Attach a digital signature to a word document.

Question 3.
Write the procedure to load word processor software.
Answer:
In windows, to load MS word it is done as follows;

1. Click on the start button
2. Select all programs
3. Select MS Office
4. Select MS Word

Question 4.
Explain the use of scroll bar and status bar.
Answer:
1. Status Bar:
The status bar displays information about the currently active document. This includes the page number one is working, the column and line number of the cursor position and so on.

2. Scroll Bar:
The scroll bar helps user scroll the content or body of document. One can do so by moving the elevator button along the scroll bar, or by clicking on the buttons with the arrow markings on them to move up and down and left and right of a page.

Question 5.
What is the difference between save and save as option?
Answer:
The ‘save’ option is used to save the active file under the current file name, whereas save as can be used to save the file with a new name and in a new location.

Question 6.
Write the procedure to open a document file.
Answer:
The procedure to open a document file is as follows:-

1. Load MS Word
2. Select file menu
3. Select open option
4. Select the file from the list

Question 7.
Explain copy and paste.
Answer:
Copy option is used to select the text for taking a copy and paste is used to insert the selected copy of the text at any chosen location.

Question 8.
Explain cut and paste.
Answer:
The cut option is used to select the text for move and paste is used to insert the selected text in the document. The test is removed from its earlier place.

Question 9.
Give the difference between undo and redo.
Answer:
‘Undo’ option cancels the last action done on the document, whereas redo repeat on redoes the last action done on the document.

Question 10.
What is the sequence of short cut keys to copy and paste?
Answer:
The sequence of short cut keys to copy and paste is Ctrl+C for copy and Ctrl+V for paste.

Question 11.
What is the sequence of short cut keys to cut and paste?
Answer:
The sequence of short cut keys to cut and paste is Ctrl+X for cut and Ctrl+V for paste.

Question 12.
Name the two types of GUI Windows.
Answer:
The two types of GUI windows are

1. Fixed windows and
2. Popup windows

Question 13.
How is a document file created?
Answer:
A document file can be created using the following procedure
File Menu → New option.

Question 14.
Name two important options of the File menu.
Answer:
The two important options of the file menu are open a document and exit option.

Question 15.
Give the short cut keys to create a new file and open a file.
Answer:
The short cut keys to create a new file is Ctrl+N and Ctrl+O to open a file.

Question 16.
What is the use of page setup option?
Answer:
The page setup option is used to select the paper size and paper orientation.

Question 17.
Mention any two options of print window.
Answer:
Two options the print window are page range and number of copies.

Question 18.
Write the options of page range in print window.
Answer:
The options of page range in print window are

1. print all
2. print selected
3. current page
4. pages

Question 19.
Mention any two options of the edit menu.
Answer:
Copy, paste and paste special are the important options of the edit menu.

Question 20.
Write the uses of find and replace option of edit menu.
Answer:
The find option is used to search for a specific text and the replace option is used to replace the searched text with a new text.

Question 21.
What is the difference between normal view mode and page layout view mode?
Answer:
If the document get consists of graphical picture and text then in the normal mod 2 the graphical picture cannot be displayed. They can only be displayed in page layout mode.

Question 22.
Name any two options of insert menu.
Answer:
Two options of insert menu are

1. Page break
2. Tables
3. Chart/spreadsheet

Question 23.
Explain page break.
Answer:
The word processor inserts a new page at the end of the current page automatically. If the user wants to end the page somewhere before the end of the current page, then a page break is used to break the page and take the cursor to the top of a new page.

Question 24.
Give the difference between clipart and word art.
Answer:
Clipart contains readily available graphical images in different categories. It consists of colorful images with rich graphics. Word art is an application of text, that can be presented as graphical rick text. The graphical text can be filled with effects, shown upside down, wavy texts, text in arch shape, etc.,

Question 25.
What are subscripts and superscripts?
Answer:
The subscript is a character that appears below the text baseline. For example, H₂O. In H₂O, the letter 2 appears below the baseline and these are called subscript letters.

The superscript is a character that appears above the text baseline. For example, a^{2 + 1}. In a^{2 + 1}, ^{2 + 1} appears above the baseline and these are called superscript letters.

Question 26.
What are columns in a word processor? How is a columns inserted in a document? Explain.
Answer:
Columns divide a page vertically into separate areas to insert text. To insert columns use the following procedure.
Select format menu → column option → number of columns as 2 → press OK button.

1st PUC Computer Science Word Processing Five Marks Questions and Answers

Question 1.
What are the advantages of a word processor?
Answer:
The following are the advantages of a Word Processor.

1. Text is inserted by typing into the computer, which allows alterations to be made easily.
2. Words and sentences can be inserted, changed or deleted.
3. Paragraphs or text can be copied /moved throughout the document.
4. Margins and page length can be adjusted as required.
5. Spelling can be checked and modified through the spell check facility.
6. Multiple document/files can be merged.
7. Multiple copies of letters can be generated with different addresses through the mail- merge facility.
8. Drawings, clip art, and chart can be inserted in the document.

Question 2.
Draw the screen layout window of a word processor. Label the parts and explain.
Answer:
Screen layout window of a word processor

1. Title Bar:
The title bar displays the name of the currently active word document.

2. Tool Bars:
MS Word has a number of toolbars that help the user perform tasks faster and with great ease. Two of the most common toolbars are the formatting toolbar and the standard toolbar.

3. Ruler Bar:
The Ruler Bar allows the user to format the vertical alignment of text in a document.

4. Status Bar:
The Status Bar displays information about the currently active document. This includes the page number that one is working, the column and line number of the cursor position and soon.

5. Scroll Bar:
The Scroll Bar helps to scroll the contents or body of the document, user can do so by clicking on the buttons with the arrow marked on them, to move up or down and left or right in a page.

6. Workspace:
The Workspace is the area in the document window used to enter/type the text of document.

7. Main Menu:
The Word main menu is displayed at the top of the screen as shown. The main menu further displays a sub-menu. Some of the options are highlighted options and some of them appear as faded options. At any time, only highlighted options can be executed, faded options are not applicable.

In fact, if the option is faded user will not be able to choose it. option faded under the current situation may become highlighted under different situations and become executable.

Question 3.
How is a document file created? Explain.
Answer:
To load MS Word user has to the click on start button → all programs → office 2007 → Word 2007. Then the document can be created by clicking on file from the menu bar and then selecting New option from the list. MS-Word will prompt to choose a document or a template. The shortcut key for the same operation is Alt+F to open the file option from the main menu.

Then the default Document and General and then is to be chosen. OK. Clicked on A blank document sets displayed to enter the text. MS-Word gives a temporary name to this file as ‘Document 1 ’, until the user saves that document with a file name. Instead of clicking on File and New, user can directly open a new document by clicking at the NEW icon on the standard toolbar.

Question 4.
Explain the various tools of formatting the toolbar.
Answer:
1. Font:
It displays different styles of fonts available for the use by displaying their names. For example, times new roman, Arial, etc.,

2. Font size:
The text size can be increased or decreased by selecting the numbers displayed in the font size. Font size is measured in points.

3. Boldface:
Select the text to have boldface and click on the Boldface button from the formatting toolbar.

4. Italics:
Select the text to have italics and click on the Italics button from the formatting toolbar.

5. Underline:
Select the text to have underline and click on the Underline button from the formatting toolbar Boldface, Italics and Underline buttons toggle between on and off. When the user wants to remove boldface, italics or underline, they can select the text again and click on Boldface, Italics or Underline button to remove it.

6. Subscripts and Superscripts:
User can add subscripts and superscripts to any typed text. First, the text to be shown as subscript or superscript is highlighted. Then x₂ or x² button for subscript/superscript is clicked upon.
Examples:
Superscript 40^th
Subscript B_t

7. Text background color and font color:
User can select a color for the text background and for text also. There are two tool buttons in format tools bar to give background color to the selected text and to give a different color to the selected text.

Question 5.
Write a note on text alignments.
Answer:
Alignment is arranging/inserting the text towards the left, right or center. By default, Ms-Word aligns all the text as left-aligned.
1. Left-aligning Text:
The paragraph a text to be aligned is selected and the left align tool from the formating toolbar is clicked upon to get the text aligned to the left, as shown.

2. Right-aligning Text:
The paragraph or text to be aligned is selected and the right align tool from the formatting tool basis clicked upon to get the text aligned to the right, as shown.

3. Center-aligning Text:
Center alignment moves the selected text and adjusts it to the center of the line. The paragraph or text is selected and the centre align tool from the formatting toolbar is clicked upon to get the text aligned at the centre, as shown.

4. Justification:
After aligning the text, user may like to justify the whole paragraph. For that, the paragraph of the text and is selected clicked upon the Justification Tool from the Formatting toolbar to get the entire paragraph aligned.

Question 6.
Write a short note tables.
Answer:
Sometimes there will be need to present data and information in a tabular form while preparing reports along with the text. MS-Word provides a special feature called Table which helps to present the information in a tabular form.
1. Creating a Table:
To create a table in a document, insert option from the table menu is selected and where the houser wants to insert the table and then Insert Table if is selected after clicking on Table from the menu bar. From the box, the user can specify the number of columns and rows and then click on OK to insert the table. A table consists of vertical columns and horizontal rows as shown above. The intersection of a column and a row is called a cell. Gridlines are displayed between the cells.

2. Entering text into Table:
After creating a table, the user can enter text by clicking on any cell. The Tab key can be used to move to the next cell.

3. Modifying Table:
After creating the table and entering the data. User can still perform various operations on the table, which are described below:

• Inserting Rows and Columns:-
  To insert a row at the end of a table, the cursor is brought to the last cell and the tab is proceed, key. To insert a row within a table is brought the cursor to the row above which the new row has to appear and then the Insert Row option is selected from the Table menu bar.A new row gets inserted above the selected row. To insert a column, column option is selected from the Table menu and then the Insert Column option. A new column will be inserted to the left of the selected column.

• Deleting Rows and Column:-
  To delete one or more contiguous rows in a table, the row(s) to be deleted and then are selected delete Rows options from the Table menu is selected. To delete one or more contiguous columns, the column(s) to be deleted and then are selected Delete Columns option from the Table menu is selected. To delete an entire table, the table is selected and then Delete Rows option is selected from the Table menu.

• Changing column width:-
  To change the column width, when pointed the column boundary that is to be changed, the mouse pointer will become a horizontal double-headed arrow and the column boundary the desired width and the mouse button released.You can also change the column width by selecting the Column and then selecting the option Cell Height and Width from Table menu. Enter the desired width in the Width of Column text box and click on OK to change the column width of the selected column.

• Changing Row Height:-
  To change height of a row, point the row boundary that you want to change, the mouse pointer will become a vertical down headed arrow. Then drag the row boundary to the desired height and then release the mouse button.You can also change the column width by selecting the Row and then selecting the option Cell Height and Width from Table menu. Enter the desired height in the Height of Row text box and click on OK to change the row height of the selected row.

4. Sort:
Using this option any column of the table can be sorted either on ascending or descending order. This is applicable only for the numerical values in the cells of the table.

5. Formula:
For numerical values, user may like to apply different mathematical operations. Using the ‘Formula’ feature of MS-WORD user can calculate the values and insert at the proper places. The column width can also be changed by selecting the column then the option cell width from the table menu. Desired width can be entered in the width of the column text box and clicked upon.

Question 7.
Write a short note on bullets and numbering.
Answer:
Many times there maybe needs to highlight some of the points of the documents in a list format. Such documents may contain list of items to which one would like to call attention and so, such items can be numbered or bulleted. This improves the organization and appearance of the document.
1. Adding Numbers and Bullets
To add numbers to a specific paragraph, Format from the main menu is selected and then on Bullets and Numbering, “numbered” tab is then chosen and the format of the number with OK will get numbers added to the list. In order to assign a numbered style user has to select numbered, and to select a bullet style select bullet from the dialog box and then click on OK to get the new bullet style to the selected text.

2. Removing Number and Bullets
When the users want to remove the numbers or bullets, the list that contains the number or bullets is high lighted and “none” option from Number tool or Bullet tool is clicked upon. This removes the applied number or bullets.

Question 8.
Write a short note on mail merge.
Answer:
Mail merge helps to generate letters by combining contents of one document with the content of addresses. In a situation where a same letter is to be sent to the addresses of many then mail merge is used. Mail Merge requires the main document and a data source document.
1. Main Document:
In Mail Merge, the main document is the common letter, which contains the common information. It also contains the field names, which contains the instructions for carrying out the merge.

2. Data Source:
Data source is also called the data file. It contains information that needs to be inserted in each page of the main document. Normally it contains the address information.

3. Form Letter:
Form letter is the resultant document of the mail merge operations, which contains the copy of the main document along with each piece of information stored in the data file.

You can Download Chapter 1 Overview of Computers Questions and Answers, Notes, 1st PUC Computer Science Question Bank with Answers Karnataka State Board Solutions help you to revise complete Syllabus and score more marks in your examinations.

Karnataka 1st PUC Computer Science Question Bank Chapter 1 Overview of Computers

1st PUC Computer Science Overview of Computers One Mark Questions and Answers

Question 1.
What is a computer?
Answer:
Computer is defined as an electronic machine used for storing, processing and analysing data or information as per a set of instructions given to it by humans

Question 2.
What is computer hardware?
Answer:
The physical components of a computer are called the hardware.

Question 3.
Define program.
Answer:
A computer program is a sequence of logical actions or instructions.

Question 4.
Define programming.
Answer:
A program must contain instructions in a precise order. To organize and write these instructions in a logical order is called Programming.

Question 5.
Define software.
Answer:
A group of programs that are put into a computer to operate and control its activities are called the “software”.

Question 6.
How is the input unit useful to the computer?
Answer:
The user enters the program and data into the computer through the input unit.

Question 7.
that is the main function of the CPU?
Answer:
The main function of the CPU is to translate the program instructions and carry out those instructions in a sequence.

Question 8.
What is the function of ALU?
Answer:
ALU unit performs all the arithmetic calculations and logical operations involved in the program

Question 9.
What is the task of the output unit?
Answer:
The output unit receives information from the CPU and presents it to the user in the desired form.

Question 10.
Define computer memory.
Answer:
The working place in the computer where all the data and instructions are stored is called the memory.

Question 11.
What are the registers?
Answer:
It is a temporary storage location of the CPU.

Question 12.
Name any two output devices.
Answer:
Two output devices are Visual Display Unit (VDU) and Printer.

Question 13.
Name the oldest computing tool.
Answer:
Abacus is the oldest computing tool.

Question 14.
What is the contribution of Prof. John Napier in the field of computers?
Answer:
John Napier invented a calculating device which is a set of 9 marked rods called “Napier

Question 15.
Name the device invented by William Oughtrcd to do computations.
Answer:
The device invented by William Oughtred for computations is the “slide rule”.

Question 16.
Who is the inventor of Pascaline?
Answer:
A French philosopher Blaise Pascal invented “Pascaline” the first mechanical calculator.

Question 17.
Who invented Jacquard loom?
Answer:
Joseph Mary Jacquard invented Jacquard loom.

Question 18.
Who is the father of the computer?
Answer:
Charles Babbage is known as the father of the computer.

Question 19.
Who invented the difference engine?
Answer:
Charles Babbage invented the difference engine.

Question 20.
Who is the first computer programmer?
Answer:
Lady Ada Lovelace was the first computer programmer.

Question 21.
Where was Herman Hollerith machine was used?
Answer:
Herman Hollerith machine was used in a faster way to process the US census in a faster way in the year 1890.

Question 22.
What is the earlier name of IBM?
Answer:
Tabulating Machine Company.

Question 23.
Expand IBM.
Answer:
International Business Machine

Question 24.
Expand the term ENIAC.
Answer:
Electronic Numerical Integrator and Calculator.

Question 25.
Expand the term EDVAC.
Answer:
Electronic Discrete Variable Automatic Computer.

Question 26.
Who developed the stored program concept?
Answer:
John von Neumann developed the stored program concept.

Question 27.
Expand the term UNIVAC.
Answer:
UNIVersal Automatic Computer.

Question 28.
Name the main electronic component used in I generation computer systems.
Answer:
“Vacuum Tube” was the main electronic component used in the first generation computer system.

Question 29.
Name the language used in the first generation of computers.
Answer:
Machine language was used in the first generation of computers.

Question 30.
What is the processing speed of first-generation computers?
Answer:
The processing speed of first-generation computers was in milliseconds.

Question 31.
Name the main electronic component used in II generation computer, systems.
Answer:
The main electronic component of second-generation computer systems was a transistor.

Question 32.
What is the processing speed of Second-generation computers?

Answer:
The processing speed of Second-generation computers was in microseconds.

Question 33.
Expand the terms COBOL and FORTRAN.
Answer:
Common Business Oriented Language and Formula Translation.

Question 34.
Name the main electronic component used in III generation computer systems.
Answer:
Integrated Circuit chips were the main electronic components used in the third generation computers.

Question 35.
What is the processing speed of third-generation computers?
Answer:
Nanoseconds are the processing speed of third-generation computers.

Question 36.
Name the main electronic component used in IV generation computer systems.
Answer:
LSICs and VLSICs are the electronic components used in IV generation computer systems.

Question 37.
What is the processing speed of fourth-generation computers?
Answer:
Pico seconds is the processing speed of fourth generation computers.

Question 38.
What is a microprocessor?
Answer:
The CPU of a computer system in which thousands of integrated circuits are built onto a single silicon chip is called a microprocessor.

Question 39.
What is the working principle of an analog computer?
Answer:
The working principle of an analog computer is by measuring rather than counting.

Question 40.
What is the working principle of a digital computer?
Answer:
The working principle of a digital computer is counting.

Question 41.
What are the workstation computers?
Answer:
High-performance, single-user computers typically used for graphics, CAD, software development and scientific applications.

Question 42.
Expand the term PDA.
Answer:
Personal Digital Assistants.

Question 43.
What is a tablet computer?
Answer:
It is a general-purpose computer contained in a single panel in which a touch screen is used as the input device.

Question 44.
What do you mean by a wearable computer?
Answer:
The wearable computing devices are body-worn computers such as wrist-attached devices that compute distance and heart rate etc.,

1st PUC Computer Science Overview of Computers Two Marks Questions and Answers

Question 1.
What are the capabilities of a computer?
Answer:

• Computers can perform complex and repetitive calculations rapidly and accurately.
• Computers can store large amounts of data and information for subsequent manipulations.

Question 2.
Mention the main characteristics of a computer.
Answer:
The main characteristics of a computer are speed, storage capacity, accuracy, and diligence.

Question 3.
What are the essential components of a computer?
Answer:
Input units, CPU and output units are the essential components of a computer.

Question 4.
Write the important units of CPU.
Answer:
The important units of CPU are ALU, Control unit, Registers/Memory unit.

Question 5.
How the Leibniz invented machine is different from Pascals invented Pascaline?
Answer:
The Gottfried Wilhelm Leibniz invented the machine had addition, subtraction, multiplication, and division calculators whereas Pascaline had only an addition calculator.

Question 6.
What is the stored program concept? Who developed it?
Answer:
A stored-program concept is one in which program and data are stored in the main memory and then the processor fetches instructions and executes them, one after another. It was developed by von Neumann.

Question 7.
Write the names of any two First generation computers.
Answer:
ENIAC, EDSAC

Question 8.
Mention any two disadvantages of the first generation computers.
Answer:
Too big in size and very slow in speed.

Question 9.
Write any two important features of the second-generation system.
Answer:

• Use of symbolic or assembly language.
• Introduction of early versions of COBOL and FORTRAN which were high-level languages.

Question 10.
Name any two computers developed in the second generation.
Answer:
IBM 70, Honeywell 400

Question 11.
Mention the two computer languages of the second generation computers.
Answer:
COBOL and FORTRAN

Question 12.
What are the two important features of the third generation system?
Answer:

• The development of the integrated circuits.
• The users interacted with computers through keyboards and monitors and interfaced with an operating system.

Question 13.
Name any two computers developed in the third generation system.
Answer:
IBM 360, PDP 8 Series.

Question 14.
Write any two important features of fourth generation computers.
Answer:

• The microprocessor was introduced in the fourth generation computers,
• They could be linked together to form networks.

Question 15.
Give the name of any two latest processors available in the market.
Answer:
Intel core i9 5 generation and AMD’s FX processors

Question 16.
What is the main difference between microcomputer and minicomputer?
Answer:
The main difference is microcomputers are single-user computers and mini-computers are multi-user computers.

Question 17.
How mainframe computers are different from supercomputers?
Answer:
Mainframe computers are used in business process applications and supercomputers are used in scientific applications and calculations.

Question 18.
Give the application of hybrid computers.
Answer:
Hybrid computers are used in Process control (industries) and Robotics.

Question 19.
How computers are useful in education? Mention any two uses.
Answer:
Using Computer Aided Learning (CAL) & Computer Based Training

• Students can readily learn and get new skills at their own convenient speed.
• Students can get timely and high-quality training on demand.
• Students can solve different kinds of problems quickly and efficiently, by using computers.

Question 20.
Give the application of computers in industries.
Answer:

• Computers are used to control machines and the continuous running of machinery.
• A robot is an automatic programmable machine and can be used in hundreds of applications like assembling and spray painting of cars etc.

Question 21.
What are the advantages of computers in business?
Answer:

• Office paperwork is reduced by using computers.
• Many businesses use websites to sell their products and contact their customers.
• Computerized banking saves time and is convenient for the customer.

Question 22.
Explain the uses of computers in the entertainment and multimedia field.
Answer:

• Nowadays, the computer can be used to watch television programs on the Internet. People can also watch movies, listen to music and play games on the computer.
• Multimedia is used to develop special effects in movies and animations.

Question 23.
What are the uses of computers in the field of science and technology?
Answer:

• A flight simulation can be used to train pilots and how to deal with critical situations.
• Computer-based weather forecasting collects accurate data from many devices all around the world to predict more reliable weather forecasts.

1st PUC Computer Science Overview of Computers Five Marks Questions and Answers

Question 1.
Briefly explain the characteristics of a computer.
Answer:
1. Speed:
Computers are fast in doing calculations. The speed of the computer is measured in terms of No. of million instructions per second (MIPS).

2. Storage Capacity:
Computers come with a very large amount of memory space. They can hold a lot of data. Computers can extract a particular piece of information from a large amount of available data within a very short time.

3. Diligence:
After doing work for some time, humans become tired but computers do not become tired. They work continuously. In fact, Computers which control telephone exchanges, are never shut down. This is called diligence.

4. Accuracy:
The results that the computers produce are accurately provided that the input data and programs are reliable.

Question 2.
Write a short note on the history of computers.
Answer:
1. Abacus:
The abacus was an early tool for mathematical computations. A skilled abacus user can work on addition and subtraction problems at the speed of a calculator. The abacus is still in use today.

2. Napier Bones:
John Napier invented logarithms, where the logarithm values were carved on ivory sticks which are now called Napier’s Bones.

3. Slide Rule:
Napier bones were modified by Edmund Guntur in the year 1620. It consists of a ruler and a sliding piece both marked with logarithmic values. It was further modified by William Oughtred.

4. Pascal’s calculating machine:
The first successful mechanical calculator was constructed by Pascal in 1642.

5. Leibnitz’s Machine:
It is the modified form of Pascal’s machine.

6. Charles Babbage’s Machine:
In 1833, Charles Babbage invented Charles Babbage Machine. He is known as the “Father of Computers”.

7. Census Machine:
This machine was devised by Dr. Hermann Hollerith for tabulating the 1980 US. Census.

8. Jacquard Loom:
A weaving machine invented by Joseph Marie Jacquard in the beginning of the 19^th century.

Question 3.
Draw the schematic block diagram of a computer showing its essential components. Discuss the function of each component.
Answer:

1. Input Unit:
It is a device through which we enter the program and data into the computer. The data is then stored and processed with the help of programs.

2. Central Processing Unit:
The Central Processing Unit (CPU) consists of three units namely, the control unit, the arithmetic, and the logic unit and the memory unit.

3. Control Unit:
This unit is considered to be the nervous system of the computer. It controls all the arithmetic operations to be performed. It also coordinates the functions of all the hardware units of the computer.

4. Arithmetic and Logic Unit (ALU):
This unit performs all the arithmetic calculations and logical operations involved in the program.

5. Memory Unit:
The function of this unit is to store the data and the set of instructions given by the programmer. The computation results are also stored in the memory and they may be used for subsequent computations or sent to the output unit.

6. Output Devices:
Output devices receive information from the CPU and present it to the user in the desired form. Some common output devices are a visual display unit (VDU), Printer, etc.

Question 4.
Write a short note on the first generation of computers.
Answer:

1. The first computers used vacuum tubes for electronic circuitry and magnetic drums for memory.
2. They were very expensive to operate and the power consumption was high, generated a lot of heat, which was often the cause of malfunctions.
3. First-generation computers were communicated through machine language to perform operations, and they could only solve one problem at a time.
4. Input was based on punched cards and paper tape, and output was displayed on printouts.
5. UNIVAC and ENIAC computers are examples of first-generation computing devices.

Advantages:

• For Calculation and computation.
• Payroll Processing
• Record keeping

Disadvantages:

• Required a huge space
• Too big in size
• Very slow in speed
• Low level of accuracy and reliability
• Low storage capacity
• High power consumption
• High heat generation
• Used machine language
• Difficult to maintain
• Fault finding was very difficult

Question 5.

Explain second generation computers in detail.
Answer:

1. In the second generation computers, symbolic or assembly languages were used.
2. High-level programming languages were also in use at this time, such as early versions of COBOL and FORTRAN.
3. The memory storage used was magnetic core technology.
4. Second-generation computers still relied on punched cards for input and printouts for output.

Advantages:

• Smaller in size
• Better speed
• Low power consumption
• No heat was generated.
• Better storage capacity
• More reliability
• Compact Design
• Faster than I Generation Computers.

Disadvantages:

• Needed Air conditioning environment
• Constant maintenance needed.
• No operating system.

Question 6.

Model	Manufacturer
IBM 70,1400,1600	IBM
Honeywell 400,800	Honeywell
UNIVAC III, 5590, 1107	UNIVAC

Write a short note on the third generation computers.
Answer:

1. The development of the integrated circuit was made used in third-generation computers. Transistors were miniaturized and were placed on silicon chips, called semiconductors.
2. The processing speed and efficiency of computers increased.
3. Keyboards and monitors were used as input and output devices.
4. The computer system had an operating system and helped to run multiple applications simultaneously. Computers gained a lot of popularity because of small size and low cost.

Advantages:

• Better than first and second-generation computers
• Used high level language
• Size got reduced further
• Speed got increased
• Much better performance
• Much more reliability

Disadvantages:

• Initial problem with Manufactures.

Question 7.

Models	Manufacturer
IBM 360, 370 Series	IBM
PDP 8 Series	Digital Equipment
Spectra 70 Series	RCA
UNIVAC 1108,9000	UNIVAC

Explain fourth generation computers in detail.
Answer:

1. The microprocessor was used in the fourth generation computers, as thousands of integrated circuits were built onto a single silicon chip.
2. The Intel 4004 chip, developed in 1971, located all the components of the computer – from the central processing unit and memory to input/output controls – on a single chip.
3. In 1981 IBM introduced its first computer for the home user, and in 1984 Apple introduced the Macintosh.
4. Network technology was introduced at this time. Fourth generation computers also saw the development of GUIs, the mouse and handheld devices.

Advantages

• Speed and Reliability are more
• Computer occupies every walks of life.
• More superior to earlier computers.
• Computer-aided Design introduced (CAD)
• LAN (Local Area Network) and WAN (Wide area network) got introduced

Question 8.

Models	Manufacturer
Apple Series	APPLE
M 68000	Motorola
8086, Z 8000	Intel
DEC 10, STAR 1000	Digital Equipment
3033	IBM

Explain the classification of computers based on size, speed, and performance.
Answer:
Micro Computers:
Computers using Microprocessors are called Micro Computers. This is the smallest general-purpose processing system. These computers are designed for use by a single person at a time.

• They brought revolution in the history of computers.
• They are also known as Personal Computers.
• They are cheap and user-friendly.
• The main components are Monitor, CPU, Keyboard, Mouse, Speakers, Modem and Printer.
• They are used as desktops either in offices or even homes.
• Their operation can be easily learned by anyone having some basic logical aptitude.
• Children enjoy playing games & watching movies on these computers.
• The most popular micro computer’s processing chip manufacturing company is Intel.

Mini Computers:
These are medium-sized computers that are costlier but powerful than a microcomputer. A mini-computer is usually designed to serve more than one user simultaneously. These computers need less power and less cooling arrangement. Up to 8 users can use the system simultaneously, all of them running their own programs.

• They have less memory & storage capacity than mainframe computers.
• Only a limited range of softwares can be used by them.
• The end users can directly operate on them.
• They are used for data processing

Super Computers:
The supercomputer is the largest, fastest and most expensive mainframe computer. Their computing speed is 10 times faster than any other type of computer. These computers are capable of executing more than 10,000 million instructions per second and have storage capacities of millions of bits per chip.

• They are huge computers installed in space centres, nuclear power stations, etc.
• They are used for performing complex mathematical calculations.
• Only scientists and mathematicians can operate them.
• They are having huge memories & tremendous processing speed.
• They are used in the fields of electronics, petroleum engineering, weather forecasting, structural analysis, chemistry, medicine, and physics.

Question 9.
Explain the use of computers in the field of business.
Answer.
All business firms do certain business tasks on a daily basis like generating customer bills, studying sales of various products at different locations, etc., using computers. There are many departments like sales, purchase, finance, etc., is big business firms. These departments are involved in different business tasks which are large in volume and huge storage space is required and computers are used in such places.
1. Marketing:
Marketing applications provide information about the products, their distribution, advertising and selling activities.

2. Stock Exchanges:
The stock market uses a computerized system that makes it possible for stockbrokers and customers to do all their trading electronically. Brokers connect to stock exchanges using the internet and do the buying and selling of shares online. Money transfer is done electronically.

3. Banks:
Computerized banking saves time for the customer. Cheques are read by MICR (Magnetic Ink Character Reader, a device used to allow the data on cheques to be read by machines). Banks use computers to maintain their customer’s accounts and their transaction details. Customers can also use internet banking to transfer money. Money can be withdrawn from any ATM’s any time.

4. Departmental Stores:
At departmental stores, cashiers enter sales data by waving a bar code scanner. Bar codes are read by bar code readers that translate the bar code symbols into digital forms. The price of a particular item is set with the store’s computer and appears on the computer and billing is done automatically. The report of purchases, sales and stock are generated using computers. Security cameras are used and continuous recording using DVR is widely used in departmental stores and other locations to monitor home or business operations to ensures security and safety.

5. E-Commerce:
E-commerce (electronic commerce) is the buying, selling, and exchanging of products, services, and information via computer network/internet. It promotes online buying and selling of goods and services. A buyer can buy products using a computer connected to the internet sitting anywhere in the world at any time of the day.

Question 10.
Write a short note on the different types of latest personal computers.
Answer:
The personal computer (PC) means “a computer designed for general use by a single person”. PCs were first known as microcomputers.
1. Workstation:
A workstation is simply a desktop computer that has a more powerful processor, additional memory and enhanced capabilities for performing a special group of tasks, such as 3D Graphics or game development.

2. Desktop computer:
A PC that set up in a permanent location and is not movable is called desktop computer. Most desktops offer more processing power, speed, and storage for less cost but the size is relatively big.

3. Laptop:
Also called notebooks, laptops are portable computers that integrate the display, keyboard, a pointing device or trackball, processor, memory and hard drive all in a battery-operated package slightly larger than an average hardcover book.

4. Netbook:
Netbooks are ultra-portable computers that are even smaller than laptops. They are cheaper than a laptop but internal components are less powerful than those in regular laptops.

5. PDA:
Personal Digital Assistants (PDAs) are tightly integrated computers that often use flash memory instead of a hard drive for storage. These computers usually do not have keyboards but rely on touch screen technology for user input. PDAs are typically smaller, very lightweight with a reasonable battery life. A slightly larger and heavier version of the PDA is the handheld computer.

6. Server:
A server computer is designed to provide services to other computers over Servers usually have powerful processors, lots of memory space and large hard drives are costlier compared to any other type of personal computers.

7. Wearable Computer:
The latest trend in computing is wearable computers. Most common computer applications (e-mail, database, multimedia, calendar/scheduler) are integrated into watches, cell phones, and even clothing.

Question 11.
Explain generations of computer in detail.
Answer:
First-generation computers

The first computers used vacuum tubes for electronic circuitry and magnetic drums for memory. They were very expensive to operate their electricity consumption was high and they generated a lot of heat, which was often the cause of malfunctions.
First-generation computers were communicated through machine language to perform operations, and they could only solve one problem at a time.
Input was based on punched cards and paper tape, and output was displayed on printouts. UNIVAC and ENIAC computers are examples of first-generation computing devices.
Advantages:

• For Calculation and computation.
• Payroll Processing
• Record keeping

Disadvantages:

• Required a huge space
• Too big in size
• Very slow in speed
• Low level of accuracy and reliability
• Low storage capacity
• High power consumption
• High heat generation
• Used machine language
• Difficult to maintain
• Fault finding was very difficult

Second Generation Computers

1. In second-generation computers symbolic or assembly languages were used.
2. High-level programming languages were also in use at this time, such as the early versions of COBOL and FORTRAN.
3. The memory storage used magnetic core technology.
4. Second-generation computers still relied on punched cards for input and printouts for output.

Advantages:

• Smaller in size
• Better speed
• Low power consumption
• No heat was generated.
• Better storage capacity
• More reliability
• Compact Design
• Faster than I Generation Computers.

Disadvantages:

• Needed Air conditioning environment
• Constant maintenance needed.
• No operating system.

 

Model	Manufacturer
IBM 70, 1400, 1600	IBM
Honeywell 400,800	Honeywell
UNIVAC 111,5590, 1107	UNIVAC

Third Generation Computers

1. The development of the integrated circuit was made use of in the third generation of computers.
2. Transistors were miniaturized and were placed on silicon chips, called semiconductors.
3. The processing speed and efficiency of computers increased.
4. Keyboards and monitors were used as input and output devices.
5. The computer system had an operating system and helped to run multiple applications simultaneously. Computers gained a lot of popularity because of small size and low cost.

Advantages:

• Better than first and second-generation computers
• Used high-level language
• Size got reduced further
• Speed got increased
• Much better performance
• Much more reliability

Disadvantages:

• Initial problem with Manufactures.

 

Model	Manufacturer
IBM 360,370 Series	IBM
PDP 8 Series	Digital Equipment
Spectra 70	Series RCA
UNIVAC 1108,9000	UNIVAC

Fourth Generation Computers

1. The microprocessor was used in fourth the generation computers, as thousands of integrated circuits were built onto a single silicon chip.
2. The Intel 4004 chip, developed in 1971, located all the components of the computer from the central processing unit and memory to input/output controls on a single chip.
3. In 1981 IBM introduced its first computer for the home user, and in 1984 Apple introduced the Macintosh.
4. Network technology was introduced at this time. Fourth generation computers also saw the development of GUIs, the mouse and handheld devices.

Advantages:

• Speed and Reliability are more
• Computer occupies every walks of life.
• More superior to earlier computers.
• Computer-aided Design introduced (CAD)
• LAN (Local Area Network) and WAN (Wide area network) got introduced

 

Model	Manufacturer
Apple Series	APPLE
M 68000	Motorola
8086, Z 8000	Intel
DEC 10, STAR 1000	Digital Equipment
3033	IBM

Question 12.
Write a note on the classification of computers in detail.
Answer:
Based on operating principles, computers can be classified into 3 types. They are,

1. Digital Computers
2. Analog computers
3. Hybrid computers

1. Digital computers:
They operate essentially by counting. All quantities are expressed as discrete digits or numbers. Digital computers are useful for evaluating arithmetic expressions and the manipulation of data. The majority of the computers used in the world today are digital.
2. Analog Computers:
They operate by measuring rather than counting. The computer functions by establishing similarities between two quantities that are usually expressed as voltages or currents. Analog computers are powerful tools to solve differential equations.
3. Hybrid Computers:
Computers which combine features of both analog and digital type are called hybrid computers.

Computers are also classified in terms of speed, accuracy, word length and storage capacity. Computers are also available in different sizes and with different capabilities. Broadly, they may be categorised as microcomputers, mini, mainframe, and supercomputers.
1. Micro Computers:
Computers using Microprocessors are called Microcomputers. This is the smallest general-purpose processing system usually designed for use by a single person at a time.

2. Mini Computers:
These are medium-sized computers that are costlier and powerful than a microcomputer. An important distinction between a micro and a minicomputer is that a mini-computer is usually designed to serve multiple users simultaneously. This type of computers need less power and less cooling arrangements. Up to 8 users can use the system simultaneously, running their own individual programs.

3. Super Computers:
The supercomputer is the largest, fastest and most expensive mainframe computer. It is normally used by large business organisations that require an extraordinary amount of computing power. Their computing speed is 10 times faster than any other type of computer. These computers are capable of executing more than 10,000 million instructions per second and have storage capacities of millions of bits per chip.
Normally, the supercomputer is used for solving or handling large scale numerical problems in scientific and engineering fields. These include applications in electronics, petroleum engineering, weather forecasting, structural analysis, chemistry, medicine, and physics.

Question 13.
Explain the importance and usage of computers in different fields.
Ans.
Businesses. Computers help businesses to predict future sales, profits, costs, etc. making companies more accurate in their accounts. Businessmen make bar graphs and pie charts from numerical figures. Firms can store large amounts of data in less space. Many business application software like tally, ms-word, excel are useful in processing business transactions easily.
1. Buildings:
Architects use computer-animated graphics to give their clients a visual walk¬through of their proposed buildings. Computers provide architects many facilities to create different buildings with greater accuracy, better designing, and editing tools, and get the work ‘ done at the fastest speed possible.

2. Education:
Computers are used in classrooms to teach different subjects. It has been proved that learning with computers has been more successful and many forms of new teaching methods have been introduced. This enriches the knowledge of the student at a much faster speed. Likewise, Colleges and various Universities use computers as many educators prefer ‘learning by doing’ method – an approach uniquely suited to the computer.

3. Departmental stores:
Products from salt to grains are packed with zebra-striped bar codes that can be read by the computer scanners at supermarket checkout stands to determine prices. Thus, a detailed bill can be generated, which is useful for both the customer and the retail store.

4. Energy:
Energy companies use computers to locate oil, coal, natural gas and uranium. Electric companies use computers to monitor vast power networks. In addition, meter readers use handheld computers to record how much energy is used each month in homes and offices and generate bills.

5. Transportation:
Computers are used in cars to monitor fluid levels, temperatures, and electrical systems. Computers are also used in the air control traffic systems, where computers are used to control the flow of traffic between airplanes.

6. Banks:
Computers speed up record-keeping and allow banks to offer same-day services and even do-it-yourself banking over the phone and internet.

7. Agriculture:
Farmers use small computers to help with billing, crop information, and cost per acre, feed combinations, and market price checks apart from specific weather forecasts.

8. Entertainment:
Computers can be used to watch television programs on the Internet. People can also watch movies, listen to music and play games on the computer. Many computer games and other entertainment materials of different kinds are available on the Internet.

9. Home:
At home, the computer is used to maintain personal records and to access a lot of information on the Internet. People can also use the computer at home for making home budgets etc.

10. Medical:
Computers are used for maintaining patient history & other records. They are also used for patient monitoring and diagnosis of diseases etc.

Question 14.
Explain the role of computers in the education field.
Answer:
Students use computers for simple word processing that is, to type reports and other documents and to print out the results. This application allows students to revise and edit easily. A computer makes it much easier to redraft a sentence and produce a new printout when compared with producing a handwritten copy.

Encyclopedias and other reference works are available on CD-ROMs, which can be searched by students using the computers at their classroom or school library. Computer-aided instruction (CA1).Interactive programs provide practice in such basic skills as spelling, math computation, and word recognition.

Internet and World Wide Web are a source of information resources that students may access, using their computers at school or at home. Computers are used in running School and College administrations, during the admission procedures, storing of official and student records. They are also used in syllabus planning and decision-making, controlling.

Computers are helpful in directing aptitude tests and achievement tests, at the time of entrance exams. They also process records of salaries, examinations, schemes of examination, printing of papers and question papers, evaluation of answer sheets, mark sheets, and certificates.

You can Download Chapter 16 Spreadsheets Questions and Answers, Notes, 1st PUC Computer Science Question Bank with Answers Karnataka State Board Solutions help you to revise complete Syllabus and score more marks in your examinations.

Karnataka 1st PUC Computer Science Question Bank Chapter 16 Spreadsheets

1st PUC Computer Science Spreadsheets One Mark Questions and Answers

Question 1.
Define an electronic spreadsheet.
Answer:
An Electronic spreadsheet is an application software and the spreadsheet is divided into rows and columns to store items like student is marks, stocks, income and expenses, debits and credits.

Question 2.
Define a workbook.
Answer:
A workbook is a set of electronic spreadsheets.

Question 3.
Define a cell.
Answer:
The intersection of a row and a column in a spreadsheet is called a cell.

Question 4.
What is the cell address?
Answer:
A cell address is a unique ID given to a cell represented by column name and row name.

Question 5.
What is an active cell?
Answer:
The cell that is currently open and ready for editing is called the active cell.

Question 6.
What is cell pointer?
Answer:
Cell pointer is a rectangular box that appears in the worksheet and is used to make an entry in a particular cell.

Question 7.
What is the default extension name for an excel file?
Answer:
The default extension name of an excel file is *.xls or *.xlsx

Question 8.
What is the size of a worksheet?
Answer:
There are 256 columns and 65536 rows in a worksheet.

Question 9.
What is the number of columns and rows present in the excel 2007 worksheet?
Answer:
There are 16384 columns and 1048576 rows, in a worksheet in the latest excel software.

Question 10.
What is the use of a formula in a worksheet?
Answer:
A formula is an expression or cell entry that performs some sort of a calculation. An equal sign = is always the first part of a formula followed by an expression that calculates a value.

Question 11.
What is a label cell?
Answer:
A label cell is a cell that contains alphabets, numbers, and symbols.

Question 12.
What is a value cell?
Answer:
A cell that contains numbers with or without a + or – symbol is called a value cell.

Question 13.
Define a formula cell.
Answer:
A cell that starts with the = symbol and a value or cell address with a mathematical expression is called a formula cell.

Question 14.
What is the use of the autofill option?
Answer:
The autofill option can be used to insert a series of values in a range of cells easily.

Question 15.
What is the use of autoformat option?
Answer:
The autoformat option allows to select predefined formatting options.

Question 16.
How is a formula entered in a spreadsheet?
Answer:
A formula is entered by beginning it with the = symbol. For example, =a1+ a2

Question 17.
What is the use of sum() function?
Answer:
The sum function is used to compute addition of a range of cell values.

Question 18.
What is a filter in the worksheet?
Answer:
A filter is an option that allows to display only the data of user is choice by hiding other data. Define a chart.

Question 19.
Define a chart.
Answer:
A chart is a pictorial representation of some data.

Question 20.
Name any two types of charts.
Answer:
Bar graph and pie chart are two types of charts.

Question 21.
Give the short cut keys to select the entire worksheet.
Answer:
The short cut keys to select entire worksheet is Ctrl+Z.

Question 22.
What is a macro?
Answer:
A macro is a series of instructions which can be issued using a single command.

Question 23.
How is data sorted?
Answer:
Data can be sorted both in rows o columns, either in an ascending or in a descending order.

1st PUC Computer Science Spreadsheets Two/ Three Marks Questions and Answers

Question 1.
What are the purposes of spreadsheets?
Answer:
Spreadsheets make it easy to display information, and formulas can be inserted to work with the data. Information can also be sorted and filtered. Data can be used be create charts.

Question 2.
Write the different spreadsheet software.
Answer:
The different spreadsheet software are

1. IBM Lotus 1-2-3 for Windows and
2.  Apple Works and Numbers for Mac OS X.

Question 3.
What are the different applications of the spreadsheet?
Answer:

1. They are used in accounting to prepare balance sheet, auditing, etc.,
2. They are organizations where data can be represented using charts and graphs.
3. They are used for statistical calculations

Question 4.
Write any two file menu options.
Answer:
The new option is used to create a new workbook and open option is used to open the saved worksheet.

Question 5.
What is the difference between ‘save’ and ‘save as’ options?
Answer:
The ‘save’ option saves the file under the current file name given by the user, and ‘save as’ option allows for change in the filename and location saves the file.

Question 6.
What are the uses of page setup option in a spreadsheet?
Answer:
The page setup can be used to set the margins, page size and orientation of the page of the worksheet.

Question 7.
What is print preview and how is this useful to the user?
Answer:
The print preview shows the content of a spreadsheet in a printable view. It helps save lots of paper as the user can see the actual print as a preview avoiding mistakes and reprints before it is actually printed.

Question 8.
What is the use of a print option?
Answer:
The print option can be used to set the number of copies to be printed, selection of printer pages and any selected passage.

Question 9.
Write any three options present in the edit menu.
Answer:
Cut, copy-paste, find, and replace are a few options present in the edit menu.

Question 10.
Write any three options present in the view menu.
Answer:
The normal view, page break preview, full-screen view and enable/disable formula bar and status bar, etc., are the options present in the view menu.

Question 11.
Write any three options of the Insert menu.
Answer:
The insert menu contains inserting cells, charts, rows, columns, clipart, diagram, etc., as options.

Question 12.
Write the options under the format menu.
Answer:
The formatting of cells, modification of row height and column width, autoformat, style, etc., are the options present under the format menu.

Question 13.
Name the different options present in the tools menu.
Answer:
Spellings, error checking, goal seek, and macro autocorrect options are a few options of tools menu.

Question 14.
What are the different options present in data menu?
Answer:
The different options of data menu are sort, filter, validation, subtotal, and pivot table options.

Question 15.
Write any three mathematical functions.
Answer:
The sum() and product() and power() functions are three mathematical functions.

Question 16.
Write any three statistical functions.
Answer:
The average(), max() and min() functions are three statistical functions.

Question 17.
Write any three date and time functions.
Answer:
The now(), today(), and year() functions are a few date and time functions.

Question 18.
Write any three financial functions.
Answer:
The PMT(), FV() and NPER() are three financial functions.

Question 19.
Write any three logical functions.
Answer:
The AND(), IF(), OR() are three logical functions.

Question 20.
Write any three text functions.
Answer:
The Concatenate(), len() and trim() are three text functions.

Question 21.
What is a data form?
Answer:
A data form is a convenient way to enter or display one complete row of information in a table, without scrolling horizontally and makes data entry easier.

Question 22.
Mention the steps to add rows and columns in a worksheet.
Answer:
1. The steps to add rows:
Click on the row at the left extreme cell and on the insert menu insert a row.

2. The steps to add columns:
Click on the column insert columns.

Question 23.
Explain the steps used to change the row size and columns width in a worksheet.
Answer:
Select cell, a format, a row height a height in numbers. Select cell, a format, a column width a width in numbers.

Question 24.
Explain the steps of using the auto-format options.
Answer:
The steps of using the auto-format options are follows Govt format, a autoformat, a Select the range of cells, a select the format from the list.

Question 25.
Name the different categories of charts.
Answer:
The different categories of charts are column, line, pie, bar, xy scattered, etc.,

Question 26.
Give the steps to insert a chart in a worksheet.
Answer:
The steps to insert chart is a select range of cells, insert a chart, a chart type.

1st PUC Computer Science Spreadsheets Five Marks Questions and Answers

Question 1.
Write a short note on the spreadsheet.
Answer:
A spreadsheet is a document which is divided into rows and columns to record such things as items in inventory, income, and expenses, debits and credits, etc.

In a spreadsheet, the COLUMN is defined as the vertical space. Letters are used to name each COLUMN’S location and the ROW is the horizontal space. Numbers are used to assign each ROW’S location.

In a spreadsheet, the CELL is the space where a specified row and column intersect. Each CELL is assigned a name according to its COLUMN letter and ROW number.
Example: C3 is cell in column C row 3.

Question 2.
Explain different parts of an excel worksheet.
Answer:

1. Title Bar – This displays the name of the program and the spreadsheet file name.
2. A cell is created at the intersection of a row and a column.
3. Active cell – The cell that is currently open and ready for editing is called the active cell.
4. The cell reference identifies the exact location of the current active cell. In the Figure above, the active cell is A1.
5. The formula bar displays the contents of the active cell including any formulas. As user enters or edits data, the changes will appear in the formula bar.
6. Columns (vertical) are labelled along their column heading A thru Z, AA through AZ, up to column IV.
7. Rows (horizontal) are labeled by their row headings from 1 through to 65,536.
8. The name box displays the active cell reference.
9. The pointer indicates the current location of your mouse pointer.
10. Each worksheet in the workbook is comprised of sheet tabs which displays the sheet’s name.

Question 3.
Explain the uses of spreadsheets.
Answer:
The different uses of spreadsheets are as follows;

1. Performing basic mathematical operations such as adding columns and rows of figures.
2. Finding values such as profit or loss.
3. Calculating repayment plans for loans or mortgages.
4. Finding the average, maximum, or minimum values in a specified range of data.
5. Graphing or charting data, to assist users in identifying data trends.
6. Sorting and filtering data to find specific information.
7. Creation of simple lists and tables of alphabetic or numerical data.
8. Creation and manipulation of simple (flat-file) databases.
9. Establish relationships between sets of numerical data.
10. Applies arithmetical, mathematical or statistical functions to numerical datasets.
11. Represents datasets in graphical or chart form.

Question 4.
Explain in detail, the different types of cell entries and range of values that can be used in a worksheet.
Answer:
Data is information that is stored in a spreadsheet program. Data is stored in the individual cells of a worksheet. Only one piece of data is stored in each cell. In addition to being stored in the spreadsheet, the data can be used in calculations, displayed in graphs, or sorted and filtered to find specific information. There are three types of data in Excel: values, labels, Formula and dates/times.
1. Value cell entry:
A cell that contains numbers with or without a + or – symbols is called a value cell. These cells can be used in mathematical calculations. For example marks, age, salary, etc.,

2. Label Cell entry:
A cell that contains a to z alphabets, numbers and symbols is called label cell. For example, place name, employee code, etc.,

3. Formula cell entry:
A cell where the cell entry begins with a = and a formula appended to calculate something is called a formula cell entry. For example (= a10 + 25).

4. Cell Range:
A range is a series of two or more cells. If they are adjoining, they are called as adjacent range on contiguous. If the are noncontiguous, they are called a non-adjacent range.

A range is identified by the cell references of the cells in the upper left and lower right comers of the range. These two references are separated by a colon (:) which tells Excel to include all the cells between these start and endpoints. An example of a range of adjacent cells would be B5: D10.

To select an adjacent range, click on a cell in a corner of your selection and drag the mouse over the remaining cells. For example, A1 through D6, D8 through E9, and B14 through D15 are written as A 1:D6 or D8: E9 or B14: D15.

• To select a non-adjacent range, first select an adjacent range of cells. Now, press and hold down the Ctrl key while you select another adjacent range of cells. Release the mouse button and the Ctrl key.
• The adjacent ranges can be combined into a variety of different non-adjacent ranges. For example, one non-adjacent range is A1 through D6 and D8 through E9 is written as A1: D6; D8: E9.

Question 5.
Write a short note on the formatting toolbar.
Answer:
It is a toolbar that has the icons that provide the various formatting settings for cells, columns, rows, and data in Excel. For example, it can allow you to change the colours of rows, cells, and columns. It allows you to change fonts. It allows you to set the alignment for data in cells. It allows you apply borders to cells. It allows you to change the format of numbers, like adjusting the amount of decimals they have or changing them to percentage format. All of these and other things can be done with it.
1. Format Cells Dialog Box:
For a complete list of formatting options, right-click on the highlighted cells and choose Format Cells from the shortcut menu or select Format > Cells from the menu bar.

2. Number tab:
The data type can be selected from the options on this tab. General is to be selected if the cell contains text and numbers, or a different numerical category if the cell is a number that will be included in functions or formulas. The number tab can be used to limit the number of decimal places.

3. Alignment tab:
These options allows the user, to change the position and alignment of the data within the cell. For example, right, left, center, vertical alignments, text-wrap, etc.,

4. Font tab:
All of the font attributes are displayed in this tab including font face, size, style, and effects. For example, bold, italicize, underline, increase/decrease the font size, changing the color of font, fill, etc., can be done.

5. Border and Pattern tabs:
These tabs allow the user to add borders, shading, and background colors to a cell.

Question 6.
Explain the steps involved in drawing a chart in excel.
Answer:
A chart is a pictorial representation of data. The data is first entered in a worksheet in a table format. The table shall contain a heading followed by the numerical values. The steps in creating a chart are as follows;
Step 1:
Data is entered in the cells of an Excel spreadsheet.

Step 2:
Mouse is used to highlight the block of cells containing data, and then insert chart is clicked on.

Step 3:
When the chart wizard comes up, column or bar graph and a subtype as clustered or stacked type is chosen as per requirement.

Step 4:
If the user wants to switch what appears on the X and Y axis, right-clicking on the bar graph, then on ‘ Select Data,’ and finally on  ‘Switch Row/Column’.

Step 5:
Labels and legends of the chart an bead justed if needed. User can on the bar graph, and then click the ‘Layout’ tab. Here you can choose what layout you prefer for the chart title, axis titles, and legend.