Class 9 Computer Science Chapter 3 Office Application Question Answer, SEBA Class 9 Computer Science Solutions, NCERT Class 9 Computer Science Chapter 3 Office Application to each chapter is provided in the list so that you can easily browse throughout different chapters SCERT Class 9 Computer Science Chapter 3 Office Application and select needs one.
Class 9 Computer Science Chapter 3 Office Application
Also, you can read the SCERT book online in these sections Solutions by Expert Teachers as per SCERT (CBSE) Book guidelines. NCERT Solution of Class 9 Computer Science Chapter 3 Office Application is part of AHSEC All Subject Solutions. Here we have given Class 9 Computer Science Chapter 3 Office Application Notes for All Subjects, You can practice these here in Class 9 Computer Science.
ADDITIONAL QUESTIONS AND ANSWERS
1. What is a spreadsheet?
Ans. Spreadsheets are a collection of cells that help you manage the data. A single workbook may have more than one worksheet.
2. What is Microsoft Excel?
Ans. Microsoft Excel is an electronic worksheet or spreadsheet application which is used for organising, storing, and manipulating and analysing data. It is developed by Microsoft.
3. What are cells?
Ans. The area where data is stored is known as cell.
4. What is a cell address in Excel?
Ans. A cell address is used to identify a particular cell on a worksheet. It is denoted by a combination of the respective column letter and a row number.
5. What is the maximum number of rows supported in a Excel 2007 worksheet?
Ans. 1,048,576.
6. What is the maximum number of columns supported in a Excel 2007 worksheet?
Ans. 16,384.
7. What is the default extension of Microsoft Excel 2007 file?
Ans. .xlsx.
8. If ‘A1’ is displayed in Name Box, what does it indicate?
Ans. First column (by A) and first row (by 1).
9. What are charts in MS Excel?
Ans. Charts are used to enable graphical representation of the data in Excel. A user can use any chart type, including column, bar, line, pie, scatter, etc. by selecting an opting from Insert tabs ‘ Chart group.
10. How to sun up the rows and column number quickly in the Excel sheet?
Ans. The SUM function is used to get the total sum of the rows and columns, in an excel worksheet.
11. What are the advantages of using formula in Excel sheet?
Ans. Formula makes it easy to calculate the numbers in Excel sheet. It also calculates automatically the number replaced by another number or digit. It is used to make complex calculations easy.
12. What do you understand by Relative Cell Addresses?
Ans. Whenever you copy formulas in Excel, the addresses of the reference cells get modified automatically in order to match the position where the formula is copied. This is done by a system that is called Relative Cell Addresses.
13. In case you don’t want to modify the cell addresses when they are copied, what should you do?
Ans. If you do not want Excel to change the addresses when you copy formulas, you must make use of Absolute Cell Addresses. When you use Absolute Cell References, the row and the column addresses do not get modified and remain the same.
14. What will you if you want to change either the column letter or row number but not both?
Ans. To do this, you must make use of Mixed Cell Addresses where either the row or column is relative while the other is absolute.
15. Explain SUM function.
Ans. The SUM function is used to calculate the sum of all the values that are specified as a parameter to it. The syntax of this function is as follows:
SUM (number1, number2,…).
16. What is the use of COUNTA function?
Ans. COUNTA function is used to counts the number of cells in a given range that are not empty.
SYNTAX :
COUNT (value1, [value2 ], …).
17. How do you find averages in MS Excel?
Ans. Average can be calculated using the AVERAGE function.
SYNTAX:
AVERAGE (number1, number2, …).
18. What is the difference between formulas and functions in Excel?
Ans. Formulas are that are defined by the user that is used to calculate some results. Formulas either be simple or complex and they can consist of values, functions, defined names, etc.
A function, on the other hand, is a built-in piece of code that is used to perform some particular action. Excel provides a huge number of built-in functions such as SUM, PRODUCT, IF, SUMIF, COUNT, etc.
19. Explain the significance of Freezing panes in Microsoft Excel.
Ans. Freeze panes keep the rows and columns visible while scrolling through a worksheet.To freeze panes, select the View tab and go to Freeze Panes.
20. How to get the current date in Microsoft Excel?
Ans. We can get the current date by using = TODAY () function.
21. Which function is Excel tells how many numeric entries are there?
Ans. COUNT function.
22. What is sorting in Excel?
Ans. The process of arranging the items of a column in some sequence or order is known as sorting.
23. What type of chart is useful for comparing parts of a whole?
Ans. Pie chart.
24. What type of chart is good for single series of data?
Ans. Pie Chart.
25. How many sheets are there, by default, when we create a new Excel file?
Ans. 3.
26. What type of chart will you use to compare performance of sales of two products?
Ans. Column Chart.
27. How will you write the formula for the following? – Multiple the value in cell A1 by 10, add the result by 5, and divide it by 2.
Ans. To write a formula for the above-stated question, we have to follow the PEMDAS Precedence. The correct answer is.( (A1*10)+5)/2.
PART-III : MS-Powerpoint
Important Terms (Basic Concepts)
● Presentation: The presentation is a collection of individual slides that contain information on a topic.
● Slide: An electronic page in a presentation is called slide.
● Slide Master: Slide Master is a tool used in Microsoft PowerPoint to create slide templates.
● Slide Show: This is the full screen presentation mode that allows us to show the presentation slides to the audience.
● Themes: Templates are the predesigned presentation provided with PowerPoint which can be used to design customised presentations.
● Animation: Animation is something that makes slide objects move on a slide.
● Transition: Transition is a special effect that allows to specify how to navigate from one slide to other.
● Grouping: Grouping lets you rotate, flip, move, or resize all shapes or objects at the same time as though they were a single shape or object.
TEXTUAL QUESTIONS AND ANSWERS
OBJECTIVE TYPE QUESTIONS
1. Fill in the blanks.
(a) An electronic page in a presentation is called _____.
Ans. slide.
(b) New Slide button for inserting a new slide can be found on ______ tab.
Ans. Home.
(c) In ________ view, you can see all the slides in a presentation concurrently.
Ans. slide sorter.
(d) _____ is a special effect that allows to specify how to navigate from one slide to other.
Ans. Transition.
(e) The _____ Animation enhance uses the flying effect on the text and character.
Ans. custom.
2. Choose the correct option.
(a) ____ is the default file name for a Power point presentation.
(1) Untitled 1
(2) Book 1
(3) Presentation 1
(4) Document 1
Ans. (3) Presentation 1.
(b) File extension for a PowerPoint 2007 presentation is _____
(1) .Ptt
(2) .pptx
(3) .docx
(4) .clsx
Ans. (2) .pptx.
(c) The custom animation can apply____
(1) Font work gallery
(2) Gallery
(3) Text
(4) All of these
Ans. (4) All of these.
(d) The entire presentation can be seen at a time in ______
(1) Slide Show view
(2) Outline view
(3) Normal view
(4) Slide Sorter view
Ans. (4) Slide Sorter view.
(e) Special effect used to introduce slides in a presentation are ____
(1) transitions
(2) effects
(3) custom animations
(4) annotations
Ans. (1) transitions.
DESCRIPTIVE TYPE QUESTIONS
3. Short answer questions.
1. Write down the name of default view in a PowerPoint presentation.
Ans. Normal view.
2. Differentiate between an a presentation and a slide.
Ans.
| PRESENTATION | SLIDE |
| (1) The presentation is usually created using a presentation software program. | (1) A slide refers to a “single page of a presentation”. |
| (2) The presentation is a collection of individual slides that contain information on a topic. | (2) A slide generally points to a single page created using a presentation software program such as “Microsoft PowerPoint”. |
3. Write use of layouts in PowerPoint.
Ans. Slide layouts contain formatting, positioning, and placeholder boxes for all of the content that appears on a slide. Placeholders are the dotted-line containers on slide layouts that hold such content as titles, body text, tables, charts, SmartArt graphics, pictures, clip art, videos, and sounds.
4. In PowerPoint 2007 under the Insert tab, there is a button named Text Box. What is the utility of this button?
Ans. We can add text to a Power Point slide or a slide master by inserting a text box and typing inside that box. We can then format that text by selecting the text or the entire box.
5. Animation is a feature, which you can use in your presentation. What is the purpose of this feature?
Ans. Animation can help make a Power Point presentation more dynamic, and help make information more memorable. Animation is something that makes slide objects move on a slide. And slide objects can be anything on a slide; these include text, pictures, charts, SmartArt graphics, shapes, even movie clips.
6. Write three functions that can be performed in slide Sorter view of a presentation.
Ans. The function that can be performed in slide Sorter view of a presentation are:
● It shows the multiple slides in the presentation on the screen at the same time.
● We can change the order of the slides by dragging them.
● We can delete a slide by selecting it & using the Delete Key.
7. How are Header and Footer useful?
Ans. Header or footer is the text that appears at the top (header) or bottom (footer) of each page in your presentation. This is a standard text or line of text that might include the company name, copyright or trademark symbols, time date information, presenter name or Evan a page number.
8. Differentiate between Slide Transition and custom Animation.
Ans.
| SLIDE TRANSITIONS | CUSTOM ANIMATION |
| (1) Slide transitions are the looks that take you from one slide to the next. | (1) Custom Animations are the movements you put on text, pictures, objects on an individual slide. |
| (2) Slide translations apply to slides themselves. | (2) Custom Animations are applied to objects on a slide. |
9. Explain the various views of a slide available in PowerPoint 2007.
Ans. The different views of a slide are:
| Views | Description |
| (1) Normal View. | (1) A Normal view is the default view size for the screen. |
| (2) Slide Sorter view. | (2) It provides a view of slides in thumbnail from. This view makes it easy to sort and organise the sequence of the slides at the time of creating presentation and also, at the time of preparing presentation for printing. |
| (3) Slide Show View. | (3) This is used to deliver a presentation to the audience. Slide Show view takes up the full computer screen, like an actual presentation. |
| (4) Notes Page View. | (4) Notes can also be printed to handout to the audience or included in a presentation that is delivered to the audience or posted on a Web page |
| (5) Master View. | (5) The Master View include Slide view, Handout view and Notes view. They are the main slides that store information about the presentation, including background colour, fonts effect, placeholder sizes and positions. |
ADDITIONAL QUESTIONS AND ANSWERS
1. What is PowerPoint? Why is it used?
Ans. PowerPoint is a tool of Microsoft that is used to make presentations. It contains slides to present the data.
PowerPoint comes in MS Office Suite. It helps to represent the data in an attractive way by allowing the user to add text, image, graphics, audio, and video in it
2. What are the advantages of Microsoft PowerPoint?
Ans. Microsoft PowerPoint helps the organisations to organise the content in visual from like adding charts, objects, posters, and visuals.
3. Why do we and need to use animations in PowerPoint?
Ans. The animations
● Enhance the appearance of your slides.
● To make a PowerPoint presentation more dynamic.
● We can also add sound to increase the power of your animation effects.
4. What are the components of MS PowerPoint?
Ans. The components of MS PowerPoint include the Office button, Quick Access toolbar, Title bar, Tabs, scroll bars and a Status bar. Quick access toolbar contains buttons for commonly-used commands.
5. What is the default PowerPoint standard layout?
Ans. The Title Slide layout is the default layout when you open a blank presentation in PowerPoint. It comprises two text placeholders: the first for the presentation title and the second for a subtitle
6. Why slide master is used in PowerPoint?
Ans. Slide Master is a tool used in Microsoft PowerPoint to create slide templates, Slide Master can save slide layouts, including the background, colour, fonts, effects, positioning, etc.
7. What is the default view of PowerPoint?
Ans. By default, PowerPoint opens in Normal view, displaying the thumbnails, notes and slide view.
(8) What are the uses of three different views of MS PowerPoint?
Ans. The three different views supported by MS PowerPoint 2007 are:
● Normal view: This is the default PowerPoint view used to create or modify the presentation slides.
● Slide Sorter view: This view is used for rearranging the presentation slides. We can also used for inserting or deleting slides within the presentation.
● Slide Show view: This is the full screen presentation mode that allows us to show the presentation slides to the audience.
9. What is Placeholder?
Ans. Placeholders are the dotted rectangular boxes present on a newly inserted slide to hold various types of objects on it
10. What do you understand by Template?
Ans. Templates are the predesigned presentation provided with PowerPoint which can be used to design customised presentations.
11. What do you understand by Slide Transition?
Ans. Slide Transition is a special visual effect used to introduce the slide in an animated matter during the slide show.
12. Which view is used for screening the presentation slides?
Ans. Slide Show view.
13. What are the different ways to run a Slide Show?
Ans. 1st Method
● Click the Slide Show button located (along with the other View buttons) in the lower-right corner of the screen.
● Click the mouse, or press Enter, the down arrow, Page Down, or the space bar.
2nd Method
● Open the Slide Show tab on the Ribbon.
● Click From Beginning or From Current Slide.
14. What are the various animations options available for applying animation effects on the slide objects?
Ans. There are four options available object on the slide. These are:
● Entrance: Changes how the selected item appears on the page.
● Emphasis: Draws attention to the selected item while the slide is displayed.
● Exit: Changes the way the selected item disappears from the slide.
● Motion Path: Animates the selected item so it moves to a specific place on the screen.
15. What are the steps to create a new presentation?
Ans. To create a new presentation, the steps are :
” Click the Microsoft Office button, and choose New from the menu.
” The New Presentation dialog box will appear. Blank presentation is selected by default.
” Click Create, and a new presentation will open in the PowerPoint window.
16. How can you select non-contiguous slides of your presentations?
Ans. In a presentation non-continuous slides can be selected by holding down CTRL key and then clicking on each slide to be selected.
17. What do you mean by Slide Show?
Ans. The Slide Show refers to an electronic presentation that can be seen on a computer screen or a projection device.
18. Define slide layout?
Ans. Slide layout refers to the general arrangement of various slide components.
Hi, I’m Dev Kirtonia, Founder & CEO of Dev Library. A website that provides all SCERT, NCERT 3 to 12, and BA, B.com, B.Sc, and Computer Science with Post Graduate Notes & Suggestions, Novel, eBooks, Biography, Quotes, Study Materials, and more.
