WORD-PROJECT 1



EXCEL-CHAPTER 3--Lab Instructions pgs. 229-244NOTE: Make sure all spreadsheets fit to one page.Apply Your Knowledge pg. 229Parts 1 & 2: Complete the handout provided; submit the handout when finished with itPart 3: Retrieve 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 3-AYK-Part 3, Hour, Current Date) each in a separate row (A15-A18).Step 5: Do NOT do document properties; do NOT put information in a header; save into your Excel 3 folder using the filename Excel 3-AYK-Part 3; preview and print the spreadsheet in color in landscape orientationDo Control+` to show entire formulas version; adjust column widths so it shows complete formulas; print entire worksheet in Black & White, fit to one page, landscape orientation; remember to return settings to original state before saving againStaple the assignment in the following order: Part 3 values version then Part 3 formulas version; submitExtend Your Knowledge pg. 230-231Part 1: Open Excel 3-EYK-Part 1 Data File from the I:DriveEnter the nested IF statement provided in Step 1 on page 230 in the textbook in Cell C3 (you must adjust the cell reference to use B3 each time instead of B1); using the fill handle, copy the formula down to cell C18; then delete the formula from cells C10 and C11Add the class information to the spreadsheet using the following (First/Last Name, Excel 3-EYK-Part 1, Hour, Current Date) each in a separate row (A22-A25).Save into your Excel 3 folder using the filename Excel 3-EYK-Part 1Preview and print the spreadsheet in color in landscape orientationPart 2: Retrieve the data file Extend 3-1 Create Series from the I:DriveIn Step 1 DO NOT select D2 and D3 and then fill (select only D2 then fill); for Column G, select both G2 and G3 then fill; follow the rest of the instructions as givenDo Steps 2-5 as instructed; apply best-fit column width to Column BProofread and edit your documentAdd the class information to the spreadsheet using the following (First/Last Name, Excel 3-EYK-Part 2, Hour, Current Date) each in a separate row (A27-A30)Do NOT do document properties; do NOT do headerSave into your Excel 3 folder using the filename Excel 3-EYK-Part 2Preview and print the spreadsheet in color in landscape orientation; staple parts 1 & 2 together; submitMake It Right pg. 232-233Retrieve the data file from the I:/Shared driveDo Steps 1-3 as instructed in the text; DO NOT DO Step 4; your spreadsheet will NOT look like it does in the bookDo NOT do document properties; do NOT add a headerAdd the class information to the spreadsheet using the following (First/Last Name, Excel 3-MIR, Hour, Current Date) each in a separate row (A20-A23).Save into your Excel 3 folder using the filename Excel 3-MIRPreview and print the spreadsheet in color in landscape orientation; print formulas version B/W in landscape orientation fit to one pageStaple the assignment in the following order: values version then formulas versionLab Exercise 1-Part 1 pgs. 233-237Follow Steps 1-10 as given in textDo 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 (A30-A33)Save into your Excel 3 folder using the filename Excel 3-Lab 1-Part 1; preview and print the entire worksheet in color in landscape orientationDo Step 12 as instructed; reset the worksheet page setup back to its original state; do NOT close workbookDo Part 2 before submitting worksheetsLab Exercise 1-Part 2 pg. 235-236Create chart as instructed in Steps 1-5; increase title font size to 28 pt.; green; cylinders are orange; background is green; chart sheet tab is green; financial sheet tab is orangePreview and create a custom footer in the Page Setup dialog box Header/Footer tab with the following information: First/Last Name, Excel 3-Lab 1-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 previewPrint 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 Lab Exercise 1-Part 3 pg. 237Follow instructions as given in text except do not save or print anything.Lab Exercise 2-Part 1 & 2 & 3 pgs. 237-241Part 1 Instructions: Change Step 1: Retrieve the file from the I:Drive only save it as Excel 3-Lab 2-Part 1 in your Excel 3 folder insteadDo Steps 2-15 as instructed.Do Step 16 as instructed. Apply light blue fill to A1:B3.Do Steps 17-23 as instructed. Make sure you do SUM functions for Social Sec. and Medicare as indicated in the picture of the spreadsheet (no instructions are given to do this).Change Step 24 to add class information (First/Last Name, Excel 3-Lab 2-Part 1, Hour, Current Date) each in a separate row (A20:A23); do NOT do document properties; do NOT create a header; SAVE your worksheet againStep 25 as instructed.Preview and print the spreadsheet in landscape orientation in color fit to one pagePreview 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)Staple in this order and submit: values version then formulas version.Part 2 Instructions: Open Lab 2-Part 1; change cell A21 to say Excel 3-Lab 2-Part 2 and save as Excel 3-Lab 2-Part 2 in your Excel 2 folderFollow the instructions as given. Save Part 2 after the last change but do NOT print any worksheetsPart 3 Instructions:Follow the instructions as given. Do not save or print any worksheets. Answer the questions but do not submit them.Lab Exercise 3-Part 1 & 2 pgs. 241-244Part 1 Instructions: Do Step 1 as directedChange Step 2: Change Column A width to 35.00 points (instead of 28.00)Do Steps 3-12 as instructed in the textChange Steps 13-14: Do NOT do document properties; do NOT do a headerKey the class information (First/Last Name, Excel 3-Lab 3-Part 1, Hour, Current Date) each in a separate row (A28-A31); Save Part 1 into your Excel 3 folder using the filename Excel 3-Lab 3-Part 1Preview and print the spreadsheet fit to one page in landscape orientation in colorPress Control + ` to show the formulas version; preview and print it in Black & White; fit to one page, landscaped. Return to original settings after printing (make sure you have done prior save so you don’t lose document). Do Step 15 as instructed.Part 2 Instructions: Create a 3-D Pie Chart as instructed. Do the following format: Centered Overlay Chart Title, green, Britannic Bold, Size 32, bold, underlined. Change data labels to %, Arial, bold, size 10, match the font color and pie slice color (administrative=green; marketing=light blue; maintenance=dark red; insurance=light green; energy=purple; depreciation=red); explode the administrative pie pieceAdd custom footer: in left section key your first/last name; in the center section key Excel 3-Lab 3-Part 2; in the right section key your hour (DO NOT PUT A DATE) Save Part 2 into your Excel 3 folder using the filename Excel 3-Lab 3-Part 2Preview and print the chart in landscape orientation in colorStaple parts 1 & 2 together in this order: values version, chart, formulas version; submitPart 3 Instructions: Do Part 3 Steps 1 & 2 as instructed. Do not save or print anything. ................
................

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

Google Online Preview   Download