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