Feb 13

1)  Try:  Exercise 9 page 214 and Exercise 11 page 216.  

These exercises demonstrate the use of mathematical formulas (Note:   If you are not sure how to perform a mathematical calculation read the Microsoft Excel help file   (Hint:  use = for simple calculations, =sum to sum a range of cells), data formatting (numeric formats) and alignments.  Answer the following questions in your notebook:

a)  What is the command to specify a mathematical formula?  What is the spreadsheet function to find the sum of a range of cells?

The command to specify a mathematical formula is to go to the formula tab and pick what formula you would like to insert. You could also insert the = sign in the box and start typing the name of your formula and it will appear.  You can pick many formulas from the financial, logical, text, date and time and math and trig tabs. The spreadsheet function to find the sum of a range of cells is to type =, the cell location (A1) and than + for each cell that you would like to add. A quicker way to perform this function is to use the SUM formula by accessing the formula tab or by typing =SUM in the cell box, than type in or click what boxes you would like to add ie.  A1: A6.

b)  How do you copy a formula from one cell to another so that the cell addresses update relative to copied position?

To copy a formula from one cell to another so that the cell addresses updates relative to copied position, simply click on the box and drag down the highlighted box. By doing this the formula from the original box is copied and is no added to the cells that you dragged the box down to.

c)  How do you change the numeric format for a value to currency ($000.00) format?  How do you change numeric format to percent format?

You can change the numeric format for a value to currency by selecting General in the Number tab. Select the $ sign to change the value to currency. You can change the numeric format to a percent format using the same technique but buy selecting the % sign.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s