Page 72 - TP_Pluse_V2.2_Class_5
P. 72
Factopedia
6
7
The shortcut to
Repeat last action
is F4. 21 st
Let’s PraCtiCe Century #Technology Literacy
Skills
Open a new workbook and use Auto Fill feature to:
1. insert all the days of a week in column A.
2. insert 1 to 20 numbers in column B.
3. insert A to Z in column C.
Let’s BaCk-uP
The address of the
last cell in Excel is A range is a rectangular section of cells which are next
‘XFD1048576’. to each other and at least one side of their border is
common.
There are three different types of data that you can
enter in a spreadsheet, in Excel.
Type an apostrophe (‘) before a numeric value to make
it appear as text.
You can format the cells to display the date and time
format that you want.
The process of changing data either partially or
completely is known as editing.
Cell contents can be edited by replacing the cell
contents and using the formula bar.
You can easily copy and move the contents of a cell, a
An Excel cell can
contain upto 32,767 range of cells and an entire worksheet.
characters (letters, The Auto Fill feature in Excel is used to automatically fill
numbers or symbols. series of data in rows and columns based on the values
of other cells.
70 Plus (Ver. 2.2)-V

