‹header›
‹date/time›
Click to edit Master text styles
Second level
Third level
Fourth level
Fifth level
‹footer›
‹#›
 
This slide gives you the list of objectives.  It should be used to preview the lessons.
This slide continues the objectives.  The preview process ends with this slide.
These are the four major lessons taught in the chapter.  Each lesson will go more into depth into each topic.
These are the major objectives that the students should focus on in this lesson.  This will give you an understanding of ranges, copying and moving.
A cell range can be as small as a single cell or as large as an entire worksheet.  A cell range is basically the area that the excel command is acting upon.
This slide explains how a range of cells is labeled.  Since letters represent columns and numbers represent rows, a range indicated by a changing number and a unchanging letter is a range highlighting a column.  Similarly, if the letter is changing and the number is static, the range selected contains a row of cells.  A box range, an area containing a rectangle of highlighted cells, is labeled by the name of the cell in the upper-left corner followed by the name of the lower right cell.
This slide introduces the copy command and goes over the terminology Source Range and Destination Range.  The Source range is simply the range of cells the user wishes to copy to another location. The source range is in fact the source to be copied from.  Same goes with the destination range.  The destination range is the range of cells which the user wants to copy the source range onto.  Hence, the destination range is the destination of the cells being copied or acted upon. 
This slide gives the actual step-by-step cell copying process.  After selecting a range, the user has three options: (1) The user may go to the ‘edit’ pull-down menu and left click on copy. (2) The user could right-click on the source range and then left click on the copy option when it appears on the menu. (3) The user might also left click on the source range cell(s) and then press the ‘c’ button while holding down the control button.  All three of these processes will copy the source range. 
This slide focuses on copying cells.  Celestine and Coco are used to relate to the University of Rwanda students.  The upcoming slides will allow the student to practice the process of copying cells.
This is an actual Excel screenshot indicating how the user would use the copy command.  A cell range, the source range in this case, has been selected and labeled.  This is the material that the copy command will affect.  The edit pull-down menu method of copying is illustrated in this slide.  After the user pulls down the Edit pull-down menu (s)he may then left-click on the copy command. 
This slide reintroduces the Cell reference concept from chapter 1.  This slide then introduces the concept that cell references may be used in formulas.  Finally, a screenshot of a formula was added which depicts two cells references being acted together. 
This slide explains Absolute cell references.  An absolute cell reference is a cell reference used in a formula which does not change no matter where it is copied to.  An absolute cell reference is indicated by the use of a dollar sign before both the Column letter and row number.  The screen shot represents what happens if a cell which uses absolute references in its formulas is copied to a different location. The cell reference is unchanged even though the source range has been copied to F3.
This slide introduces and briefly explains what a relative cell reference is.  A relative cell reference is a reference found in a formula which changes automatically when copied to a different cell.  This automatic change is relative to its new location ( relative to its new row and column).  The screenshots demonstrate what happens when the relative cell reference containing formula in Cell D2 is copied to cell D3.  The cell reference found in the formula has changed from B2+C2 to B3+C3 automatically. 
This cell explains the concept of mixed cell references.  A mixed cell reference is half absolute and half relative.  It’s all dependent on whether the column letter or row number has a dollar sign in front of it.  An absolute row, a cell reference in which the row number does not change, has a dollar sign before the row number in the cell reference.  If an absolute row reference is copied the column will change depending on the column it is moved to, but the row will remain constant.  The absolute column is the reverse of the absolute row.  The dollar sign comes before the column letter.  If an absolute column reference is copied, the row number will change relative to the row it is copied into but the column will remain constant. 
This screen shot demonstrates what happens when a cell containing a formula using an absolute column reference is copied to a different location. The cell references found in the formula in cell D4 have different row numbers even though the column letters remain the same.  The dollar signs before the Column letters mean that the column references must remain constant or absolute. 
These screenshots demonstrate what happens when a formula containing absolute row references is copied.  The references found in cell E2 contain the same row numbers as the references in cell D2, but the Column letters are different. Dollar signs before the row numbers cause the row references to remain constant after being copied. 
This slide explains the basic concept behind the move command.  It states that the move command transfers the contents of the source range to the destination range.  It also states that this operation is implemented using the cut and paste commands.  Finally, it’s important to note that the movement operation doesn’t just move the numbers found but also the formulas.  If these formulas contain relative cell references, then they will be subject to change. 
The upcoming slides focus on how to move cells on a spreadsheet.  The names Celestine and Coco are again used to keep an ongoing theme.  The upcoming slides will allow students to practice the move operation.
This slide gives the first three steps in the Move operation.  Highlight what you want to move, and then click on the edit pull-down menu on the file bar.   Scroll down to the cut command and left click on it. 
The next three step are shown in this slide.  Click on the top left cell of your destination range. Next, click on the edit pull-down menu on the file menu.  Finally, left click on the Paste command. 
This question reinforces the importance of the copy command.  Any time students want to duplicate information, they can use the copy command.
This question reinforces the importance of the copy command.  Any time students want to duplicate information, they can use the copy command.
This slide is used to review the lesson.  It focuses on cell ranges, cell references, the copy command, and hyperlinks.
Briefly go over the four sections of this lesson.  All four will be shown step by step.
This slide walks you through the steps to change width.  Width is used to fit more words or letters into a cell.  You may use simple examples by typing in words or names and then following the steps to make the cells wider or narrower.
Changing the width of a column is used when the material in a cell is too wide for the given cell length.  The cell width can be changed manually, by dragging the borders between the column headings, or exactly, by double clicking the right boundary of the column heading you wish to change.  Changing the width manually lets you make the cell however narrow or wide you want it to be.  Changing the width exactly changes the length to exactly accommodate the column’s longest entry.
This slide is used to adjust the height of cells.  The row can be increased or decreased by following the directions on the slide.  You simply click on Format, Row, Height, and then change the number.  A common use of this function is to put more than one line of information in a cell.
This slide allows you to practice the column adjustment function.  The actual process for column adjustment will be discussed in later slides.  This slide gives you background for the future problem on upcoming slides. It also mentions Jean-Philippe and allows students to identify with a person they are familiar with.
This is a simple practice example.  It walks you through each step.  The point of the practice is to show that his name doesn’t fit. 
8.43 is the automatic number that comes up in the column width.  This number was not just chosen.  12 was picked by trying different numbers until a perfect size fit the name.  You can practice different numbers to show how it works.
Formatting a row is used to make rows taller or shorter.  This slide reinforces the importance of understanding the functions of a row. 
This slide shows that when a row is adjusted, the width is changed.
There are 12 numeric formats.  This is just an example of a few of them.  By following the directions in the next few slides, you can view all 12 formats. 
This slide walks you through the process for adjusting number formats.  You click on Format, then Cells, and a box with more formatting of cells will appear.
This slide shows the format cells box.  It allows you to view all 12 formats available.  Right now, the general category is highlighted.  To the right of it, you can see a description of the general category.  Also note how the student can access this box to easily format the numbers in the cells.
This is an example of one category: date.  The red boxes show the type and description that refers to each category.  Click on some other categories to show the different descriptions.
Formatting numbers is useful because the simple numbers can be entered into the cells, and then changed to the desired format, such as currency or percentage.  The shortcut menu allows quicker access to the formatting box.  The next slide will show you the process needed to format the cells. 
In required instances, you must specify how many decimal places are desired.  Also, you must state which symbol (if any) you would like to appear on the worksheet.  In this instance, 2 is in the decimal place box.  This means that the number can have a maximum of two decimal places in the cell. 
The shortcut menu allows students to access certain features with one click of the mouse.  This is more convenient and faster than using the pull down menus.  
Right clicking on the mouse allows you access to the shortcut menu.  The right click of the mouse generally pulls up shortcut menus applicable to each program.  The left click allows you to select certain features that are already shown on the screen.
Alignment is used to change text within a cell.  Normally the alignment is to the left.  This means that the text starts at the left side of the cell.  Other alignments on the toolbar include center and right.  A justify alignment is also available, but must be accessed using a pull down menu.  Justify alignment allows text to fill both the right and left margins equally.  A newspaper would be an example of justified text. 
This shows you which arrow to click to change the style of font.  Click on the arrow once and a drop down menu will appear.  You can then click on different fonts and type to see their style.  For Excel, the font is generally set on Arial. 
This slide shows you how to get more in depth with the font features.  This allows you to change the style, size, color, whether you want to underline it, and a few other features.  To change any feature, click on it or the arrow to the right of it.  Then, when you are done click OK.
This slide shows how to center text using the pull down menu.  Centering text is used to make the worksheet look more uniform.  This box is accessed by clicking on Format, Cells, and the Alignment tab.  You must then click on the down arrow underneath the horizontal selections.
Centering text centers the text in each separate cell.  Using the toolbar is quicker and easier than using the pull down menu.  The alignments to the left and right allow the student to shift the text to one side or the other side of a cell. 
This slide shows the students the difference between adjacent and nonadjacent cells.  Adjacent cells are next to each other (that touch) and nonadjacent cells do not directly touch.
This function is useful when you want to format many different, nonadjacent ranges at once.  This process is unique because a key on the keyboard is held down throughout the entire process.  This allows you to highlight ranges that can be in all different areas of the spreadsheet. 
Nonadjacent ranges can only be done by holding down the CTRL key on the keyboard. You must first highlight the first cell or cells you want.  Then to move across the spreadsheet to highlight other cells, hold down the CTRL key while clicking the cells.
This slide is used to review the lesson focused on adjustments of column width and height, numeric formats, alignments and fonts.
This slide refers to the alignment of text.  It is important to understand the three different alignments that can be used off of the toolbar.  The buttons can be found to the right of the B, I, U buttons on the toolbar.  They include the left, center, and right alignments. 
The middle picture represents the center alignment.  The picture represents the function, because all the lines are in the center of the box.  This is true for the left and right alignments also. 
This function is useful when you want to format many different, nonadjacent ranges at once.  This process is unique because a key on the keyboard is held down throughout the entire process. 
Clicking and holding the Ctrl key allows you to highlight ranges that can be in all different areas of the spreadsheet.  This function saves time and effort when many different areas all need to be formatted the same way.
This slide previews the different features of borders, patterns, and shading.  These three functions allow you to change the area around the text.  These features include colors, shapes, and styles. 
Adding borders to certain areas of your worksheet allows important areas to be highlighted and stand out.  This process allows certain text to be differentiated from other text.  This slide shows the box that is utilized to change the borders for the text. 
The patterns tab gives you options to change the color for shading in an entire box.  Color, Sample and Pattern have been highlighted in red to show that they are of importance.  These three categories control the shading process.  After changing any feature, you click OK to use it. 
This slide is used to preview the process of adding color to text.  Claude and Josephine have been used to relate to the students at the University of Rwanda.  The next slide will go more in depth in how to choose your color.
When color is added to the cells on a spreadsheet, the text in these cells stand out from all the other texts.  When you want to highlight a certain point or emphasize its importance within the data, adding color is a viable solution. 
The margins on a spreadsheet can be centered in one of two ways.  These options include horizontally or vertically.  When printing a spreadsheet, you must print the gridlines.  This process is achieved by checking the box “print gridlines”. 
This slide shows how to use the page setup box.  The red box highlights the gridline option.  If this box is not checked, the gridlines will not print.  When this box is checked, and the OK button is clicked, the lines will appear on the paper when the spreadsheet is printed out. 
Outlining text is an essential part of highlighting important ideas.  Outlining allows certain texts to stand out without any words being communicated.  Outlining includes lines, styles and colors. 
The border tab is used to outline text.  As discussed in earlier slides, it allows text in a cell to be focused on by the viewer.  This feature is adjusted by click on Format and Cells.  Then, the Border tab is selected to view all of the options. 
This slide is used to review the lessons focused on borders, cell shading, and patterns.
This slide previews Lesson 4 involving the internet and hyperlinks.  In this lesson you will learn definitions about the internet, how to use hyperlinks in a spreadsheet, and how to save a spreadsheet as a web page.
The internet is a tool used to connect computers around the world.  It is a network that has international capabilities.  The World Wide Web is an information source that allows people to share information and exchange ideas globally.
Hyperlinks are an essential part of Excel.  They allow spreadsheets to be connected to the internet by means of a network.  By storing web pages on your computer, they can be easily referenced by means of a hyperlink when working with the data and text.
This slide provides a preview of an exercise used to better understand the addition of a hyperlink.  Coco is used to identify with the students of the University of Rwanda.  The upcoming slides will show you how to add a hyperlink onto a spreadsheet. 
This slide walks you step-by-step though the process of adding the hyperlink on the spreadsheet.  First, you use the mouse to click on the cell you would like to insert the hyperlink in.  Then, you click on Insert and Hyperlink.  The next slide will show you how to complete this process.
After completing the steps on the previous slide, a box appears on the screen.  In the box labeled “type the file or web page name” insert the name of the hyperlink.  When the hyperlink is completely inserted, click the OK button to complete the process.
Editing hyperlinks allows you to change a hyperlink that has already been inserted into a cell in a spreadsheet.  By right clicking on the hyperlink, the shortcut menu appears.  The shortcut menu is used to access the hyperlink quicker and easier than using the toolbar. 
For the final steps of the process to edit a hyperlink, a box appears.  It is the same box that was used to initially create the hyperlink.  This time, however, the hyperlink is changed and a new name is inserted.  The OK button is clicked to complete the process.
Sometimes you may want to publish your spreadsheets to the internet.  In order to do this, you must save the file as a web page.  This process is started by using the File pull down menu, and clicking on “Save as Web Page”. 
The process from the previous slide is finished on this slide.  A box appears, which asks you to select a folder, name the file, and pick a location to save the file.  The location to save the file has already been chosen for you, and is entitled “web page”.
The web toolbar is used to display documents.  These documents are usually received from the internet or a drive of the computer.  The toolbar has many similarities to the icons and buttons used for Internet Explorer.  
The address bar is important when using the internet.  It shows the exact location that is being accessed on the network.  The buttons highlighted in red function identically to the ones in Internet Explorer. 
This slide refers to the connection of one computer to another.  It shows the connections of computers in a network.
The internet is the answer.  The internet is the connection between networks.
This slide is used to review the lessons focused on the internet, the world wide web, and hyperlinks.
Thank you for using our Excel Chapter 2 Powerpoint tutorial.  For more information on Excel Chapter 2, please refer to our web page.  Good luck!
Work Cited:
Barber, Maryann, and Robert T. Grauer. Microsoft Office 2000 Professional. Upper
Saddle River: Prentice-Hall, 2000.