Page 69 - Viva ICSE Computer Studies 7 : E-book

Quick Recall

• MS Excel is an application software. It is used to store and analyse numerical data.
• The default names of the worksheets in the workbook are Sheet 1, Sheet 2 and so on.
• Columns are labelled from left to right with letters as A, B, C, D and so on.
• Rows are numbered from top to bottom along the left edge of the worksheet as 1, 2, 3 and so
on.

• Three types of data that can be entered into MS Excel worksheets are Number data, Text data
and Formulae data.
• The Ribbon is the panel at the top portion of the document. It has seven tabs. They are Home,
Insert, Page Layout, Formulas, Data, Review and View. Each tab is divided into groups.
• We can enter data into cells.
• Formulae can be used for performing calculations on a worksheet.

A. Fill in the blanks.

1. Microsoft Excel 2016 organises data in the form of ______________ and ______________.
2. The Excel window that appears on the screen is called ______________.

3. Each cell is known by ______________.
4. Cell address is displayed in the small box called ______________.
5. A ______________ is specifi ed with the starting cell address followed by the ending cell
address, separated by a ______________.

B. State whether the following statements are true or false.

1. Performing calculations manually can consume a lot of time. __________
2. Active cell is surrounded by a thin border. __________

3. File tab contains many functions. __________
4. Ribbon has 4 tabs. __________

5. Status bar displays the information about the current selection. __________
C. Choose the correct answer.

1. There are __________ numbers of columns in a worksheet.
(a) 16,384 (b) 16,834 (c) 16,348 (d) 16,438

2. ____________________ moves the pointer to the fi rst cell.
(a) Shift + Home (b) Ctrl + Home
(c) Ctrl + Shift + Home (d) Ctrl + 1

57