Lab15.3 Finalizing a Worksheet

1. In this project you use absolute references

 2. Sign in your account at the http://www.jupitergrades.com/ and
      click the link "Project15.3 Gothic Gargoyle Collection"

 

 

HW15.1 Key Terms for Finalizing a Worksheet

Please do this homework on your blog, after finish your work; email me your blog’s link.

Explain each vocabulary. You can insert appropriate image (Optional)

·                bar chart 

·                gridlines 

·                landscape orientation 

·                line chart 

·                pie chart 

·                portrait orientation

Lab14.5 Absolute References

1. In this project you use absolute references

 2. Sign in your account at the http://www.jupitergrades.com/ and
      click the link "Project14.5 Commission Worksheet"

 3. Open the file "Project14.5 Commission Worksheet"

Lab14.3 Formating a worksheet

 1. In this project you will formate a worksheet

 2. Sign in your account at the http://www.jupitergrades.com/ and
      click the link "Project14.2 Income and Expense Summary"

 3. Open the file "Project14.2 Income and Expense Summary"

     25. Save your document

E-mail the file,
    To: Type your class’ email address.
    Subject: Type Lab14.2 Formatting a Worksheet
    Attached your file
    Click the Send button

Homework14.1 Key Terms for MS Excel

Please do this homework on your blog, after finish your work; email me your blog’s link.

Explain each vocabulary. You can insert appropriate image (Optional)

·                active cell 

·                argument 

·                cell reference 

·                circular reference 

·                drag-and-fill 

·                formula 

·                formula bar 

·                functions 

·                label 

·                marquee 

·                range 

·                value 

·                workbook 

·                worksheet 

·                worksheet cell

Lab13.4 Using Function

 Lab13.4 Using Function

 1. In this project you will use the SmartArt graphic options to customize a document

 2. Sign in your account at the http://www.jupitergrades.com/ and
      click the link “Project13.4 Aero Groupo.docx” 

 3. Open the file “Project13.4 Aero Groupo.docx”

Homework13.1 Entering and Editing Data in Excel

Homework13.1

1.Entering and Editing Data in Excel

Perform the following steps to create a new spreadsheet and enter data.

 1. Open Microsoft Excel.

 2. Open a new, blank workbook. Save it as Kids_Bookstore in the same folder as your Chapter 6 data files.

 3. Begin entering the column headings. In cell A1, enter the word “Inventory”.

 4. In cell A2, enter the words “Qty on Hand”.

 5. In cell A3, enter the words “Unit Price”.

 6. In cell A4, enter the words “Total Value”.

 7. Enter the data below beginning in cell B2. Do not worry about formatting the data at this time. No data will be entered in the Retail Price or Total Value columns.

Inventory	Qty on Hand	Wholesale Price	Retail Price	Total Value
Princess and the Pauper	20	6.5
Alice in Wonderland	27	5.35
Swiss Family Robinson	10	8.89
Old Yeller	32	6.99
Pocahontas	22	5.99
Cinderella	17	8.93
Beauty and the Beast	29	7.95
Sleeping Beauty	32	5.5
Pinocchio	12	4.96

8. Insert a row between Swiss Family Robinson and Old Yeller. Enter the following data in the appropriate column of the new row.

The Wizard of Oz, 15, 8.65

9.    Rename the worksheet tab to Book Inventory.

10.   Autofit each column

11. Save the changes to your workbook.

12.   Print the worksheet

13. Keep the workbook open for the next exercise.

2. Formatting a Worksheet and Summing Numbers

Perform the following steps to give the worksheet a more professional appearance.

 1. Open Microsoft Excel if necessary.

 2. Open Kids_Boostore if necessary.

 3. Add the word “Total” to cell A11.

 4. Use the AutoSum feature to sum the Qty on Hand column.

 5. Make all column headings that consist of more than one word appear on two lines in the same cell.

 6. Insert a new row above row 1.

 7. In cell A1, enter “Kids Korner Bookstore”.

 8. Merge cells A1 through D1.

 9. Format the numbers in the Wholesale Price column with a dollar sign and two decimal places.

10. Change the font of the title row to Arial, 18 pt.

11. Center the column headings in columns B, C, and D.

12. Center the data in column B.

13. Add a border to the outside edges of the data table (box border).

14. Add shading of your choice to the title row.

15. Bold cells A12 and B12.

16. Add a thick line to the bottom of rows A1, A2, and A11. Remember to select the range of cells in each row where the border needs to be placed.

17. Your worksheet should appear similar to the following example.

18. Save the changes to Kids_Bookstore.

19. Print the worksheet

20. Close Kids_Bookstore and close Microsoft Excel.

Kids Korner Bookstore
Inventory	Qty on Hand	Unit Price	Retail Price	Total Value
Princess and the Pauper	20	$6.50
Alice in Wonderland	27	$5.35
Swiss Family Robinson	10	$8.89
Wizard of Oz	15	$8.65
Old Yeller	32	$6.99
Pocahontas	22	$5.99
Cinderella	17	$8.93
Beauty and the Beast	29	$7.95
Sleeping Beauty	32	$5.50
Pinocchio	12	$4.96
Total	216