MS EXCEL 2019

Q & A

Q1. 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.

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

Q3. Define Cell.
Ans. The intersection of row and column is called a cell. Each cell is referred by address called as cell address. For example, B12, A3, G5, etc.

Q4. What is an active cell?
Ans.Any cell which is selected is an active cell.

Q5. Define Charts.
Ans. It is a pictorial representation of data. You can created different types of graphs easily from the data in the spreadsheets.

MSWLOGO

Q&A

Q1. Define the following:

1. Logo
2. MSWlogo
3. Command Input Box
4. Execute button
5. Main Screen
6. Turtle

Ans.

1. LOGO: Logo is a simple computer language that can be used for drawing figures and designs, typing text and performing arithmetic calculation.

2. MSWlogo: It is a version of Logo used in Microsoft Windows.

3. Command Input Box:  It is the box where the commands are typed.

4. Execute Button: It makes Logo carry out the command.

5. Main Screen: It is blank screen in the middle of the window.

6. Turtle: It is the small triangle seen in the middle of the main screen.

Q2. Write down MSWlogo Commands list.

Ans. 

Q3. Practice the given Exercises in MSWlogo.

MS WORD INTERFACE

MS WORD INTERFACE

QUESTIONS AND ANSWERS

Q1. Define Microsoft Word.
Ans. Microsoft Word or Word is a program where you can type and write essays, letters and other documents.

Q2. Define the following terms:
Ans.

1. Cut : It is the option that removes the selected text.

2. Copy: It is the option that creates a duplicate of the selected text.

3. Paste: It is the option that places the Cut/Copy text at the required location.

4. Replace: It changes the selected text with a new text.

5. Find: It is the option that searches word document for specified words.

6. Redo: It is the option that repeats the last action performed.

7. Undo: It is the option that reverses the last action performed.

8. Change case: It is the option that changes the case of the written text.

9. Font Name: It refers to the design/style of characters.

10. Font Size: It refers to the size of characters.

11. Font Style: It is the way in which character is emphasized upon.

12. Formatting Text: It is the process of applying font style, colors, etc. to the text.

13. Italic Text: It is slanted and is mostly used for emphasis.

14. Superscript: It reduces the size of the text and raises it to the top of the existing line.

15. Subscript: It reduces the size of the text and lowers it to the bottom of the existing line.

Q3. Write down the shortcut keys with description.
Ans.

DATA AND DATABASE

DATA AND DATABASES

QUESTIONS AND ANSWERS

Q1. What is Data?
Ans.Data is a collection of facts, figures, and symbols.

Q2. What is Database? Give example
Ans. A collection of data on a computer is called a database. A database is a system for organizing data. It is a collection of raw data that can be changed, sorted, and quickly searched to show detailed information about something more particular.

EXAMPLE:
A very simple example of a database is an electronic address book which can include information about thousands of people.

Q3. What is field?
Ans. Every characteristic, or piece of information, is called a field. A field has a name and some data.

Q4. What is Branching database?
Ans. A branching database (sometimes called a binary tree) is a way of classifying a group of objects. If it has been designed properly, someone else could use the tree to identify one of the objects.