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

3. Merge & Center button is in the __________ group of the __________ tab.
(a) Alignment, File (b) Home, Alignment
(c) Alignment, Home (d) Alignment, Insert
4. A formula should always begin with a/an ______________.
(a) number (b) cell address (c) range (d) equal to (=) sign

5. An Excel fi le is saved with an extension _______________.
(a) .xlsx (b) xlsx (c) .lsx (d) .exs

D. Name the following.
1. Default name of workbook ____________________

2. Number of rows in a worksheet ____________________
3. Numbers marked along the left border of the worksheet ____________________
4. Cell address on column B and row 45 ____________________

5. Range starting from B5 and ending at F5 ____________________

E. Answer the following questions.
1. Enlist the methods in which data can be entered in Excel.

2. Defi ne the components of Excel 2016.
3. Write the steps to enter data in a worksheet.
4. How can we switch between worksheets?
5. Write the steps to save a workbook and exit Excel.

Building Values and Life Skills

How will you help your friend who is unable to perform calculations in Excel?

Testing Knowledge

What will be the address of the last cell in an Excel worksheet?

Linking Knowledge

Mathematics: Enter the marks of your fi rst terminal examination in a worksheet in Excel and fi nd
their sum using the + operator.

Lab Fun

Create an MS Excel worksheet on ‘Vitamins’ and include details like sources, functions and defi ciency
diseases related to them. Save your worksheet.

58