1

Introduction to Spreadsheet

1. Write down the features of Microsoft Excel.

The Features of Excel are: -
i. Formulas can be used for performing simple and complex mathematical
calculations.
ii. Functions (in-built formula)can also be used for calculating percentage,
interest average etc.
iii. Formatting features to improve the appearance of data.
iv. Data can be searched quickly required, replaced instantly.
v. Quick data entry can be done in a large series of cells by using the
autofill feature.
vi. Data can be represented graphical form such as charts, which helps to
understand,analyse and compare data in an effective manner.

2. Differentiate between a worksheet and a workbook.

i. A worksheet is a grid like area, of rows and columns, where you can enter
and work with data where as workbook is a collection of worksheets.
ii. A workbook can contain worksheets according to the limit of memory
available on a computer whereas a worksheet consists of 1048576 rows
16384 columns.

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

a cell is a interconnection of a column and row in a worksheet. Each cell is
identified by its cell address. A cell can contain upto 32767 characters.

4. What is a formula bar? How is it different from the name box?

the formula bar is located right of the name box. This bar shows the data
and formula that we enter in an active cell.
Where as name box is located just above the column heading on the left
side of the window. Displays the location of the cell pointer.
 2

5. What is the use of Name Box?

The Name Box is used to display the address (cell reference) of the active
cell.
6. What information is displayed on the Formula Bar?
The Formula Bar displays the data or formula present in the active cell.
7. What are the different types of data that can be entered in an Excel
worksheet?
The types of data that can be entered in an Excel 2013 worksheet are
numbers, text and formulas.
8. How will you refer to a range of cells from A1 to G5?
We will write A1:G5 to refer to the range of cells from A1 to G5.
9. What is an active workbook?
An active workbook is one that accepts entries and commands.
10. What is an active cell?
An active cell is the cell that receives the data and responds to the
command entered.
11. What are the two ways of entering data in Excel 2013?
Following are the two ways of entering data in Excel 2013:
a. By overwriting the previous data, thus changing the content completely.
b. By modifying the previous data only partially.
12. What is the use of the Undo command?
The Undo command is used to reverse the last action performed on the
worksheet.
 3

13. What is the use of the Redo or Repeat command?

The Redo or Repeat command is used to reverse the undo action.
14. What is a cell pointer?
A cell pointer is the highlighted cell boundary specifying the active cell at
that moment.
15. What is the default extension of an Excel 2013 workbook?
The default extension of an Excel 2013 workbook is .xlsx.

Fill in the blanks:-

1. Spreadsheet is application software that makes a computer work as a data

analyzer.
2. Excel 2013 is a spreadsheet program that helps users in doing calculations
and in analyzing data using formulas and tables.
3. The first spreadsheet program was Visicalc, which was released in 1979.
4. Excel 2013 is a part of the Microsoft Office 2013 package.
5. Quick Access Toolbar is meant to give users quick access to commands
that are used frequently.
6. The Title Bar displays the name of the workbook.
7. The ribbon contains commands required to perform various tasks in an
Excel workbook.
8. The small arrow at the bottom-right corner of some groups in the ribbon is
called a dialog box launcher.
9. The scroll bars appear only if you have data more than the screen can
display at a time.
 4

10. The two scroll bars are vertical bar and horizontal bar.
11. The status bar is present at the bottom of the window.
12. By default, a worksheet opens in Normal view.
13. The Page Layout View divides a worksheet into printable pages.
14. The Page Break View gives you an overview of a worksheet with
page breaks.
15. The Zoom Control lets you increase or decrease the zoom level.
16. By default, Excel 2013 shows only one worksheet, named Sheet1.
17. You can click the plus sign to add more worksheets.
18. An Excel 2013 worksheet has 16,384 columns.
19. An Excel 2013 worksheet has 1048576 rows.
20. To name a worksheet, double-click its tab.
21. A cell is formed at the intersection of a row and a column.
22. A range of cells is referenced using colon (:) between two cell
addresses.
23. The × button is called the Cancel button which is used to cancel the
data entry.
24. The button is called the Enter button.
25. The fx button is the Insert Function button.
26. To move to the cell that is to the right of the active cell, press
the Tab key.
27. To overwrite cell contents, just select the cell and type the new
content.
28. The shortcut key for partial modification of cell contents is F2.
 5

29. The shortcut key to undo an action is Ctrl + Z or Alt + Backspace.

30. If an action cannot be repeated, the repeat command changes
to Can’t Repeat.
31. Formula icon is available is cells group.
32. Excel files are called workbook.
33. All values entered in a cell are displayed in the formula bar.
34. All formulas start with = sign.
35. Pressing enter key selects the next cell in the same column.
36. We can enter three types of data in worksheet.
37. Pressing the F12 key opens the Save As dialog box.
38. Merge & Center button places the contents in the center of the cells
across a number of column/rows.

State whether True or False:-

1. The title bar is located at the bottom of the Excel window. (FALSE)
(At the top)
2. You can enter only numbers in an Excel cell. (FALSE)
(Numbers, Text, Formula)
3. To move to the cell below the active cell, press the Enter key. (TRUE)
4. A workbook can contain a maximum of 255 worksheets. (TRUE)
5. The last column is labelled XED. (FALSE)
(XFD)
6. Date and time are part of a single data type in Excel. (TRUE)
7. Symbols enterd in text data type are treated as text.(TRUE)
 6

Choose the correct option:

1. By default, which of the following buttons are available on the

Quick Access toolbar?
a. Save
b. Undo
c. Redo
d. All of these
2. A worksheet in Excel 2013 has ________ rows.
a. 1048576
b. 16384
c. 567
d. None of these
3. ________ are labelled using letters of the alphabet.
a. Rows
b. Columns
c. Cell
d. None of these
4. A worksheet in Excel 2013 by default shows ________
worksheet(s).
a. One
b. Two
c. Three
d. Four
5. Excel files are called ________.
a. Worksheets
b. Workbooks
c. Sheets
d. None of these
6. Which of these is not an Excel tab?
a. Home
b. Design
c. Review
d. View
7. Which of these displays cell address?
a. Status bar
 7

b. Formula bar
c. Address bar
d. Name box
8. Which of these data type has no specific format?
a. General
b. Number
c. Date
d. Text
9. Which of these symbols is used to calculate quotient?
a. ;
b. :
c. /
d. *
10. Which of these is the default name of Excel file?
a. File1
b. Sheet1
c. Book1
d. None of these