CHAPTER :- 05 ( INTRODUCTION TO MS EXCEL 2010)

1. The first electronic spreadsheet Visicalc was developed in 1978.

2. Write the steps to open MS Excel.
Ans:- Page no - 46.
3. Title Bar is located on the top of the window. (T/F) - T
4. Title Bar shows the name of the current workbook . (T/F) - T
5. File Tab button located at the left top corner of the window. (T/F) - T
6. File Tab contains the file menu commands such as New, Open, Save, etc.
(T/F) – T
7. Quick Access Toolbar is present on the title bar.(T/F) - T
8. Quick Access Toolbar displays quick access buttons of the Save, Undo and
Redo commands. (T/F) – T
9. What is Ribbon?
Ans:-Ribbon has tabs with group of related commands displayed on it.(T/F) - T
10. Define Formula Bar.
Ans:- It is used to enter and edit formulas and perform calculations on your
worksheet data. It is also used for entering and editing the all contents.
11. Formula Bar is used to enter and edit formulas and perform calculations on
your worksheet data. (T/F) – T
12. Formula Bar is also used for entering and editing the all contents.(T/F) - T
13. Name Box displayed the address of the active cell.
14. What is worksheet window?
Ans:- It is a single page in Excel also called spreadsheet.
15. Worksheet window also called spreadsheet. (T/F) - T
16. Status bar is a horizontal bar. (T/F) - T
17. Status bar at the bottom shows about the file in which you are working.
(T/F) – T
18. The right section of the status bar has view control buttons for the
spreadsheet. (T/F) – T
19. What is Row?
Ans:- The horizontal divisions on a worksheet are called rows There are 10, 48,
576 rows in an Excel worksheet.
20. The horizontal divisions on a worksheet are called rows. (T/F) - T
21. There are 10, 48, 576 rows in an Excel worksheet. (T/F) - T
22. What is Column?
Ans:- The vertical divisions on a worksheet are called columns. There are 16,
384 columns in an Excel worksheet.
23. The vertical divisions on a worksheet are called columns. (T/F) - T
24. There are 16, 384 columns in an Excel worksheet.
25. Work area is divided into rows and columns.
26. The rows are referred using numbers and columns using the alphabets.(T/F) - T
27. The row headings range from 1 to 10,48,576 and column headings range
from A to XFD.
28. The intersection of a row and a column is called a cell.
29. What is active cell.
Ans:- A cell is formed by the intersection of a row and a column. The currently
selected cell that appears highlighted with dark black border is an active cell.
The data is entered in an active cell.
30. The currently selected cell that appears highlighted with dark black border
is an active cell.(T/F) - T.
31. What is worksheet tab.
Ans:- There can be more than one worksheet in Excel and each has a specific
name. Any worksheet can be activated by clicking on worksheet tab.
32. Worksheet Tab Scrolling Buttons are arranged on the left side of the
horizontal scroll bar.
33. Define workbook.
Ans:- A workbook is a collection of different worksheets. By default, a workbook
contains 3 worksheets-Sheet 1, Sheet 2 and Sheet 3, that can be increased or
decreased as per the requirement.

34. By default, a workbook contains 3 worksheets. (T/F) - T

35. Workbook can be increased or decreased as per the requirement. (T/F) - T
36. The label is used to define the information on the spreadsheet. (T/F) - T
37. We do not do any mathematical calculations on labels. (T/F) - T
38. Labels are aligned on the left side of a cell. (T/F) - T
39. Values are numeric data on which mathematical calculations are performed.
(T/F) – T
40. This type of data includes characters 0-9 and special characters. (T/F) - T
41. The numbers and characters are always aligned on the right side of the cell.
(T/F) – T
42. Define Formula data type.
Ans:- A formula is a mathematical expression used to do simple and complex
calculations of the numeric data inserted in a cell or a range of cells.
43. A formula always begins with an equal (=) sign.
44. There are manly three data types in Excel that are label, number and
date/time.

CHAPTER- 01( NUMBER SYSTEM)

1. What is number system?
Ans:- A number system is simply a method of counting. There are four types of
number systems.
2. What is base or radix.
Ans:- The total number of digits used in a number system is called its base or
radix.
3. The computers use binary number system. (T/F) - T
4. Decimal number system consists of Ten digits from 0 to 9.
5. The base of decimal number system is 10.
6. What is expansion method.
Ans:- The value of a number is determined by multiplying the digits with the
weight of their position and adding the results. This method is known as
expansion method.
7. What is LSD, MSD?
Ans:- The right-most digit of the number has the lowest weight. This digit is
called Least Significant Digit (LSD).
The left-most digit of a number has the highest weight. This digit is
called Most Significant Digit (MSD).
8. Full form of LSD, MSD.
Ans:- LSD - Least Significant Digit
MSD - Most Significant Digit
9. The word binary comes from Bi- meaning two.
10. The binary numbers have the base of 2.
11. A single binary digit (like '0' or '1') is called a bit.
12. The two binary digits represent these two states.
13. Binary language is therefore known as the machine language.
14. The octal number system consists of eight digits from 0 to 7.
15. The base of octal number system is 8.
16. The hexadecimal number system consists of 16 digits from 0 to 9 and A to
The letters A to F.
17. The base of this number system is 16.
18. What are the rules to convert a decimal number into a binary number.
Give an example.
Ans:- Page no - 9,10
19. What are the rules to convert a binary number into a decimal number.
Give an example.
Ans:- Page no - 10
20. Write the rules to add two binary numbers.
Ans:- page no - 11
21. Write the rules to subtract two binary numbers.
Ans:- page no - 12
22. Write the rules to multiply two binary numbers.
Ans:- page no - 12