MS POWERPOINT 2019

Q & A

Q1. Define Presentation.
Ans.A presentation is a systematic display of the contents of a topic. It includes text, graphics, pictures, movies, sounds, special effects, etc.

Q2. Define PowerPoint Presentation.
Ans.MS PowerPoint Presentation consists of slides. These are organized and formatted using various  Microsoft PowerPoint features. It is a way of presenting your viewpoint in the form of text and graphics on the slides. These slides are just like the pages of a document. It can contain either text or graphics, or both. It runs continuously in the form of slide show.

Q3. Define the following:

1. Slide Layout.
2. Align text left
3. Align text right
4. Format
5. Format Painter
6. Slide show
7. Slide Transition
8. Subscript
9. Superscript

Ans. 

1. Slide Layout: It is the arrangement of text and graphics on the slide.
2. Align text left: It is the alignment where the text is aligned from the left edge and ragged from the right edge.
3. Align text right: It is the alignment where the text is aligned from the right edge and ragged from the left edge.
4. Format: It arranges text according to a chosen pattern.
5. Format Painter: It allows the user to copy the text format and not the text.
6. Slide show: It runs the slide in full screen mode.
7. Slide Transition: It is the way of moving from one slide to another during a presentation.
8. Subscript: It is reduces the size of the text and lowers it to the bottom of the current line.
9. Superscript: It is reduces the size of the text and raises it to the top of the current line.

Q4. What are Quick keys for PowerPoint Presentation.
Ans. QUICK KEY

1. Ctrl+O - To open a presentation.
2. Ctrl +S - To save a presentation.
3. Ctrl+P - To print a presentation.
4. Ctrl+W- To close a presentation
5. Ctrl+Z-To undo the last work.
6. Ctrl+Y-To redo or repeat.
7. Ctrl+M-To insert a new slide.
8. Ctrl+N-To open a new presentation.
9. PageUp- The previous slide.
10. PageDown-The next slide.
11. The first slide-Ctrl+Home.
12. The last slide-Ctrl+End.
13. Align text left Ctrl+L
14. Align text right Ctrl+R
15. Centre Ctrl+E
16. Justify Ctrl+J

VIDEO TUTORIAL FOR MAKING TIMER AND USING HYPERLINK TO MAKE QUIZ POWER POINT PRESENTATION.👇

EXCEL FORMULAS

Excel Formulas

Function	Formula	Example
To add up the total	=SUM(cell range)	=SUM(B2:B9)
To add individual items	=Value1 + Value 2	=B2+C2
Subtract	=Value1 - Value 2	=B2-C2
Multiply	=Value1 * Value2	=B2*C2
Divide	=Value1 / Value2	=B2/C2
Average	=AVERAGE(cell range)	=AVERAGE(B2:B9)
Percentage		=G4/HG*100
Max	=MAX(cell range)	=MAX(B2:B9)
Min	=MIN(cell range)	=MIN(B2:B9)
Count IF	=COUNTIF(range,value)	=COUNTIF(D5:D11,”red”)
IF		=IF(F2>=90,"A+",IF(F2>=80,"A",IF(F2>=70,"B+",IF(F2>=60,"B",IF(F2>=50,"C","F")))))
Enter Time	Ctrl +Shift :	8:40 AM
Enter Date	Ctrl ;	01/02/2019

Simple formatting tricks

Function	Formula	Example
To change a cell to proper case	=PROPER(cell)	=PROPER(A2)
To change a cell to upper case	=UPPER(cell)	=UPPER(A2)
To change a cell to lower case	=LOWER(cell)	=LOWER(A2)

MS OFFICE AT A GLANCE

Q1. What is Microsoft Office?

Ans. Microsoft Office is a collection of software of Windows based applications. It was designed by Microsoft Corporation keeping in mind the tools required on an office desk.

Q2. What are the components of MS Office?

Ans. The components of MS Office are as follows:

1. MS Outlook
2. MS Word
3. MS Excel
4. MS PowerPoint
5. MS Access
6. MS Publisher

Q3. What are the components of Microsoft Office Window?

Ans. The components of MS Office Windows are:

1. Title Bar
2. Ribbon
3. Office button
4. Office Access Toolbar
5. Status Bar
6. Horizontal Scroll Bar
7. Vertical Scroll Bar
8. Minimize Button
9. Maximize / Restore Down Button
10. Close Button

Q4. Define MS Excel

Ans. MS Excel is a popular spreadsheet program that allows you to work well with numbers. You can store data in Excel in the form of rows and columns that can be organized and processed.

Q5. Define Workbook.

Ans. A file in MS Excel is called workbook. It contains many pages which are called worksheets or sheets.

Q6. Define the following:

Ans.

1. Formula Bar
2. Name box
3. Sheet tabs
4. 4.Charts

1. Formula Bar: this bar is below the Ribbon. It contains the formula entered in cell. The formula in Excel should begin with an equal to (=) sign.

2. Name Box: It contains the cell address of the active cell.

3. Sheet Tabs: These tabs are present below the work book on the lower left -corner.

4. Charts: It is a pictorial representation of data. You can create different types of graph easily from the data in the spreadsheet. Charts once created can easily changed in terms of the charts text, color, size, position, etc.

Q7. Quick Key

CREATING AND EDITING IMAGES IN MS PAINT

QUESTIONS AND ANSWERS

Q1.What are the main components of Paint Window?
Ans.The main components of Paint Window are given here.
Ribbon
The Ribbon consists of different drawing tools. Tabs in the Ribbon are sub-divided into groups. For example, the Home tab contain the following groups: Clipboard, Image, Tools, Shapes and Colors.

Q2. Define the following:

1. Eraser tool 
2. Pencil tool
3. Magnifier tool 
4. Brushes 
5. Fill with color tool
6. Line tool
7. Rectangle tool
8. Oval tool

Ans.
1. Eraser Tool: Eraser tool is used for erasing any part of a picture.

2. Pencil Tool: Pencil tool is used for drawing freehand. It is used in the same way that you would use a real pencil to draw.

3. Magnifier Tool: Magnifier tool is used to see a drawing in a large size.

4. Brushes: Brushes tool is similar to the Line tool  You can use the Brushes tool to draw lines that are different in appearance.

5. Fill with color tool: Fill with color tool is used for filling a selected color in any closed shape that has already been drawn.

6. Line Tool: Line tool is used for drawing straight lines in Paint.

7. Rectangle Tool: Rectangle tool is used for drawing rectangles and squares.

8. Oval Tool: Oval tool is used for drawing circles and ovals.


Q3. What is difference between 2D and 3D shapes? Give examples with diagram.
Ans. 
2D shapes

A shape or a figure that has a length and a breadth only is a 2D shape. The sides are made of straight or curved lines. They can have any number of sides. 

Examples of 2D shapes and figures

We say that a figure that is drawn on paper and has only length and breadth is a 2-d figure. For example:

3D shapes

In our day to day life, we see several objects like books, ball, ice-cream cone etc, around us which have different shapes. One thing common to most of these objects is that they all have some length, breadth and height or depth. Therefore they all occupy space and have three dimensions.

Examples of 3D shapes and figures

We can say that the figures which we draw on paper and have length, breadth and height are called 3-d figures. Hence a 3D shape has three dimensions. The D in 3D stands for dimensional.