Question

Write the step to format textual data entered in a cell for 4 mark

Answer 1

Answer:

Select an empty cell. On the Home tab, in the Number group, click the arrow next to the Number Format box, and then click Text. Type the numbers that you want in the formatted cell. Numbers that you entered before you applied the Text format to the cells must be entered again in the formatted cells.

Answer 2

Answer:

You have several options when you want to enter data manually in Excel. You can enter data in one cell, in several cells at the same time, or on more than one worksheet at once. The data that you enter can be numbers, text, dates, or times. You can format the data in a variety of ways. And, there are several settings that you can adjust to make data entry easier for you.

This topic does not explain how to use a data form to enter data in worksheet. For more information about working with data forms, see Add, edit, find, and delete rows by using a data form.

Important: If you can't enter or edit data in a worksheet, it might have been protected by you or someone else to prevent data from being changed accidentally. On a protected worksheet, you can select cells to view the data, but you won't be able to type information in cells that are locked. In most cases, you should not remove the protection from a worksheet unless you have permission to do so from the person who created it. To unprotect a worksheet, click Unprotect Sheet in the Changes group on the Review tab. If a password was set when the worksheet protection was applied, you must first type that password to unprotect the worksheet.

Explanation:

Hᴏᴘᴇ ɪᴛ's ʜᴇʟᴘ ᴜ ᴍᴀᴛᴇ