Page 68 - Code & Click - 6

D. Answer the following questions.
1. Write the steps to display text in a cell in multiple lines within a cell.
2. What is number formatting? Name the various format options available in the Number
Format list.
3. How does the AutoComplete fea ture in Excel 2016 work?

4. Write the steps to move contents of a cell from one location to another in a worksheet.

Mind Stretching

1. Manish has created an Excel worksheet about a list of expenses he incurred on his birthday
party. He wants to add the Rupee symbol to the numeric values along with the two decimal
places. Help him do so. Computational Skills
2. Vishakha has created an Excel worksheet as shown in the image. Name the various formatting
features she has used to prepare it. Logical Thinking

Lab Work

A. Create a weekly planner for planning and recording your day-to-day activities in Excel. Creative Skills

B. Prepare a list of ten common diseases, their causes, symptoms, and methods of prevention in an
Excel worksheet. Format the data as shown in the given worksheet. Inter-Disciplinary

66