WORD-PROJECT 1



EXCEL CHAPTER 2Lab Instructions—pgs. 145-155NOTE: Make sure all spreadsheets fit to one page.Apply Your Knowledge pg. 145-146Retrieve the data file from the I:/Shared driveFollow Steps 1-4 as given in text; proofread and edit your documentAdd the class information to the spreadsheet using the following (First/Last Name, Excel 2-AYK-Part 1, Hour, Current Date) each in a separate row (A19-A22).Step 5: Do NOT do document properties; do NOT put information in a header; save into your Excel 2 folder using the filename Excel 2-AYK-Part 1; preview and print the spreadsheet in color in landscape orientationDo Step 6 as instructedStep 7: Do Control+` to show entire formulas version; print entire worksheet instead of the range; print in Black & White, fit to one page, landscape orientation; remember to return settings to original state before saving againPart 2 Instructions: Complete Step 1 as instructedPart 2 Step 2: Change the class information to say Excel 2-AYK-Part 2; save the workbook in your Excel 2 folder using the filename Excel 2-AYK-Part 2; preview and print the worksheet in color, landscape orientationStaple the assignment in the following order: Part 1, Part 2, Part 1 formulas version Extend Your Knowledge pg. 147Retrieve the data file from the I:/Shared driveStep 1: Set conditional format range to top 25%; change format to bold, white font; with orange fill (5th one over on first row)Step 2: Set conditional format to below average; change format to bold, red font with yellow fillStep 3: Set conditional format to Ds & Fs; change format to light red fill with dark red textStep 4: Set conditional format to duplicate showing light red fillProofread and edit your documentAdd the class information to the spreadsheet using the following (First/Last Name, Excel 2-EYK, Hour, Current Date) each in a separate row (A24-A27)Do NOT do document properties; do NOT do headerSave into your Excel Project 2 folder using the filename Excel 2-EYKPreview and print the spreadsheet in color in portrait orientationMake It Right pg. 148-149Retrieve the data file from the I:/Shared driveDo Steps 1-7 as instructed in the text; except adjust Column B to 11.50 instead of 11.25; adjust Columns E & H to 10.00 width and Column C to 8.25 width; adjust D4:D17 to comma style so decimals align properlyDo NOT do document properties; do NOT add a headerAdd the class information to the spreadsheet using the following (First/Last Name, Excel 2-MIR, Hour, Current Date) each in a separate row (A20-A23).Save into your Excel 2 folder using the filename Excel 2-MIRPreview and print the spreadsheet in color in landscape orientation; print formulas version B/W in landscape orientation fit to one page;Staple the assignment in the following order: values version then formulas versionLab Exercise 1-Parts 1-3 pgs. 149-151Part 1: Follow Steps 1-14 as given in text (Note: there is a book error in Step 9—there is no B1 so apply to A2)Change Step 15 to the following: Rename the sheet tab as Sales Analysis. Do NOT do document properties; do NOT do a header. Key class information (First/Last Name, Excel 2-Lab 1-Part 1, Hour, Current Date) each in a separate row (A20-A23)Change Step 16 to the following: Save into your Excel Project 2 folder using the filename Excel 2-Lab 1-Part 1; preview and print the entire worksheet in color in landscape orientation; DO NOT print just the rangeDo Step 17 as instructed but print in B/W; reset the worksheet page setup back to its original statePart 2: Follow instructions as given in text except save it as Excel 2-Lab 1-Part 2Change the footer information in cell A21 to Excel 2-Lab 1-Part 2Proofread and edit your document; do NOT do headerPreview and print the spreadsheet in landscape orientation in colorPart 3: Follow instructions as given in text except save it as Excel 2-Lab 1-Part 3Change the footer information in cell A21 to Excel 2-Lab 1-Part 3Proofread and edit your document; do NOT do headerPreview and print the spreadsheet in landscape orientation in colorStaple and submit in this order: Part 1 values version, Part 1 formulas version (in B/W), Part 2 values version, Part 3 values version Lab Exercise 2-Part 1 & 2 pgs. 151-154Part 1 Instructions: Do Part 1-Steps 1-9 as instructed in text except change the width of Column A to 22.00 charactersStep 10: Change the worksheet name as instructed; add class information (First/Last Name, Excel 2-Lab 2-Part 1, Hour, Current Date) each in a separate row (A20:A23); do NOT do document properties; do NOT create a headerStep 11: Spell check as instructed; Save into your Excel Project 2 folder using the filename Excel 2-Lab 2-Part 1; preview and print the spreadsheet in landscape orientation in colorStep 12: Do NOT print the range; preview and print the formulas version landscaped, fit-to-one page in Black and White; close without saving (make sure you have done prior save so you don’t lose document)Part 2 Instructions: Open Lab 2-Part 1; change cell A21 to say Excel 2-Lab 2-Part 2 and save as Lab 2-Part 2 in your Excel 2 folderCreate chart as instructed in Steps 1-5; preview and create a custom footer in the Page Setup dialog box Header/Footer tab with the following information: First/Last Name, Excel 2-Lab 2-Part 2, Hour, Current Date each on a different line (enter); you will then need to size the chart by pulling up the bottom so that all of the footer information shows in the print preview; print the ONLY THE CHART in landscape orientation in colorStaple together in this order: Part 1 values version, Part 2 chart sheet; Part 1 formulas version; submit Do Step 6 as instructedChange Step 7 to select and preview the worksheet and chart but DO NOT PRINT the worksheets; save the changes as Excel 2-Part 2b in your Excel 2 folderPart 3 Instructions: DO NOT DO Part 3Lab Exercise 3-Part 1 & 2 pgs. 154-155Part 1 Instructions: Follow the instructions for Part 1 as given in text for creating the web queryKey the class information (First/Last Name, Excel 2-Lab 3-Part 1, Hour, Current Date) each in a separate row (A25-A28)Save Part 1 into your Excel 2 folder using the filename Excel 2-Lab 3-Part 1; do NOT do document properties; do NOT create a headerPreview and print the spreadsheet fit to one page in landscape orientation in colorClick on the links as instructed but DO NOT PRINT any web pages; preview them and close without savingPart 2 Instructions: Follow the instructions for Part 2 as given in text for creating the web queryKey the class information (First/Last Name, Excel 2-Lab 3-Part 2, Hour, Current Date) each in a separate row (A35-A38)Save Part 2 into your Excel 2 folder using the filename Excel 2-Lab 3-Part 2; do NOT do document properties; do NOT adjust the headerPreview and print the spreadsheet fit to one page in landscape orientation in colorStaple parts 1 & 2 together in order; submit ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download