Computer Science volume 1 for TN State board Class XII power point

Add to Favourites
Post to:

Description
Computer Science volume 1 for TN State board Class XII power point


Type: ppt

Discussion

Lalitha

please computer science tamil medium ppt in 1&II vollume

2083 days 6 hours 9 minutes ago

Sangeetha Bharathi

Nice venkat

2497 days 2 hours 58 minutes ago

Presentation Transcript Presentation Transcript

CHAPTER-1 : CHAPTER-1 INTRODUCTION TO STAR OFFICE

PowerPoint Presentation : Name one powerful standalone application for editing Microsoft Office documents. Star office is a powerful standalone application for editing MicrosoftOffice documents. Name one application that works on different operating systems. Star Office is an application that works on different operating system.

PowerPoint Presentation : Name one word processor. StarOffice is a word processor. Which indicates the position of a new text ? Insertion point indicates where the new text will appear.

PowerPoint Presentation : What is the term that refers to the activity carried out using a computer and suitable software to create, view, edit, manipulate, transmit, store, retrieve and print documents? Word processing refers to the activity carried out using a computer and suitable software to create, view, edit, manipulate, transmit, store, retrieve and print documents.

PowerPoint Presentation : Name the flashing vertical bar which moves to the right as the characters are typed on the screen ? Insertion point is the flashing vertical bar which moves to the right as the characters are typed on the screen. What does the StarOfficeWriter prompt for the first time a document is saved.? StarOfficeWriter prompts for the Name /file name the first time a document is saved.

PowerPoint Presentation : What is the thick horizontal line in the page area called? End of document marker is the thick horizontal line in the page area. What are the keys that can be used to correct any identified mistake? Backspace and Delete are the keys that are used to correct any identified mistake

PowerPoint Presentation : 10. Name the procedure for entering a new text or modifying the existing text in a document. Text editing is the procedure for entering a new text or modifying the existing text in a document. 11.How are the functions Cut, Copy, Find, Replace called ? These functions are commonly called as editing functions.

PowerPoint Presentation : 12.Which key combination can be used to move to the end of the document? CTRL + END is key combination that is used to move to the end of the document. 13. Which key is used to move one character to the left? LEFT ARROW is the key that is used to move one character to the left.

PowerPoint Presentation : 14. Which key is used to move one character to the right? RIGHT ARROW is the key that is used to move one character to the right. 15. Which key combination can be used to move one word to the left? CTRL+LEFT ARROW is the key that is used to move one word to the left.

PowerPoint Presentation : 16. Which key combination is used to move one word to the right? CTRL+RIGHTARROW is the key that is used to move one word to the right. 17.Which key combination is used to move one cell to the left? SHIFT+TAB is the key that is used to move one cell to the left.

PowerPoint Presentation : 18. Which key is used to move up by one line? UP ARROW is the key that is used to move up one line. 19.Which key is used to move down by one line? DOWNARROW is the key that is used to move down one line. .

PowerPoint Presentation : 20. Which key is used to move to end of a line? END is the key that is used to move to end of a line. 21. Which key is used to move up one screen? PAGE UP is the key that is used to move up one screen.

PowerPoint Presentation : 22. Which key is used to move down one screen? PAGE DOWN is the key that is used to move down one screen. 23. Which key combination is used to move to the end of the document? CTRL+END is the key combination that is used to move to the end of the document.

PowerPoint Presentation : 24. Will scrolling a document move the insertion point ? Scrolling a document does not move the insertion point. 25. Give the use of Delete key. Delete key deletes the character to the right of the insertion point.

PowerPoint Presentation : 26.What is meant by Type-over? Type-over is the name for the mode in which the text existing to the right of insertion point disappears while typing new text.

PowerPoint Presentation : 27. What are the modes that are toggled using insert key? The user can toggle between Type-over & insert mode by using insert key. 28.Which feature in StarOffice writer helps in searching and replacing text? Find & Replace is the feature that helps to search for and to replace words in a text document.

PowerPoint Presentation : 29.Does the delete key delete the characters to the left of the insertion point? No the delete key does not delete the characters to the left of the insertion point. 30. Is the user said to be in the type-over mode, if the text existing to the right of insertion point disappears, while typing a new text ? Yes the user is said to be in the type-over mode, if the text existing to the right of insertion point disappears, while typing a new text.

PowerPoint Presentation : 31. Can Ctrl + A be used to select the entire document? Yes Ctrl + A is used to select the entire document. 32. Is it necessary that the Enter key must be pressed at the end of each line? No the Enter key need not be pressed at the end of each line.

PowerPoint Presentation : Will the StarOfficeWriter automatically create a new page once the current page is filled? Yes the StarOfficeWriter automatically creates a new page once the current page is filled. 34. Will naming the file enable the user to open a saved file again? Yes naming the file enables the user to find and open a saved file again.

PowerPoint Presentation : 35. Will the insert key paste the selected word in the desired place? No the insert key is not used to paste the selected word in the desired place. 36. Will the Star Office Writer automatically wrap the text to the next line? Yes the Star Office Writer automatically wrap the text to the next line.

PowerPoint Presentation : 37. Lotus AmiPro and WordPro are Word processing packages. State Yes/No. Yes Lotus AmiPro and WordPro are some of the Word processing packages. 38. Will pressing the HOME key move to the beginning of a document? No pressing the HOME key does not move to the beginning of a document.

PowerPoint Presentation : 39. Scrolling a document does not move the insertion point. State Yes/No. Yes scrolling a document does not move the insertion point. 40. We can open several documents at the same time in StarOffice Writer. State Yes/No. Yes while working with StarOffice Writer, it is possible to have several documents open at the same time.

PowerPoint Presentation : 41. Find and replace dialogue box contains Search for and replace with facility. State Yes/No. Yes Search for and replace with are the two combo boxes available in the find and replace dialogue box.

PowerPoint Presentation : 42. Name the component in StarOffice that is used to create text document. StarOffice Writer is used to create a text document.

PowerPoint Presentation : 42. Name the component in StarOffice that is used to creates a database. StarOffice Base is used to create a database.

PowerPoint Presentation : 44. Name the component of StarOffice that is used to create spreadsheets. StarOffice Calc is used to create spreadsheets.

PowerPoint Presentation : 45. Name the component in StarOffice that is used to create presentation. StarOffice Impress is used to create presentations.

PowerPoint Presentation : 46. Name one component in StarOffice that helps in drawing. StarOffice Draw is used to draw.

PowerPoint Presentation : 47. Which key is used to move one cell to the right in a table? TAB is used to move one cell to the right in a table

PowerPoint Presentation : 48. Which key is used to move to the beginning of a document? CTRL + HOME key is used to move to the beginning of a document

PowerPoint Presentation : 49 . What happens when you double click on a word? Double clicking on a word is used to select a word

PowerPoint Presentation : 50. Name one software which is not a word processing package. StarOffice Impress is not a word processing package.

PowerPoint Presentation : 51. Give the functionality of CTRL + V. CTRL + V is used to paste a text

PowerPoint Presentation : 52 . Give the functionality of CTRL + S. CTRL + S is used to save a document

PowerPoint Presentation : 53. Give the functionality of CTRL + X. CTRL + X is used to cut a text

PowerPoint Presentation : 54. Give the functionality of CTRL +C. CTRL +C is used to copy a text

CHAPTER 2 : CHAPTER 2 TEXT FORMATTING

PowerPoint Presentation : What are the two types of line spacing options ? Leading, Fixed are the two types of line spacing options available. 2. Give the purpose of indenting a text. Indenting of text helps to increase readability.

PowerPoint Presentation : 3. Which feature is used to mark the important portions of the document? Highlighting is used to mark the important portions of the document. 4. Which key combination is used for justifying the selected paragraph? CTRL+J is used for justifying the selected paragraph.

PowerPoint Presentation : 5. Define Style. Style is a named set of defaults for formatting text. 6. What are the common types of text formatting? Bold, Italic or Underlined are the most common types of text formatting.

PowerPoint Presentation : 7. Which command is used to open the Character dialog box? Format->Character is used to open the Character dialog box. 8. What is inserted every time when Enter key is pressed? A hard return is inserted every time when Enter is pressed.

PowerPoint Presentation : 9.Which is inserted as line break and adjusted when text is added or deleted in StarOffice Writer ? Soft returns are inserted as line breaks by StarOffice Writer and are adjusted when text is added or deleted. 10. What is the resultant value of hanging indent? The resulting value of a hanging indent is negative.

PowerPoint Presentation : 11. Which key combination is used to bold the text? CTRL+B key combination is used to bold the text. 12. Which key combination is used to make the text as Italic? CTRL+I key combination is used to make the text as Italic.

PowerPoint Presentation : 13. Which key combination is used to underline the text? CTRL+U key combination is used to underline the text. 14. What is windings font? Wingdings font is actually a set of symbols.

PowerPoint Presentation : 15. How is text aligned in StarOffice ? When typing in StarOffice , all text is aligned left and the right margins are uneven. 16. What are the two types of formatting? Hard formatting and Soft formatting are the two types of formatting.

PowerPoint Presentation : 17. Can the size of font be measured in points? Yes the size of a font is measured in points. 18. How many points are there for an inch? There are 72 points to an inch.

PowerPoint Presentation : 19. Why do you need a colour printer? The colour printer is required to get the hard copy of the document in colour. 20. Line space must be assigned only with an integer value. State Yes/No. No, it is not a must to have an integer value for a line space.

PowerPoint Presentation : 21. Does StarOffice have an on-line help facility? Yes StarOffice has an on-line help facility. 22. To remove bullets from a list the list is selected and the delete button is clicked. State Yes/No. No. To remove bullets from a list the list is selected and the delete button is not clicked.

PowerPoint Presentation : 23. Define Font. Font is set of characters and numbers in certain style. 24. How do you select different colours in StarOffice ? A colour palette is displayed from which the required colour can be selected.

PowerPoint Presentation : 25. A line is any text followed by a hard return. Is the statement true? No the statement is not true. 26. The default alignment of text in StarOffice Writer is single-spacing. State Yes/No. Yes By default, StarOffice Writer single-spaces the text in the document.

PowerPoint Presentation : 27. Increase Indent icon is used to undo the indent. State Yes/No. No , the Increase Indent icon is not used to undo the indent. 28. Bullets and Numbers are used to list the important points and messages. State Yes/No. Yes Bullets and Numbers are used to list the important points and messages.

PowerPoint Presentation : 29. Is the size of the letters used in the main document and the footer are same? No the size of the letters used in the main document and the footer are not the same. 30. A style is a named set of defaults for formatting text. State Yes/No. Yes a style is a named set of defaults for formatting text.

PowerPoint Presentation : 31. Which menu consists of all the formatting options? All formatting options are available in Format menu.

PowerPoint Presentation : 32. Which font is used for business purposes? Times New Roman is used for business purposes. 33. Which indent is used for numbered lists? Hanging indent is used for numbered lists.

PowerPoint Presentation : 34. Which option is used to indent the line of a paragraph? First line option is used to indent the line of a paragraph. 35. Which is used to increase the indent? Increase Indent is used to increase the indent.

PowerPoint Presentation : 36. Which key combination is used to right- align the text? CTRL+R is used to right-align the text. 37. Which key combination used to left-align the text? CTRL+L is used to left-align the text.

PowerPoint Presentation : 38. Which key combination used to center the text? CTRL+E is used to center the text. 39. Which button is used to create a bulleted list? Bullets button is used to create a bulleted list.

PowerPoint Presentation : 40. Which icon is used to highlight the selected text? Highlighting icon is used to highlight the selected text. 41. Which key is pressed to get StarOffice help? F1 is pressed to get StarOffice help.

CHAPTER – 3 : CHAPTER – 3 CORRECTING SPELLING MISTAKES

PowerPoint Presentation : What does StarOffice Writer include to avoid spelling mistakes? StarOffice Writer includes Dictionary and spell-check to avoid spelling mistakes. Which key is pressed to select the spelling command? The F7 key is pressed to select the spelling command.

PowerPoint Presentation : 3.Which button is used to skip the spelling change for the current word? The Ignore once button is used to skip the spelling change for the current word. 4.Which option can be used to automatically replace the misspelled word with the correct spelling? Auto-correct option can be used to automatically replace the misspelled word with the correct spelling.

PowerPoint Presentation : 5. Which icon is needed to specify the auto spell check feature ? Ans : The Auto-spell check feature can be included by clicking abc underline icon. 6. Which button is used to skip all occurrence of the word? Ans : Ignore all button is clicked to skip all occurrence of the word.

PowerPoint Presentation : 7. Which text area displays the misspelled word in spell check dialog box? “Not in dictionary” text area displays the misspelled word in spell check dialog box. 8. Which text box is used to type the word to be replaced, in find and replace option? The word to be replaced is typed in Replace text box.

PowerPoint Presentation : 9. Which red lines are used by the StarOffice to underline the words that do not match? StarOffice Writer underlines with squiggly red lines the words that do not match. 10. How StarOffice can help when right spelling is not known? If right spelling is not known, StarOffice writer can help the users with some choices.

PowerPoint Presentation : 11. Will the StarOffice Writer automatically correct some of the common misspellings? Yes, The StarOffice Writer will automatically correct some of the common misspellings. 12. Does StarOffice Writer puts squiggly green line under some words to alert some possible spelling mistake? No, StarOffice doesn’t puts squiggly green line under some words to alert some possible spelling mistake.

PowerPoint Presentation : 13. If the right spelling is not known, can StarOffice writer help the user with some choice? Yes, if the right spelling is not known, StarOffice writer can help the user with some choice. 14. Does change list of spell dialog box, display alternative spellings? No, change list of spell dialog box does not display alternative spellings.

PowerPoint Presentation : 15. Does the Ignore once button skip a particular occurrence of the word and stop on the next one? Yes, Ignore once button skips that particular occurrence of the word and stop on the next one. 16. Does Ignore all button skip all occurrences of the word? Yes, Ignore all button skips all occurrence of the word.

PowerPoint Presentation : 17. Can Backspace key be pressed to delete a misspelt word? Yes, Backspace key is pressed to delete a misspelt word. 18.Does Staroffice writer recognise some common misspelling and typing mistake? No, Staroffice writer doesn’t recognise some common misspelling and typing mistake.

PowerPoint Presentation : 19.Whether the ‘only check box’ in the auto correct dialog box is text only? Yes, the only check box in the auto correct dialog box is text only. 20. Can Spelling mistakes be corrected both while typing and after entire document typed? Yes, Spelling mistakes can be corrected both while typing and after entire document is typed.

PowerPoint Presentation : 21.Which includes a dictionary spell-check program? Star Office writer includes a dictionary spell-check program. 22. Which feature of StarOffice Writer will check for possible spelling mistake? StarOffice Writer has an Automatic spell check feature that can check for possible spelling mistake.

PowerPoint Presentation : 23. What does Auto-spell check of StarOffice Writer do when each word is typed ? When Auto-spell check is on, StarOffice Writer compares each word typed with words in the dictionary. 24. Which colour squiggly line is used to display the misspelled words? StarOffice Writer underlines the misspelled with squiggly red line.

PowerPoint Presentation : 25. What can be done after a document is created? The Correction can be made after a document is created. 26. Which key is pressed to delete a misspelled word or the word is retyped? Backspace key is pressed to delete a misspelled word or the word is retyped.

CHAPTER 4 : CHAPTER 4 WORKING WITH TABLES

PowerPoint Presentation : 1. Which textbox is used to name a table ? The name of a table is given in the name text box. 2. How does the StarOffice writer display a table? StarOfficeWriter displays a table as grid.

PowerPoint Presentation : 3. How a table is displayed? A table is displayed with specified number of columns and rows. 4. Which is the first icon in the toolbar? InsertTable icon is the first icon in the toolbar .

PowerPoint Presentation : 5.Which key is pressed to move forward through the cells? Tab key is pressed to move forward through the cells. 6.Which key is pressed to move backward through the cells? Shift+tab key is pressed to move backward through the cells .

PowerPoint Presentation : 7.What is the simplest way to add a row in a table? The simplest way to add a row is to press tab in the last row of table. 8. What is the command to insert more than one row or column in the table? The command to insert more than one row or column in the table is table -> insert -> rows or table -> insert ->columns.

PowerPoint Presentation : 9.What will you get when Table ->Table properties command is used ? If Table -> Table properties command is used , we can get a table format dialog box. 10.Where does Inserting column icon inserts a column ? Inserting column icon inserts a column to the right of the current column.

PowerPoint Presentation : 11. What will be deleted when delete key is pressed ? The delete key will delete only the entries and not the table. 12. Which is included by default in a table? By default, each cell in a table includes a border.

PowerPoint Presentation : 13. Which toolbar appears when view -> insert is selected from menu bar? Floating toolbar appears when view -> insert is selected from menu bar. 14.Which icon is used to combine two or more cell into a single cell? Merge icon is used to combine two or more cell into a single cell.

PowerPoint Presentation : 15.How is each table identified? Every table is identified by a specific name. 16.Can Table -> Insert-> Table be selected from menu bar? Yes ,Table -> Insert-> Table is selected from menu bar

PowerPoint Presentation : 17.Can the border of a table be changed after the table is created? No, the border of a table cannot be changed after the table is created. 18. Can any amount of text be typed within the cell? Yes, any amount of text can be typed within the cell.

PowerPoint Presentation : 19. Does the number of rows and columns be changed once the table is created? No, the number of rows and columns cannot be changed once the table is created. 20.Does the menu option Table -> Delete -> Table delete only the entries in a table? No, the menu option Table -> Delete -> Table does not delete only the entries in the table.

PowerPoint Presentation : 19. Does the no of rows and columns change once the table is created? No the no of rows and columns does not change once the table is created. 20.Does the menu option Table -> Delete -> Table delete only the entries in the table? No the menu option Table -> Delete -> Table does not delete only the entries in the table.

PowerPoint Presentation : 21. Is the insertion point placed in the first cell of a table when a table is created ? Yes , StarOffice Writer places the insertion point in the first cell of the table. Is a row can be inserted by selecting the row icon? Yes, a row can be inserted by selecting the row icon.

PowerPoint Presentation : 23. Can width of a column in a table be changed? No, in a table the width of the column cannot be changed. 24. Does Delete row icon delete the row below the current row? No, the Delete row icon does not delete the row below the current row.

PowerPoint Presentation : 25. Can the Border icon be used to choose the style of the line for the border? No, Border icon is not used to choose the style of the line for border. 26. What do you call the intersection of column and a row ? Intersection of column and a row is called a cell.

PowerPoint Presentation : 27. Which icon displays a palette of colours that can be used as a border colour for the table? Border Colour icon displays a palette of colours that can be used as a border colour for the table. 28. Which icon deletes the current column from the table? Delete icon deletes the current column from the table.

PowerPoint Presentation : 29. Which command delete the selected rows in a table? table->delete->rows command deletes the selected rows in the table. 30.What is a table? A table is a grid with a specified number of rows and columns.

CHAPTER 5 : CHAPTER 5 PAGE FORMATTING

PowerPoint Presentation : List the methods that may be used to change the margin? Page Style Dialog Box and Changing Margins using Rulers are the methods used for changing the margin. 2. How is the area at the top of the page called? The area at the top of the page is called Header.

PowerPoint Presentation : 3. What are the 2 ways in which the page can be oriented? Portrait and Landscape are the two types of Page Orientations. 4. What is the name of the area at the bottom of the page? Footer is an area at the bottom of the page.

PowerPoint Presentation : 5. Which option on the view menu is used to change the margins ? Ruler option on the view menu can be used to change the margins. 6. Which dialog box is used to set the width of the paper ? Page Style dialog box is used to set the width of the paper.

PowerPoint Presentation : 7. What is the default left margin size in the document? 1.25 inches is the default left margin in document. 8. How can the format of the page numbers changed? The format of the page numbers can be changed using Page style dialog box.

PowerPoint Presentation : 9. By using which option the overall picture of the document can be viewed? Page Preview option gives the overall picture of the document. 10.What is the default page orientation? The default page orientation is Portrait.

PowerPoint Presentation : 11 . In which orientation the width of a page is more than its length? In Landscape orientation the width of a page is more than its length. 12. What option is chosen to display the ruler on the screen ? View -> Ruler option can be chosen to display the ruler on the screen.

PowerPoint Presentation : 13. What is the dimension of the paper used to print the document? Most documents are printed in 8 inch by 11 inch paper. 14. Name the reference remarks added at top and bottom of every page? Header and Footer are some references remarks added at top and bottom of every page.

PowerPoint Presentation : 15.Which dialog box can be used when the user knows the exact value for the margins? If the user knows the exact value for the margins then the Page Style dialogue box can be used to make the change. 16. Does the Header appear at the bottom of each page? No Header does not appear at the bottom of each page.

PowerPoint Presentation : 17. Is the default top margin 1inch? No the default top margin is not 1inch. 18. The default left margin of document is 1 inch. State yes/no No The default left margin of document is not 1 inch.

PowerPoint Presentation : 19. Landscape is the default page orientation. State yes/no. No the default page orientation is not landscape. 20. Is Center a type of page margin? No Center is not a type of page margin.

PowerPoint Presentation : 21. Is Portrait and Landscape are Page Orientation? Yes Portrait and Landscape are Page Orientation. 22. Is bold a tab on page style? No Bold is not a tab on Page Style.

PowerPoint Presentation : 23. Is 1.25 inches a default right margin in document? Yes 1.25 inches is the default right margin in document. 24. Can Page numbers of different styles can be inserted to a StarOffice Writer document? Yes Page numbers of different styles can be inserted to a StarOffice Writer document.

PowerPoint Presentation : 25. Does the Footer contain a page number? Yes Footer contains a page number. 26.Can the Page style dialog box be used when the user does not know the exact value for the margins ? No the Page style dialog box cannot be used if the user does not know the exact value for the margins.

PowerPoint Presentation : 27. Is there any option for the user to change the paper size? No There is no option for the user to change the paper size. 28. Is Portrait orientation known a Landscape orientation? No Portrait orientation is not known a Landscape orientation.

PowerPoint Presentation : 29. Does Page Preview displays the default margins of a page? No Page Preview does not display the default margins of a page. 30. Does Margins control how close StarOffice Writer prints to the edge of the page? Yes Margins control how close StarOffice Writer prints to the edge of the page.

CHAPTER-6 : CHAPTER-6 SPREADSHEET

PowerPoint Presentation : 1. When did the personal computers first appear? The personal computers first appeared in 1975. 2. Name the first electronic spreadsheet. Visicalc (visible calculator) was the first electronic spreadsheet.

PowerPoint Presentation : 3. Which application is used to calculate and analyse sets of numbers? Spreadsheet is used to calculate and analyse sets of numbers. 4.How are non numerical entries otherwise known as. Non numerical entries are known as labels.

PowerPoint Presentation : 5. What are the basic components of spreadsheets ? Spreadsheets are made up of Rows and columns 6. List the elements that can entered in the cells. Cells can contain Values, labels or formulae.

PowerPoint Presentation : 7. Which sign is used to indicate the start of the formula ? A formula begins with = sign 8. Which pointer identifies an active cell? Cell pointer identifies the active cell.

PowerPoint Presentation : 9. What are the two types of cell addressing? The two types of cell addressing are relative and absolute. 10. Name the two bars at the extreme bottom of the window. Status and scroll bars are at the extreme bottom of the window.

PowerPoint Presentation : 11. Which command is used to generate a series? Edit->fill->series is used to generate a series. 12. Which command is used to insert charts? Insert->Chart or Insert Chart icon is used to insert charts

PowerPoint Presentation : 13. In the input line of which bar does the formula appear? The formula appears on the input line in the formula bar. 14. Which sign is used in front of row/column name to make the cell address absolute ? A cell address can be made absolute by using $ sign in front of row/column name

PowerPoint Presentation : 15. What is the default cell addressing used by StarOffice Calc? Relative cell addressing is the default cell addressing used by StarOffice Calc. 16. Where is the Menu bar situated in the window? Menu bar is situated at the top of the window.

PowerPoint Presentation : 17. What do you mean by Functions in Star Office Calc? Functions are predefined formulas that are available in StarOffice Calc. 18. Which facility of Star office Calc helps to format the worksheet with different predefined styles and colours? Predefined facility of Star office Calc helps to format the worksheet with different predefined styles and colours.

PowerPoint Presentation : 19. Which option specifies the contents to be deleted from a cell or cell range? Delete option specifies the contents to be deleted from a cell or cell range. 20. Which option under print dialog box allows to print only the selected area of the worksheet? Selection content option under print dialog box allows to print only the selected area of the worksheet.

PowerPoint Presentation : 21. Can movies, sounds, charts, floating frame, applets and OLE objects be inserted in a worksheet? Yes, movies, sounds, charts, floating frame, applets and OLE objects can be inserted in a worksheet. 22. Can range of 2 cells on a spreadsheet be defined for printing? Yes range of cells on a spreadsheet can be defined for printing .

PowerPoint Presentation : 23. Can a cell be referred to by its address? Yes, a cell can be referred to by its address. 24. Are calculations automated through the built-in mathematical, financial and statistical functions? Yes, calculations are automated through the built-in mathematical, financial and statistical functions

PowerPoint Presentation : 2 5. If the data entered is a word, does the program recognize and allow performing calculations on it? No, if the data entered is a word, the program does not recognize and allow performing calculations on it. 26. Does StarOffice Calc allow to enter date and time in the worksheet? Yes, StarOffice Calc allow to enter date and time in the worksheet

PowerPoint Presentation : 27. Can Spreadsheets in StarOffice manage large amounts of data? Yes, Spreadsheets in StarOffice can manage large amounts of data 28. Does StarOffice Calc provide facilities for drawing lines, circles, ellipse, square, and rectangle? Yes, StarOffice Calc provide facilities for drawing lines, circles, ellipse, square, and rectangle

PowerPoint Presentation : 27. Can Spreadsheets in StarOffice manage large amounts of data? Yes, Spreadsheets in StarOffice can manage large amounts of data 28. Does StarOffice Calc provide facilities for drawing lines, circles, ellipse, square, and rectangle? Yes, StarOffice Calc provide facilities for drawing lines, circles, ellipse, square, and rectangle

PowerPoint Presentation : 32. Can Worksheet be viewed in the form of a graph or a chart? Yes, Worksheet can be viewed in the form of a graph or a chart 33. Can Worksheet information be transferred to any database or word processing software? Yes, Worksheet information be transferred to any database or word processing software

PowerPoint Presentation : 34. Does formula bar display the current cell and its contents? Yes formula bar displays the current cell and its content. 35. Is the symbol ^(Caret) a comparative operator? No, the symbol ^(Caret) is not a comparative operator

PowerPoint Presentation : 36. Name the tool used for working with numbers. Spreadsheet is the tool used for working with numbers. 37. What is the data file created with spreadsheet called as? The data file created with spreadsheet called as worksheet

PowerPoint Presentation : 38. What is the text operator used in spreadsheet? & (And) is the text operator used in spreadsheet 39. Which operator(s) can be used as the reference operator in a spreadsheet? Both : and ! can be used as the reference operator in a spreadsheet

PowerPoint Presentation : 40. What is the format for entering the date in the cell of a worksheet? MM/DD/YY is the format for entering the date in the cell of a worksheet

CHAPTER 7 : CHAPTER 7 DATABASE

PowerPoint Presentation : 1. W hich is the word from which the term data is derived ? The term data is derived from the word Datum. 2. What does the word Datum mean? Datum means fact.

PowerPoint Presentation : 3. Which is referred as the name of a memory location that can contain only one data at any point of time? A Variable is referred as the name of a memory location that can contain only one data at any point of time. 4. Name any three numeric data types. Integer, float and double are numeric data types

PowerPoint Presentation : 5. What is the data type of date and time? Date and time are called as numeric data types. 6. What are called as primitive data types? Integer and float are called as primitive data types.

PowerPoint Presentation : 7. What is information? Group of data conveying some meaning is called information. 8. What is a repository of related data or fact called? A repository of related data or facts is called as database.

PowerPoint Presentation : 9. How is data in a database most commonly viewed? Data in a database in most commonly viewed as one or more two dimensional tables. 10. What is an entire collection of related data in one table referred to as? The entire collection of related data in one table is referred to as tables or files.

PowerPoint Presentation : 11. How is a field represented in a database? A table column represents a field in a database. 12. How is a record represented in a database? A table row represents a record.

PowerPoint Presentation : 13. What do you mean by ‘searching’ in a database? Searching is a process to select desired, specific data from a database. 14. What do you mean by ‘sorting’ in a database? Arranging records in alphabetical or numerical order is termed as sorting.

PowerPoint Presentation : 15. What is the term for j oining data from two or more tables? Joining data from two or more tables is termed as Merging. 16.What is the command used to limit the information on screen from the table? “Filter” is the command to limit the information on screen from the table

PowerPoint Presentation : 17. What is a database file that consists of a single data table called? A database file that consists of a single data table is called as flat file database. 18. How are the common field or fields in a database called? T he common field or fields in a database are called as keys.

PowerPoint Presentation : 19.Which Key uniquely identifies every record in table? Primary Key uniquely identifies every record in table. 20. What is defined by its characteristics, attributes and procedures? An object is defined by its characteristics, attributes and procedures

PowerPoint Presentation : 21. What is a program or a collection of programs that allows any number of users to access data, modify it and request to obtain and work with selected records is called ? A program or a collection of programs that allows any number of users to access data, modify it and request to obtain and work with selected records is called as DBMS(database management system). 22.What are the two types of sorting? Sort Ascending, Sort Descending

PowerPoint Presentation : 23. Name the language that is similar to a programming language supported by DBMS ? A language that is similar to a programming language is SQL. 24. Which language is specifically designed for communicating with Database? SQL is designed specifically for communicating with Database.

PowerPoint Presentation : 25. What is a form? A form is simply a screen that displays the field of a record in a spaced out manner. 26. What is a report? A report is printed information based on a query that gathers criteria matching data.

PowerPoint Presentation : 27.Give the option that moves all listed database fields into the table column(s) list box? The ‘>>’ option moves all listed database fields into the table column(s) list box. 28. Give the option that moves the selected database fields into the table column(s) list box? The ‘>’ Option moves the selected database fields into the table column(s) list box.

PowerPoint Presentation : 29. What are the two types of reports ? The two types of reports are Static and dynamic. 30. What are two types of filters? Auto filters, Standard filters.

PowerPoint Presentation : 31. Does computerized data processing take more time? No, the computerized data processing does not take more time. 32. Does Manual data processing involve use of paper at each stage? Yes, the Manual data processing involves use of paper at each stage.

PowerPoint Presentation : 33. What are ‘Character, Number and Boolean’ referred to as? Character, Number and Boolean are referred to as data types. 34. How are records organised in Hierarchical databases? In Hierarchical databases, records are organized in a tree like structure.

PowerPoint Presentation : 35.Which structure represents a database made up of a set of related tables? Relational structure represents a database made up of a set of related tables. 36.Can Query language be used to delete obsolete records? Yes, a Query language can be used to delete obsolete records.

PowerPoint Presentation : 37.Is Filter a type of query ? Yes Filter is a type of query . 38.Expand DBMS DBMS - Database Management System.

PowerPoint Presentation : 39. Which kind of computers used Hierarchical database structures primarily ? The hierarchical database structures were primarily used on Mainframe computers. 40. Which option has to be selected from a database pane to view or modify the design of an existing table? Tables option has to be selected from a database pane to view or modify the design of an existing table

PowerPoint Presentation : 41. Which form of database defines data, data characteristics as complex Objects? Object oriented database defines data, data characteristics as complex objects. 42. Which is the best suited system for small business users? Flat file system is the best suited for small business users.

PowerPoint Presentation : 43. What application helps to create attractive and professional-looking presentation in Star Office ? Impress application helps to create attractive and professional-looking presentation in Star Office. 44. Using which view can one create and edit slides ? Using Normal view one can create and edit slides.

PowerPoint Presentation : 45. Which view helps to reorder slides, edit slide titles and headings ? Outline view helps to reorder slides, edit slide titles and headings. 46. In which view notes can be added to the slides ? In Notes view notes can be added to the slides.

CHAPTER 8 : CHAPTER 8 INTRODUCTION TO MULTIMEDIA

PowerPoint Presentation : Which is a computer-based presentation technique that incorporates text, graphics, sound, animations and video elements? Multimedia is a computer-based presentation technique that incorporates text, graphics, sound, animations and video elements. 2. Which application allows you to send and receive messages over cell phones? Multimedia Messaging Service is an application allows you to send and receive messages over cell phones.

PowerPoint Presentation : 3.To which device is the GIF limited? The GIF is limited to 8-bit palette. 4. Which multimedia allow to actively participate instead of just sitting by as passive recipients of information? The multimedia that allow to actively participate instead of just sitting by as passive recipients of information are called interactive multimedia.

PowerPoint Presentation : 5. Name any two common image files. The two common image files are GIF and JPG. 6.What is the pattern of the sounds that are heard? The sounds that you hear are analog wave patterns.

PowerPoint Presentation : 7. Name the technique that converts analog sound waves to digital format. The conversion of analog sound waves to a digital format is known as sampling. 8. Mention the two types of animation. The two types of animation are 2D and 3D dimensional.

PowerPoint Presentation : 9. Give the expansion of MIDI format. The expansion of MIDI format is Musical Instrumental Digital Interface. 10. Who developed the quick time format? The quick time format was developed by Apple.

PowerPoint Presentation : 11. Give the expansion of MMS. MMS stands for Multimedia Messaging System. 12. Give the expansion of WBT. WBT stands for Web Based Tutorial.

PowerPoint Presentation : 13. Give the expansion of GIF. GIF stands for Graphic Interchange Format 14. Give the expansion of JPEG. Expansion of JPEG is Joint Photographic Experts Group

PowerPoint Presentation : 15. Give the expansion of AIFF. AIFF stands for Audio Interchange File Format. 16.Give the expansion of MPEG. MPEG stands for Moving Pictures Experts Group.

PowerPoint Presentation : 17. Give the expansion of AVI. AVI stands for Audio Video Interleave 18. Give the expansion of HTML. HTML stands for Hypertext Markup Language

PowerPoint Presentation : 19. Give the expansion of XHTML XHTML stands for Extended Hypertext Markup Language 20. Give the expansion of HTTP . HTTP stands for Hyper Transfer Protocol

PowerPoint Presentation : 21.What are the two types of video compressions? The two types of video compressions are Lossless and Lossy. 22. Who developed the WAVE format The WAVE format was developed by IBM and Microsoft.

PowerPoint Presentation : 23. What is the format used to store sound? MP3 is the format used to store sound. 24. Who developed Shockwave format ? Shockwave format was developed by Macromedia.

PowerPoint Presentation : What are the two attributes that control the sound? The two attributes that control the sound are Amplitude and Frequency What is the other name of Frequency? Frequency is also called as pitch.

PowerPoint Presentation : What is primary purpose for developing Quick time Format? The Quick Time format was developed primarily to store Videos. Define JPG? JPG is a lossy compression image.

PowerPoint Presentation : What is extension for sound File Extension for sound file is . snd . What is a NxView file? NxView file is a image format file.

PowerPoint Presentation : What is the extension for Audio Video Interleave format file? Audio Video Interleave format file has an extension . avi . What is the extension for Files in window media format? Files in window media format have . wmv extension.

PowerPoint Presentation : 33. What are the tags used to add the inline sound to a web page? Inline sound can be added to a web page by using tags < bgsound > and < img >. 34. What is frame count to make a video look jerky? Reducing the frame count to less than 15 frames per second causes the video to look jerky.

PowerPoint Presentation : How much should we reduce the color depth to make the image look murky? Reducing the color depth to less than 256 colours results in the image looking murky. How to retain the exact image throughout the compression? Retaining the exact image throughout the compression is termed as lossless compression.

PowerPoint Presentation : 37. Are High-end graphics and animations frequently used to make computer games thrilling and realistic? Yes, the High-end graphics and animations are frequently used to make computer games thrilling and realistic. 38.Does Multimedia have only one image format? No, Multimedia does not have only one image format.

PowerPoint Presentation : 39. Are the JPEG image files are in lossless format? No, JPEG image files are not lossless format. 40. Do vendors provide special hardware called vector graphics cards to improve the efficiency in the display of images? Yes, many vendors provide special hardware called vector graphics cards to improve the efficiency in the display of images

PowerPoint Presentation : 41. Do the attributes amplitude and frequency control the characters of sound? Yes, the two attributes that controls the characters of sound are amplitude and frequency. 42. Is Morphing a technique by which you can blend two or more images to form a new image? Yes, Morphing is a technique by which you can blend two or more images to form a new image.

PowerPoint Presentation : 43.Shouldn’t you have to convert the video signal into a digital format before including it in a multimedia application? No, you should not have to convert the video signal into a digital format before including it in a multimedia application 44.Can Sound and video in multimedia applications play inline and helper? Sound and video in multimedia applications can be played inline and helper

PowerPoint Presentation : 45.During a regular HTTP transfer, is the entire file downloaded to the user’s computer? Yes, During a regular HTTP transfer, the entire file is downloaded to the user’s computer. 46. Does the Files in the quick time format have the . mov as extension? Yes, the Files in the quick time format have the . mov as extension.

PowerPoint Presentation : 47. Do the files in the shock wave format have . swf as extension? Yes, the files in the shock wave format have . swf as extension. 48. Is GIF not well fitted for photographic work? Yes, GIF is not well fitted for photographic work.

PowerPoint Presentation : 49. Can Helper applications be launched using the tags? No, Helper applications cannot be launched using the tags. 50. Which compression algorithm takes advantage of the human visual senses and discards information that would not be sensed by the bye? Lossy compression algorithm takes advantage of the human visual senses and discards information that would not be sensed by the bye

PowerPoint Presentation : 51. How is the 2-D animations classified? The 2-D animations are broadly classified into cell-based and Object-based. 52. Which is the technique of distorting a single image to represent something else? Wraping is the technique of distorting a single image to represent something else.

PowerPoint Presentation : 53. When was the MIDI format developed? The MIDI format was developed in 1982. 54. When and by whom was the RealAudio format developed? The RealAudio format was developed by RealNetwork in 1995.

PowerPoint Presentation : 55. What is the extension of the files in AIFF format? The files in the AIFF format have the extension .aif or .aiff. 56. Who developed AIFF and SND? The AIFF and SND was developed by Apple.

PowerPoint Presentation : 57. Who developed QuickTime format? The QuickTime format was developed by Apple. 58.Who developed MPEG format? The MPEG format was developed by Moving pictures expert group. 59.What is the extension of Mp3 format? The Mp3 format has .mp3 or . mpga extension.

CHAPTER 9 : CHAPTER 9 PRESENTATION

PowerPoint Presentation : 1. How to rename the slide? Slide -> rename Slide (or) Right click on the slide and choose Rename Slide will be chosen to rename the slide, select the slide. 2. Which option will be chosen to insert movie in a slide? Insert -> Movie and Sound (or) Insert Movie and Sound icon will be chosen to insert movie in a slide.

PowerPoint Presentation : 3. What enables Media Player where you can preview movie and sound files ? Star Office Impress enables Media Player where you can preview movie and sound files. 4. Which check box will be selected to apply the slide design to all the slides in your presentation ? Exchange background page check box will be selected to apply the slide design to all the slides in your presentation.

PowerPoint Presentation : 5. What is determined by the slide layout ? The number of Outline levels is determined by the slide layout. 6. How can slides in a presentation can be printed, so that several slides can be printed on a single page of paper ? Slides in a presentation can be printed as Handouts so that several slides can be printed on a single page of paper.

PowerPoint Presentation : 7. Which check box has to be checked to start the selected custom slide show when you click the start button ? Use Custom Slide Show check box has to be checked if selected to start the selected custom slide show when you click the start button. 8. What timings are assisted by the Star Office in defining the timings for the automatic slide changes ? Right rehearse timings are assisted by the Star Office in defining the timings for the automatic slide changes.

PowerPoint Presentation : 9. Which is used to move from slide to slide quickly? Using Navigator you can move from slide to slide quickly. 10. Which slide determines the text formatting style for the title and the outline ? Master slide determines the text formatting style for the title and the outline.

PowerPoint Presentation : 11. What application helps to create attractive and professional-looking presentation in Star Office ? Star office Impress application helps to create attractive and professional-looking presentation in Star Office. 12. W hich view can create and edit slides ? Using Normal view one can create and edit slides.

PowerPoint Presentation : 13. Which view helps to reorder slides, edit slide titles and headings ? Outline view helps to reorder slides, edit slide titles and headings. 14. In which view notes can be added to the slides ? In Notes view notes can be added to the slides.

PowerPoint Presentation : 15. How to view the slides as miniature images? Viewing the slides as miniature images and rearranging them is done with the Slide Sorter view. 16. How to include information in all the slides? Information to be included on all the slides should be placed on the Master page.

PowerPoint Presentation : 17. How to start the presentation? Slide Show option is used to start the presentation. 18.Which is used to stop , loop or mute the play back of the file? Media Playback bar can be used to stop, loop, as well as to adjust the volume or mute the playback of the file.

PowerPoint Presentation : 19. W hich icon turns the sound off and on. Mute icon turns the sound off and on. 20.Which object is used to import objects from other application into a presentation. Insert OLE object is used to import objects from other application into a presentation.

PowerPoint Presentation : 21. Which is used to make sure that the presentation fits within a certain time. Rehearse timing is used to make sure that the presentation fits within a certain time

PowerPoint Presentation : 22. Answer is ambiguous 23. Doesn’t the media player embedded in Star Office impress supports different audio and video formats. No,The media player embedded in Star Office impress does not support different audio and video formats.

PowerPoint Presentation : 24.Do the pictures give effect to an object in a slide? No, Pictures will not give effect to an object in a slide. 25. Does the Outline view allow you to reorder slides, edit slide titles and headings? Yes, Outline view allows you to reorder slides, edit slide titles and headings.

PowerPoint Presentation : 26. Does Slide transition display various transition effects that can be attached to a slide. Yes , Slide transition displays various transition effects that can be attached to a slide. 27. W hether Ctrl+N is selected, to create a new presentation using a template. No,To create a new presentation using a template Ctrl+N is not selected.

PowerPoint Presentation : 28. Does Custom animation display various transition effects that can be attached to a slide. No,Custom animation does not display various transition effects that can be attached to a slide. 29. Can the insert OLE object be used to import objects from other application. Yes , Insert OLE object is used to import objects from other application.

PowerPoint Presentation : 30. Can F10 key be used to open the styles and formatting window. No , F10 key is not used to open the styles and formatting window. 31. Can tab key be used to select a range of slides. No, Tab key is not used to select a range of slides.

PowerPoint Presentation : 32. Which icon on the presentation Toolbar should be clicked to start the presentation. To start a presentation, click Slide Show icon on the presentation Toolbar. 33. How to end the presentation? We can end the presentation using Escape Key

PowerPoint Presentation : 34.How to delete a slide ? If you want to delete the slide, select the slide and press/choose Delete key or Delete Slide 35.How to change the slide order? To change the Slide order, click Slide Sorter in the switching presentation view tab.

PowerPoint Presentation : 36.How to insert picture in a slide? To insert the picture in a slide, choose picture from the insert toolbar. 37.Which Icon is used to turn the sounds off and on? To turn the sounds off and on press Mute icon .

PowerPoint Presentation : 38.In which view the effects can be assigned for a presentation? The effects in presentation can be assigned using the Normal View or View ->Normal View 39.Which allows you to display important slides during a presentation? Custom Slide Show allows you to display important slides during a presentation.

PowerPoint Presentation : 40. Which helps to produce an attractive HTML presentation? Star Office impress automatically starts a wizard to help you to produce an attractive HTML presentation. 41. How can you print the current document? In Star Office, you can print the current document by clicking the Print File Directory icon in the Function Bar.

5 Followers

Your Facebook Friends on WizIQ