Chapter 4 FIT — computer Notes — Polytechnic FIT unit -4 Office Tools

byVishal writer -

 


Chapter 4 FIT — computer Notes — Polytechnic FIT unit -4 Office Tools



Chapter 4 FIT — computer Notes — Polytechnic FIT unit -4 Office Tools





Chapter 4: Office Tools | Vishalwriter.com
📘 Chapter 4: Office Tools
Vishalwriter.com | FIT Notes
📝📊📽️📐🎨
✍️ Writer📊 Calc🎬 Impress📐 Formulas🎨 Styles
📘 Vishalwriter.com | OpenOffice • Writer • Calc • Impress • Formulas • Styles • Animations
🧑‍🏫 Complete notes for Chapter 4 with mark‑wise answers (1,2,4,8 marks) and 52 MCQs. Compact mobile‑friendly format.

🔹 A. One Word Answer (1 Mark each)

1. __________ helps the user to perform office related tasks easily. 1 Mark
👉 Office Tool
2. PowerPoint is a __________ tool in MS Office. 1 Mark
👉 Presentation
3. The presentation tool in OpenOffice suite is __________. 1 Mark
👉 Impress
4. Calc is a __________ tool in OpenOffice. 1 Mark
👉 Spreadsheet
5. The Word Processor tool in OpenOffice is __________. 1 Mark
👉 Writer
6. The common word for book type setting is __________. 1 Mark
👉 Publishing
7. A __________ is a named set of formatting options. 1 Mark
👉 Style
8. A spreadsheet is a grid divided into __________ and __________. 1 Mark
👉 Rows and Columns
9. A saved sequence of commands stored for later use in Calc is __________. 1 Mark
👉 Macro
10. In __________ page the page style for presentation can be defined. 1 Mark
👉 Master
11. The show that can display slides in different sequence is called __________ slide show. 1 Mark
👉 Custom
12. Two styles available for slide master are __________ and __________ style. 1 Mark
👉 Title and Content
13. The formula in which individual values in a cell range are evaluated is called __________ formula. 1 Mark
👉 Array

🔹 B. Very Short Answer (2 Marks each)

1. Define Office Tool. 2 Marks
👉 Software for office tasks like document creation, calculations, presentations. Examples: Writer, Calc, Impress.
2. Name any two freely available office tools. 2 Marks
👉 LibreOffice, Apache OpenOffice.
3. What is Calc? 2 Marks
👉 Spreadsheet software for calculations, data management, and charts. Organizes data in rows/columns.
4. Define OpenOffice Writer. 2 Marks
👉 Word processing software to create, edit, and format documents (letters, reports, books).
5. What is MS Access? 2 Marks
👉 Database management system (DBMS) to store, manage, and retrieve structured data.
6. What is Auto Formatting? 2 Marks
👉 Automatically applies predefined formatting styles to text or tables for consistency.
7. Define Hyperlink. 2 Marks
👉 Clickable element linking one document or location to another. Example: website link.
8. What are Bookmarks? 2 Marks
👉 Markers in a document to quickly navigate to specific locations without scrolling.
9. What is grouping of cells? 2 Marks
👉 Selecting multiple cells together to perform operations like formatting or calculations.
10. Steps to insert a new sheet. 2 Marks
👉 Insert menu → Select Sheet → New sheet added.
11. Method to rename a sheet. 2 Marks
👉 Right‑click sheet tab → Rename → Enter new name → Press Enter.
12. What is a formula? 2 Marks
👉 Expression using numbers, operators, and cell references. Example: =A1+B1.
13. Define function in Calc. 2 Marks
👉 Predefined formula for quick calculations. Example: =SUM(A1:A10).
14. What are nested functions? 2 Marks
👉 Functions inside another function for complex calculations. Example: =IF(A1>50, SUM(B1:B5),0).
15. What is OpenOffice Impress? 2 Marks
👉 Presentation software to create slideshows with text, images, animations.
16. Role of Navigator? 2 Marks
👉 Quick navigation between pages, headings, and objects in a document.
17. Steps to start slide show in Impress. 2 Marks
👉 Slide Show menu → Start from First Slide → Slides display.

🔹 C. Short Answer (4 Marks each)

1. Tools present in an Office suite? 4 Marks
👉 Word Processor (Writer), Spreadsheet (Calc), Presentation tool (Impress), Database tool (Base).
2. OpenOffice components & definition. 4 Marks
👉 Definition: Free, open‑source office suite. Components: Writer, Calc, Impress, Base, Draw.
3. Steps to insert image in Writer using drag & drop. 4 Marks
👉 Open image folder → Select image → Drag → Drop into Writer document.
4. Advantages & disadvantages of linking image file. 4 Marks
✅ Advantages: Reduces file size, easy update. ❌ Disadvantages: Link breaks if file moved, image not displayed.
5. Steps to insert table using table icon. 4 Marks
👉 Click Table icon → Select rows & columns → Click to insert.
6. Four advantages of LibreOffice. 4 Marks
👉 Free & open source, supports many formats, no license cost, regular updates.
7. Menus in LibreOffice main window. 4 Marks
👉 File, Edit, View, Insert, Format, Tools, Table, Help.
8. Cell formats in OO Calc. 4 Marks
👉 Number, Text, Date, Currency, Percentage.
9. Functions: WEEKDAY, YEARS, DATEVALUE, ISLEAPYEAR. 4 Marks
👉 WEEKDAY → day of week; YEARS → years between dates; DATEVALUE → date to numeric; ISLEAPYEAR → leap year check.
10. What is a formula? Examples. 4 Marks
👉 =A1+B1 (addition), =A1*B1 (multiplication), =A1/B1 (division).
11. Four rules for creating functions in Calc. 4 Marks
👉 Start with =, correct syntax, proper brackets, valid arguments.
12. OO Impress and its four uses. 4 Marks
👉 Teaching presentations, business meetings, project presentations, visual demonstrations.
13. Steps to insert new slide in Impress. 4 Marks
👉 Click Insert → Select Slide → New slide added.
14. What is custom animation? Example. 4 Marks
👉 Visual effects on slide objects. Example: Text appears with fade‑in effect.

🔹 D. Long Answer (8 Marks each)

1. What is OpenOffice Writer? List its important features. 8 Marks
📌 OpenOffice Writer is a free, open‑source word processor used to create, edit, format, and print professional documents.
✨ Important Features (8 points):
  • Text formatting (font, size, color, bold, italic, underline).
  • Spell check & grammar suggestions.
  • Insert images, tables, shapes, charts.
  • Page formatting (margins, headers, footers, columns).
  • Templates and styles for consistent design.
  • Mail merge for bulk letters/emails.
  • AutoCorrect and AutoText for faster typing.
  • Cross‑platform (Windows, Mac, Linux) and supports .odt, .doc, .docx, .pdf.
2. Explain character formatting in Writer document. 8 Marks
📌 Character formatting changes the appearance of individual characters or text to emphasize or beautify content.
📝 Types (8 points):
  • Font style: Arial, Times New Roman, Calibri, etc.
  • Font size: From 8pt to 72pt or more.
  • Font color: Red, blue, green, or custom colors.
  • Bold: Makes text darker and thicker.
  • Italic: Slants text to the right.
  • Underline: Adds a line below the text.
  • Strikethrough: Draws a line through the text.
  • Subscript/Superscript: For chemical formulas (H₂O) or powers (x²).
3. What is table? Explain insertion and deletion. 8 Marks
📌 A table is a structured arrangement of data in rows and columns (grid format).
📥 Insertion (3 methods):
  • Table menu → Insert Table → Choose rows/columns → OK.
  • Click Table icon → Drag to select grid size → Click.
  • Shortcut: Ctrl+F12 → Enter rows/columns → OK.
🗑️ Deletion (3 methods):
  • Select table → Press Delete key.
  • Right‑click on table → Delete → Table.
  • Table menu → Delete → Table.
4. What is Reference Range Operator in Calc? Explain. 8 Marks
📌 The Reference Range Operator ( : ) refers to a continuous group of cells between two addresses.
Syntax: FirstCell : LastCell
Examples:
  • A1:A10 → cells A1 to A10.
  • B2:B20 → cells B2 to B20.
  • C1:E5 → rectangular range from C1 to E5.
  • A:A → entire column A.
  • 1:1 → entire row 1.
Use in formulas: =SUM(A1:A10), =AVERAGE(B2:B20), =COUNT(C1:C100).
5. Explain insertion of Graphic Image in Calc. 8 Marks
📌 Inserting a graphic image adds pictures, logos, or visual elements to a spreadsheet.
📋 Steps (6 steps):
  1. Open Calc spreadsheet.
  2. Click on the cell where the image should appear.
  3. Go to Insert menu → select Image.
  4. Browse and select the image file (JPG, PNG, GIF, BMP, SVG).
  5. Click Open or Insert.
  6. Image appears; resize/move as needed.
Alternative methods: Drag & drop, Copy & paste (Ctrl+C / Ctrl+V).
6. Explain main blank window of OO Impress along with panes. 8 Marks
📌 OO Impress window is divided into distinct panes for efficient slide design.
🪟 Four main panes:
  • Slides Pane (left): Displays thumbnails of all slides; used to navigate, add, delete, or reorder slides.
  • Workspace (center): Main editing area; add text, images, shapes, animations.
  • Sidebar (right): Formatting tools, properties, styles, gallery, effects.
  • Notes Pane (bottom): Speaker notes (not visible to audience).
Additional elements: Menu bar, toolbars, status bar.
7. Explain slide show steps in OO Impress. 8 Marks
📌 A slide show is full‑screen playback of a presentation.
🎬 Methods to start (5 ways):
  • Slide Show → Start from First Slide.
  • Slide Show → Start from Current Slide.
  • Press F5 key.
  • Click Slide Show icon in toolbar.
  • Click “Start from First Slide” button in task pane.
Navigation during show: →/↓/Spacebar (Next), ←/↑ (Previous), Esc (Exit).
8. What is custom slide show? Write steps. 8 Marks
📌 A custom slide show displays only selected slides in a specific sequence (not all slides).
Steps to create (6 steps):
  1. Open Impress presentation.
  2. Slide Show → Custom Slide Show.
  3. Click New button.
  4. Enter a name for the custom show.
  5. Select slides from left list → add to right list.
  6. Arrange order → OK → Start.
Use cases: Present to specific audiences, skip unwanted slides, create multiple versions.
9. Define slide master and slide design. Write steps. 8 Marks
📌 Slide Master: controls overall formatting of all slides (background, fonts, colors, logos).
📌 Slide Design: predefined theme and layout templates.
Steps to use Slide Master:
  • Go to View → Master → Slide Master.
  • Make changes (background, font, logo, colors).
  • Click Close Master View.
  • All slides update automatically.
Benefits: Consistency, time saving, professional appearance, easy maintenance.
10. What is custom animation? Write steps to add animation. 8 Marks
📌 Custom animation adds visual effects (motion, fade, zoom) to objects on slides.
🎨 Four types of animations:
  • Entrance: Object appears (Fade In, Fly In, Zoom).
  • Emphasis: Object changes (Spin, Grow, Shake).
  • Exit: Object disappears (Fade Out, Fly Out).
  • Motion Paths: Object moves along a path.
Steps to add (5 steps):
  1. Select the object (text, image, shape).
  2. Click Animation menu or open Sidebar.
  3. Click Add Effect button.
  4. Choose animation type (Entrance/Emphasis/Exit/Motion Paths).
  5. Set timing (duration, delay, start event: On Click / With Previous / After Previous).

📋 50+ MCQs with Answers

1. Word processor in OpenOffice?
  • A) Calc
  • B) Impress
  • C) Writer
  • D) Base
✔ Answer: C
2. Spreadsheet in OpenOffice?
  • A) Excel
  • B) Calc
  • C) Sheets
  • D) Data
✔ Answer: B
3. Presentation tool in OpenOffice?
  • A) Writer
  • B) PowerPoint
  • C) Impress
  • D) Draw
✔ Answer: C
4. Range operator (:) represents?
  • A) Single cell
  • B) Group of cells
  • C) Division
  • D) Subtraction
✔ Answer: B
5. Not an OpenOffice component?
  • A) Writer
  • B) Access
  • C) Calc
  • D) Base
✔ Answer: B
6. Named set of formatting options?
  • A) Theme
  • B) Style
  • C) Template
  • D) Macro
✔ Answer: B
7. Defines overall slide formatting in Impress?
  • A) Title slide
  • B) Master page
  • C) Notes page
  • D) Handout
✔ Answer: B
8. SUM function returns?
  • A) Total
  • B) Average
  • C) Count
  • D) Max
✔ Answer: A
9. Saved sequence of commands in Calc?
  • A) Script
  • B) Macro
  • C) Routine
  • D) Procedure
✔ Answer: B
10. Free office suite?
  • A) MS Office
  • B) LibreOffice
  • C) Apple iWork
  • D) WordPerfect
✔ Answer: B
11. Custom animation in Impress?
  • A) Slide transition
  • B) Visual effects on objects
  • C) Slide background
  • D) Print settings
✔ Answer: B
12. Rename sheet in Calc?
  • A) Double-click tab
  • B) Right-click → Rename
  • C) Both A & B
  • D) File menu
✔ Answer: C
13. Database tool in OpenOffice?
  • A) Base
  • B) Access
  • C) DB
  • D) Tables
✔ Answer: A
14. Calc file extension?
  • A) .doc
  • B) .odt
  • C) .ods
  • D) .odp
✔ Answer: C
15. Leap year check function?
  • A) ISLEAP()
  • B) ISLEAPYEAR()
  • C) LEAPYEAR()
  • D) YEARISLEAP()
✔ Answer: B
16. Impress file extension?
  • A) .odp
  • B) .odg
  • C) .odt
  • D) .odb
✔ Answer: A
17. Pane showing slide thumbnails?
  • A) Workspace
  • B) Slides Pane
  • C) Sidebar
  • D) Notes Pane
✔ Answer: B
18. =MAX(B2:B10) returns?
  • A) Minimum
  • B) Maximum
  • C) Average
  • D) Count
✔ Answer: B
19. IF function does?
  • A) Loop
  • B) Conditional logic
  • C) Sort data
  • D) Chart
✔ Answer: B
20. Add new slide menu?
  • A) Slide Show
  • B) Insert
  • C) Format
  • D) Tools
✔ Answer: B
21. Vector graphics tool in OpenOffice?
  • A) Draw
  • B) Image
  • C) Picture
  • D) Graphic
✔ Answer: A
22. OpenOffice database tool?
  • A) Writer
  • B) Calc
  • C) Base
  • D) Impress
✔ Answer: C
23. Bookmarks in Writer for?
  • A) Hyperlinks
  • B) Quick navigation
  • C) Images
  • D) Page numbers
✔ Answer: B
24. WEEKDAY returns?
  • A) Week number
  • B) Day of week
  • C) Month number
  • D) Year
✔ Answer: B
25. Custom slide show displays slides in?
  • A) Original order
  • B) Different sequence
  • C) Alphabetical
  • D) Random
✔ Answer: B
26. Not a valid cell format?
  • A) Number
  • B) Text
  • C) Image
  • D) Currency
✔ Answer: C
27. Navigator in Writer helps to?
  • A) Table of contents
  • B) Jump between headings
  • C) Spell check
  • D) Page margins
✔ Answer: B
28. Reference range operator in Calc?
  • A) ;
  • B) :
  • C) ,
  • D) &
✔ Answer: B
29. Writer file extension?
  • A) .docx
  • B) .odt
  • C) .ott
  • D) .txt
✔ Answer: B
30. Custom Animation menu?
  • A) Slide Show
  • B) Format
  • C) Tools
  • D) Insert
✔ Answer: A
31. Nested function example?
  • A) SUM(A1:A10)
  • B) IF(A1>10, SUM(B1:B5),0)
  • C) AVERAGE(B1:B5)
  • D) MAX(C1:C10)
✔ Answer: B
32. Mail merge in OpenOffice?
  • A) Writer
  • B) Calc
  • C) Base
  • D) Impress
✔ Answer: A
33. Converts date to numeric?
  • A) DATE()
  • B) DATEVALUE()
  • C) NUMDATE()
  • D) TODAY()
✔ Answer: B
34. AutoFormatting available in?
  • A) Writer only
  • B) Calc only
  • C) Both Writer & Calc
  • D) Impress only
✔ Answer: C
35. Slide master controls?
  • A) Only background
  • B) Overall format & layout
  • C) Only notes
  • D) Only handouts
✔ Answer: B
36. Base file extension?
  • A) .odb
  • B) .obd
  • C) .mdb
  • D) .db
✔ Answer: A
37. Custom slide show menu?
  • A) View
  • B) Slide Show → Custom
  • C) Tools
  • D) Format
✔ Answer: B
38. Array formula evaluates?
  • A) Single value
  • B) Individual values in range
  • C) Only text
  • D) Errors only
✔ Answer: B
39. MS Office presentation tool?
  • A) Word
  • B) Excel
  • C) PowerPoint
  • D) Access
✔ Answer: C
40. SUMIF function does?
  • A) Sums all cells
  • B) Sums cells based on condition
  • C) Counts with condition
  • D) Average on criteria
✔ Answer: B
41. Save document shortcut?
  • A) Ctrl+S
  • B) Ctrl+P
  • C) Ctrl+O
  • D) Ctrl+N
✔ Answer: A
42. Character formatting toolbar?
  • A) Drawing
  • B) Standard
  • C) Formatting
  • D) Table
✔ Answer: C
43. Insert hyperlink shortcut?
  • A) Ctrl+H
  • B) Ctrl+K
  • C) Ctrl+L
  • D) Ctrl+U
✔ Answer: B
44. Insert Sheet menu?
  • A) File
  • B) Edit
  • C) Insert
  • D) Data
✔ Answer: C
45. Slideshow shortcut?
  • A) F5
  • B) F2
  • C) F9
  • D) F11
✔ Answer: A
46. TODAY() returns?
  • A) Current time
  • B) Current date
  • C) Day name
  • D) Year only
✔ Answer: B
47. Corrects typos automatically?
  • A) AutoText
  • B) AutoCorrect
  • C) Spell check
  • D) Thesaurus
✔ Answer: B
48. Grouping of cells means?
  • A) Merging
  • B) Selecting multiple together
  • C) Deleting
  • D) Hiding
✔ Answer: B
49. YEARS function calculates?
  • A) Years between dates
  • B) Age in months
  • C) Days difference
  • D) Leap year
✔ Answer: A
50. COUNTA counts?
  • A) Only numbers
  • B) Non-empty cells
  • C) Blank cells only
  • D) Characters
✔ Answer: B
51. =A1 * B1 performs?
  • A) Addition
  • B) Subtraction
  • C) Multiplication
  • D) Division
✔ Answer: C
52. Navigator shortcut key?
  • A) F5
  • B) F3
  • C) Ctrl+Shift+F5
  • D) F2
✔ Answer: F5
📢 Exam Strategy: For 8‑mark questions on Writer, list 6‑8 features. For Calc, remember the range operator (:) and common functions (SUM, AVERAGE, IF). For Impress, memorise slide master and custom animation steps – frequently asked.
📘 Vishalwriter.com – Chapter 4: Office Tools || 52 MCQs
Tags
Previous Post Next Post

Contact Form