Page 103 - Computer - 5

B. Fill in the blanks using the Data Box.

Data Box 1048576 cell worksheet Formula bar spreadsheet

1. A page in an Excel workbook is called a ____________.

2. The number of rows in a worksheet in Excel 2019 is ____________.

3. Excel 2019 is an example of ____________ software.
4. The ____________ can be used to enter data or formula in a cell.

5. A ____________ is the intersection of a row and a column in a worksheet.

C. Write ‘T’ for True and ‘F’ for False statement.
1. The Ctrl key must be kept pressed while selecting multiple cell ranges. _______

2. The result of some calculations is displayed on the Status bar. _______

3. Text data includes only alphabets. _______
4. The contents of an active cell are displayed in the Formula bar. _______

5. Rows are the horizontal arrangement of cells in a worksheet. _______

D. Answer the following questions.
1. What is a spreadsheet? Name two spreadsheet software.

________________________________________________________________
2. Write four features of Excel 2019.

________________________________________________________________
3. What is the difference between a workbook and a worksheet?

________________________________________________________________
4. Write the two ways in which a cell range is selected in Excel 2019.

________________________________________________________________
5. Write the steps to rename a worksheet.

________________________________________________________________
6. Describe the purpose of the following components of the Excel window:

(a) Name box (b) Formula bar (c) Worksheet tab
________________________________________________________________

Mind Stretching

1. Mohit has entered the details of his friends in different cells in a worksheet. He

wants to select the cells containing names and phone numbers of his friends.
Suggest a way to help him select the required data. Logical Thinking

101