annettefisher

 

Excel Help and Homework Questions

Page history last edited by Annette Fisher 9 mos ago

How to's in Excel:

Surving the switch to Excel 2007 - Great Information

See comments on an Excel Page

Add and Format Data Labels on a Chart

Creating a Graph Demo

Change the name on a graph

How to use Print Screen

Use Absolute References in a Formula

Copy a sheet in a workbook

Save workbook as 2003 version - don't use for work submitted in this class

 

 

 

This is where we can post help and questions regarding homework issues. 

 

 Chapter     Problem                              Solution

1    
2

Lab 2

Lab 3 

How to change the font color on conditional formatting.

Picture of what the tabs should look like. 

3    
Web Feature How do I use print screen. See this link
4

Lab 3- why doesn't my goal seek work.

 

 

Case 3 -  why do I have a negative Future Value

 Sometimes when you have run the goal seek a few times, it starts to get confused.  Copy your original sheet to a new sheet in your workbook and try again. Use the right click on the page tab to make the copy.

 

The payment should be a negative number in the formula, you can solve it by either putting a minus before your reference to the payment or at the beginning of the formula.

5    
6    
Graphics Lab 1 - the lines don't show up I wish I could explain this one, it happens on some computers and not others.  You can either leave them out or improvise and try putting them in another way.  I won't deduct for it.
7    
8    
9    

 

Comments (0)

You don't have permission to comment on this page.