Page 55 - Code & Click - 6

7 More on Excel

Pre-Processing
Pre-Processing
• Entering Data in Cells • Editing Cell Contents
• Undo and Redo Commands • Copying and Moving Cell Contents
• Inserting Cells, Rows, or Columns • Deleting Cells, Rows, or Columns
• Changing Row Height and Column Width • Font Formatting
• Cell Formatting • Working with Long Text
• Number Formatting • Date and Time Formatting

Excel is one of the most popular spreadsheet software.
Let us learn to enter data in cells, edit the cell contents, insert or delete
cells, rows, and columns, and adjust the row height and column width.

ENTERING DATA IN CELLS
Excel allows you to enter three types of data in a worksheet:

Numbers are values that consists of digits from 0 to 9 on which mathematical
Numbers
calculations can be performed. Excel aligns numbers to the right border of a cell.
Text is a combination of alphabet, numbers or symbols on which mathematical
Text
calculations cannot be performed. Excel aligns the text data to the left border of a cell.
A formula is an equation that performs calculations on data in a worksheet. A formula
Formula
always starts with the ‘ = ’ symbol.

To enter data in a cell: 2
1. Select the cell in which you want to enter data.
2. Type the required data in the cell directly.
OR 1
Click the Formula bar and type the required data.
3. Press the Enter key.
The data appears in the cell.

Entering Date and Time in a Cell
• You can enter a date in a cell by typing the date, month, and
year, with each number separated by a forward slash (/). To
enter the current date in a cell, press the ‘ Ctrl + ; ’ keys together.
• You can enter time in a cell by typing the hour and the
minutes, separated by a colon (:). If you want to enter time
in 12-hour format, enter the time followed by a space, and
then type AM or PM. To enter the current time in a cell, press
‘ Ctrl + Shift + ; ’ keys together.
By default, date and time data is right aligned in a cell.

53