Excel+-+assignments


 * Excel Spreadsheet Assignments **

Complete the following assignments in Microsoft EXCEL.

Create a new worksheet in your EXCEL file, last name_Excel (always save in your u: drive and then ** WHEN FINISHED ** WITH ALL **THREE assignments,** SAVE TO the public drive, LVMS, student, Computer, 7th Grade Folder)

__ Key Terms __ Cell – is the spaces of the spreadsheet Rows- the horizontal line of cells Column- vertical line of cells Cell names are the column and then the row. For example, the first cell name is **A1.** So when I refer to cells this is how I will refer to them.

** Assignment 1: Using FORMULAS **

You should see “=C3” in the box at the top of the screen. 5. Go in and type a $ before both the C and the 3, so that it looks like **//=$C$3//**. The Dollar signs mean that you want to keep that part of the formula the same if you copy it. If you don’t have the $ then a respective relationship will occur. For example if we had copied the formula down without the dollar sign then in cell A5 it would have the formula =C4. If I copied it right then in B4 the formula would change to =D3.
 * Create a Times Table. **
 * 1) In Cell C1 type the words //Multiplication Table//.
 * 2) In Cell A3 type the word //Number//.
 * 3) In Cell C3 type the number 10.
 * 4) In Cell A4 type = then click on Cell C3. You just made a formula.

** Note: __Every formula will always start with an equals sign__. Examples: =a2+a3 (adds what is in cell a2 and a3) **


 * 1) In Cell B4 type a * (multiplication sign, by the number keys or shift 8 gets you *)
 * 2) In Cell C4 through C13 type the numbers 1 through 10
 * 3) Select the Cells A4 through B13, in that order, by clicking and dragging the mouse. With the cells highlighted go to //Ribbon (about 7 sections over) and find the editing box// and click on the fill icon (down arrow). Roll the mouse over the word F//ill// and the over the word //Down// and Click on it. The cells below the top two cells should have exactly the same thing. I will refer to this as the **//Fill Down// method.[[image:lvcomputers/excel.JPG width="783" height="203"]]**

r ** Assignment 2: Adding a worksheet (BONUS) **
 * 1) Click in Cell D4. Type = click on Cell A4 then type * and click on cell C4. Press Enter. Thus the formula should look like this: **=A4*C4.** Note: //You can put a cell name in the formula by clicking on it or typing it.//
 * 2) Do the Fill Down ,(see picture above) and copy this into the cells D5 to D13
 * 3) Now change the number in the cell C3 to another number like 8. Hit enter. The numbers in the Columns A, C, and D should have changed. You just created a MULTIPLICATION TABLE. Congrats if it works, if not figure out what step you missed from above.

At the bottom of the page click on the tab that says //Sheet 2//. This creates a new sheet to work in. You can have several sheets in a workbook. This will come in handy for businesses. Note: If you don’t have a worksheet at the bottom, you can go up to //Insert// and click on //Worksheet//. It will add one as well.


 * 1) You are going to create a sheet that converts Fahrenheit into Celsius and vise versa. The formula for Celsius is C = 5/9*(F – 32). The Formula for Fahrenheit is F = (9/5)*C + 32.
 * 2) In Cell A1, type "Convert F to C"
 * 3) In Cell B1, type “Fahrenheit”.
 * 4) In Cell B2, type a number for a degree. 32 degrees is a good test.
 * 5) In Cell C1, type the word “Celsius”.
 * 6) In Cell C2, type the formula for Celsius but use CELL names not variables, =5/9(F - 32). Remember to start with an = sign. Remember also, that there should be **cell names** in the formula not **variables.** What CELL should you put in for F? Hint, not F.
 * 7) Test the calculation on a calculator. If you used 32 degrees it should be 0 for Celsius. Change 32 to different temperatures to see if the conversion works.
 * 8) In Cell A3, type "Celsius into Fahrenheit"
 * 9) In Cell B3, type "Celsius"
 * 10) In Cell C3, type "Fahrenheit"
 * 11) In Cell B4, type 10
 * 12) == In Cell C4, type the formula to convert from C to F, = (9/5)*C + 32. ==
 * 13) Format the cells to have only two decimal places by the following. Highlight the cells the numbers. **Right mouse click and select Format Cells**.

You should see a pop up box.


 * 1) Click on **Number** and make sure a “2” is in the box for “Decimal places:”


 * 1) Hit OK.