Excel1 - CS105 Lab 6 Introduction to Excel Announcements:...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
CS 105 – Spring 2008 1 CS105 Lab 6 – Introduction to Excel Announcements: Quiz 3 is available and due on Tuesday, February  26 MP3 will be posted on Saturday, February 23 Feedback forms for your midterm 1 will be given  next week in the labs. 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CS 105 – Spring 2008 2 Objectives Learn about copying and pasting in Excel Learn how to use functions in Excel Understand differences between absolute and  relative cell reference Learn to use the fill handle Learn the difference between copy, fill, and  move
Background image of page 2
CS 105 – Spring 2008 3 Download the File Open a web-browser.  Go to the course  website:   http://www.cs.uiuc.edu/class/cs105 Click on “Lab Discussion Slides”  Right-click on  Excel Worksheet   for Lab 6 .   C hoose “Save Link As” or “Save Target As”  and save it on your desktop.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CS 105 – Spring 2008 4 A Spreadsheet column letters Row numbers A3:A8 Single Column Range B9:E9 Single Row Range Read as “B3 to E6” B3:E6 Range
Background image of page 4
CS 105 – Spring 2008 5 Entering Formulas Enter a formula in cell E7 to calculate the total points  the student has earned Start your formula with  = There are several ways to write this formula     One way is: =B7 + C7 + D7    Another way is: = sum(B7:D7)
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CS 105 – Spring 2008 6 Copying Formulas Copy the formula in cell E7 to the cell just  below it (use Ctrl-C to copy and Ctrl-V to  paste) What happens?  Why? You can check formula in E8 in two ways:
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 20

Excel1 - CS105 Lab 6 Introduction to Excel Announcements:...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online