COLEGIO DE SAN SEBASTIAN

College Department
Sablayan, Occidental Mindoro

FINAL MODULE IN
COMPUTER 101

WORD
PROCESSING
AND EXCEL

Prepared by:
MS. JESSICA SAMARITA
Instructor
Creating a New Worksheet
Objectives:
 Create a new worksheet, enter and change data in a cell
 Use different keys in moving around the worksheet
 Demonstrate how to save, close, exit and open a previously saved worksheet
 Discover how to convert worksheet from prior versions
 Utilize the functions of Office Help
Creating a New Worksheet
A new worksheet is launched every time you open Microsoft Excel. You can immediately start
typing your data inside the cell. You can always create a new worksheet with the following
steps:
1. On the File menu, click New or
2. On the Quick Access Toolbar, click the New button.
Cells, Column and Rows
A cell is an area where a column and a row intersect. Each cell has a name which corresponds
to its column heading and row heading which is called a Cell Reference. The selected cell is the
active cell.
Column is the vertical space that goes down the window. Excel has 16,384 columns. Each
column has a column heading A, B, C, and so on. You can add, delete and resize the columns.
Row is the horizontal space that goes across the window. Excel has 1,048,576 rows. Each row
has a row heading 1, 2, 3, and so on. You can add, delete, and resize the rows.
Entering and Changing Data in a Cell
You may enter your data by selecting a cell. You can select a cell by clicking your mouse pointer
on the cell. Type your data on the selected cell and move to the next cell to type another data.
You can move to another cell by pressing the arrow keys on your keyboard or just clicking the
mouse.
If you want to replace the data you have previously typed, go back to the cell by clicking your
mouse pointer on the cell you want to change.
There are two ways to change the data:
1. Once you are in the cell you want to change, double click the cell and when the blinking
cursor appears, press backspace or delete and type your new data and press and enter
key.
2. Once you are in the cell you want to change, click your mouse on the formula bar, press
backspace or delete and type your new data and press the enter key.
Saving the Worksheet
Microsoft Excel provides many ways to save a file. It is important to know how each function
individually. New, edited, and opened file may be saved for future use or for a succeeding
action such as printing and modifying.
There are many ways to save a worksheet.
1. Click the File menu and on the menu click the Save or Save as command.
2. On the Save As window, select Computer, click Browse and the Save dialog box will
appear.
3. Click the drop-down arrow in the Save in box to select where you want to save your
worksheet.
4. On the File name box, type your file name and click Save.
5. Or, on the Quick Access Toolbar, click the Save button.
To save a file in your computer:
1. Click the drop-down arrow in the Save in box.
2. Select Removable Disk, type your File name, select Save as type and click Save.
Closing the Worksheet
Closing a worksheet removes it from the screen. If the worksheet is not yet saved, MS Excel will
ask if you want to save your modified worksheet, then MS Excel closes.
1. Click the File menu and click the Close command.
2. You can also click the close button on the upper right corner of the screen. The screen
will return to the Windows desktop.
Opening a Previously Saved Worksheet
1. On the Quick Access toolbar, click Open.
2. You can also click the File menu and then select Open.
3. Select from the Recent Workbooks and select from the recent files or select Computer
and click Browse.
4. When the Open dialog box appears, click the Look in drop-down arrow to display the list
of available drives and locate the drive containing your file or click Documents.
5. Choose the File name where your document was saved, then click Open.
Working with Texts
Objectives
 Identify the Font Group commands
 Modify the text by changing its font, style, size, and color
 Discover how to resize, AutoFit, insert, delete, hide, or unhide columns and rows
 Show how to sort data and complete the Fill Series
 Create a custom list and drop-down list box in a cell
 Distinguish the use of AutoFill and Auto Complete
 Modify a worksheet by inserting, deleting, renaming, and coloring sheet tabs
 Add symbols and equations
Font Group Commands
The commands in the Font Group allow you to set and change the font type, font style, font
color, fill color, and border of the fonts.
Selecting Cells, Columns or Rows
By selecting cells, rows, or columns, you can easily modify the data format your worksheet.
Select a cell by clicking your mouse on the cell. To select the range of cells, point your mouse to
highlight the group of cells.
To select columns or rows, point your mouse on the column header or row header and the
mouse will change to an arrow. Click and drag to the column or columns that you would like to
select.
Adding Lines and Borders
You can place lines and borders on any cell in your worksheet.
1. Select the cell or group of cells that you would like to add a line or border
2. On the Font group, click the Border arrow and select from the list of borders options.
Resizing the Column and Row
If the text you are typing does not fit the cell, you may resize the column and row.
1. To resize the row, point your mouse on the line between the row names and when the
double-headed arrow appears, move your mouse up or down to resize.
2. To resize the columns, point your mouse on the line between the column names and
when the double-headed arrow appears, move your mouse left or right to resize.
3. You can also resize a group of columns or rows simultaneously by selecting the columns
or rows and drag the double-headed arrow.
4. You can also use the Format command to resize. Click the Home Tab go to the Cells
group and click Format button and select the Row Height or Column Width.
5. On the Row Height or Column Width dialog box, type the measurement of your desired
height and width.
6. You can also point your mouse on the column and row header, when a double arrow
appears, drag it to resize.
AutoFit Columns or Rows
AutoFit allows you to easily arrange all columns and rows at once. MS Excel automatically fits
the cell on the exact length and size of the text.
 1. Select the cells you want to apply AutoFit.
2. Click the Home tab, go to the Cells group and click the Format button.
3. On the drop-down menu, click the AutoFit Row Height or AutoFit Column Width.
4. Another way is to point your mouse on the line between the column and row name.
5. When the double-sided arrow appears, double click it and the column or row will
automatically adjust.
Setting Width for All Columns
The default column width of Excel is 8.43 characters. However, you can set the default width to
your preferred size.
1. Click the Home tab.
2. On the dialog box, type the width size that you prefer and click Ok.
Inserting a Row or Column into a Worksheet
You can add or insert rows and columns in your worksheet.
1. Place the mouse pointer on cell where you want to insert a row or column.
2. Right click the mouse and on the Context Menu, click Insert.
3. On the Insert dialog box, click Entire Row or Entire Column.
4. Or, click the Insert button on the Cells group and select the options on the Insert dialog
box.
Deleting a Row or Column in a Worksheet
You can delete rows or columns in your worksheet.
1. Place the mouse pointer on the cell where you want to delete a row or column.
2. Right click the mouse and on the Context Menu, click Delete.
3. On the Delete dialog box, click Entire Row of Entire Column.
4. Or, click the delete button on the Cells group and select from the list of commands.
5. To clear cell contents, click Clear Contents from the Context Menu or click Clear button
from the Editing group.
Sorting Data
You can sort list of data alphabetically by columns and by ascending or descending order. There
are many ways to sort data.
1. Select the range of cells that you want to sort.
2. Click the Home tab, go to the Editing group and click Sort and Filter drop-down arrow
and select from the menu the Sort options that you prefer.
3. You can also click the Sort buttons from the Quick Access toolbar.
4. Or, right click the mouse to show the Context menu and select the Sort command and
choose from the options on the sub-menu.
5. You can also click the Data tab, go to the Sort and Filter group and click the Sort button
to launch the Sort dialog box.
6. Click the Options tab and select your setting from the Sort Options dialog box.
Using the Fill Series
You can fill cell with a series of values that fit a predictable pattern such as a series of
number (1,2,3,4,5….) or dates (July1, July 2, July 3…) There are many ways you can fill series
in MS Excel.
 1. Go to the cell and type the first two data of your series (for example, Sept1, Sept2( and
highlight the two cells.
2. Point your mouse on the lower right corner of the second cell until you see the Fill
Handle +. Drag your mouse until you have reached the end of the series you want.
3. You can also click the Home tab, go to the Editing group and click the Fill button.
4. Select Series from the drop-down menu and on the Series dialog box, select the options
available.
Creating a Custom List
Excel allows you to easily fill data into the cells from the list you have defined in the Custom
List.
1. Click the File menu and click Options.
2. On the Options dialog box, click Advanced.
3. On the General section, click Edit Custom List button.
4. In the Custom List dialog box, click New list and type your new list in the list Entries box.
5. When typing the list, separate each item with a comma, without spaces
6. Click OK
Copying Data and Formulas with AutoFill
Data that repeats on many columns or rows can be filled in with AutoFill. Formulas in cells can
also be copied and repeated down and across cells easily using the AutoFill.
1. Type the data or formula that you want to copy.
2. Point your mouse at the edge of the cell and when you see the Fill Handle +, drag your
mouse down the line to Autofill the cells with the copied data or formula.
3. You can also copy a formula using the Copy and Paste commands from the Clipboard on
the Home tab.
Using Auto Complete
Excel keeps a list of what you have already entered in a column. When you enter the same data
in another cell, Excel will automatically complete the typing and you will just press the Enter
Key.
Hiding and Displaying Rows and Columns
You may hide rows and columns if you do not need them for the meantime, you do not want to
display some information, or when a worksheet is too long.
1. Select the range of rows and columns you want to hide.
2. Click the Home tab, go to the Cells group and click the Format button.
3. Select the Hide & Unhide command and choose from the options in the pop-up menu.
4. Or, you can right click the mouse on the row or column header and on the Context
Menu, click Hide or Unhide.
Inserting Worksheets
There are row ways to insert a worksheet. One is from the Home tab and the other one is from
the sheet tab located at the bottom of the worksheet.
1. Right click the Sheet tab.
2. On the pop-up menu click Insert.
3. On the Insert dialog box, click Worksheet and a new worksheet will be inserted.
 4. You can also insert worksheet from the Home tab, go to the Cells group, click Insert
button and on the drop-down menu click Insert Sheet.
5. You can rearrange or interchange the arrangement of the worksheets by clicking and
dragging the sheet tab to the new location.
Deleting Worksheets
There are many ways to delete worksheets.
1. Right click the Sheet Tab.
2. On the pop-up menu click Delete.
3. On the Delete dialog box, click Delete.
4. You can also click the Home tab, go to the Cells group and click the Delete button.
5. On the drop-down menu select Delete Sheet.
Renaming the Worksheet Tab
MS Excel automatically names worksheets as Sheet1, Sheet2, Sheet3, and so on. You can
replace it with a more appropriate name.
1. Right click the mouse on the sheet tab.
2. On the pop-up menu, click Rename.
3. Type the new name in the sheet tab.
4. Click the pointer to any blank space in the worksheet to deselect the command.
Inserting Symbols and Equations
Symbols are special characters. You can place symbols, Wingdings, and special characters in
your worksheet.
1. To insert a symbol, go to the cell where you want the symbol to be placed.
2. Click the Insert tab, go to the Symbol group and click the Symbol button.
3. Choose the Equation or Symbol and click Insert.
4. If you choose Equation, you can select from the list of common equations or create your
own using the tools from the Equation Tools Design tab.
5. Go to the Structures group and click any tools to create an equation of the type you
want, and fill in the details of the structure by adding text normally.
6. You can also add symbols from the gallery in the Symbols group.
COMPUTER 101
FINAL PERIOD

Name: ___________________________________ Course: _____________ Score:__________

________ 1. Font A. I

________ 2. Size B. U

________ 3. Fill Color C. A

________ 4. Font Color D. Calibri

________ 5. Increase Font Size E.

________ 6. Decrease Font Size F. 11

________ 7. Bold G.

________ 8. Italic H. B

________ 9. Underline I.
________ 10. Border J.

3. What are the ways to create a fill series and how is it done?
________________________________________________________________________
________________________________________________________________________
________________________________________________________________________
________________________________________________________________________
________________________________________________________________________
________________________________________________________________________
_____________________________ .
4. What is a customer list and how do you create one?
________________________________________________________________________
________________________________________________________________________
________________________________________________________________________
________________________________________________________________________
________________________________________________________________________
____________________________ .