L-11 (Question/answers)

Class 6                                                     Lesson 11         

Q1. Define QB64 language.

Ans. QBasic is an IDE, developed by Microsoft to type, edit, debug and execute BASIC programs. QBasic uses English like words and Mathematical symbols to write programs. 

Q2. Write the different ways to run a QB64 program.

Ans. The two ways to run a program in QB64 are as follows:

1.By pressing F5 key

2. By selecting Run menu and clicking on the start option.

Q3. Define variables. Name the types of variable.

Ans. A variable is a location in the memory, which has been assigned a name, and it used to store data temporarily. It  holds the value until another value is assigned to it.

There are two types of variables:

1 .Numeric variables: It can hold only numeric value.

Example: A, C, A2, ABC, A_6 .

2. Alphanumeric or string variables: It is represented by an alphabet followed by dollar ($) sign.It contain letters ,digits ,underscore but last character is always a $ .  Example : A1$ , RK1$.

Q4. Differentiate between Numeric and Alphanumeric constant?

Ans.               Numeric constant                                       Alphanumeric constant

1. Any numerical value, either positive            1. A set of characters is called a String.

Or negative is called a Numeric constant.

2. For example: 224, +12, -45                         2. For examples: “RAGHAV”

3. These are used for calculations.                3. It is used to represent non                                                                                            numeric quantities. such as name ,                                                                                      addresses.

Q5. Define the term Hierarchy of operations. Write the hierarchical order of the arithmetic operator in QB64?

Ans. Hierarchy defines the order in which the operators are executed in any QBASIC expressions.  The hierarchy of QBASIC is:-

B	Brackets	( )
E	Exponentiation	^
D	Division	/
M	Multiplication	*
A	Addition	+
S	Subtraction	-

CH-6

Chapter 6

Microsoft Excel 2010

Q1. What do you understand by Microsoft Excel?

Ans. Microsoft Excel is spreadsheet software. It is used to perform mathematical calculations. It consists of rows and columns.

Q2. Differentiate between a Workbook and a Worksheet.

Ans. A workbook is a file that contains one or more worksheets that you can use to organize various kinds of related information.

An Excel worksheet is a grid like area , made up of  and columns, where you can enter and work with data .By default, excel has 3 worksheets .

Q3. What is a cell? How many characters can a cell contain?

Ans. A cell is an intersection of rows and columns in a worksheet. A cell can contain up to 32,767 characters.

Q4. What is a Formula Bar? How is it different from the Name Box ?

Ans. The formula bar is located to the right of the name box .This bar shows the data and formulas that you enter in an active cell .Whereas the Name Box is above the Column heading on the left side of the window. It displays the location of the cell pointer.

Q5. How many types of data can be entered in an excel sheet? Explain each type briefly.

Ans. Three types of data can be entered in an excel sheet.

1.  Numbers: it consists numerals from 0 to 9 and characters like +,-,*, /, %, ^, & etc.

2.  Text: it contains alphabets, numbers, spaces and special characters. By default text data is left aligned.

3.  Formulae: It is a mathematical equation involving number values, operators and cell addresses used to perform calculations.

Q6. How can you rename a worksheet? Explain.

Ans 1. Double click on the sheet tab you want to rename.

       2. it will be highlighted

       3. Type a new name and press Enter key