Excel 2007 Assignment Sheet, Tutorial 1—Getting Started with Excel

General Excel Notes— Follow formatting rules on the General Excel Notes Website: Setup all worksheets to be centered horizontally and to fit on 1 page when printed; other formatting will be demonstrated in class.

 

Printable Sheet

 

Activity

Additional Instructions

Submit

Excel Tutorial 1, Sessions 1.1 & 1.2

　

　

　

　

(30 points)

Read and complete pages EX 1 – EX 46.

NOTES: Page 21, Step 3—Type your initials at the beginning of all file names; example John Smith would type JS RipCity Digital Orders for the file name here.
Page 44, BEFORE Step 1, best fit the column widths.

After answering the Quick Check questions on pages EX 21 and EX　46, check your answers at the end of the chapter and review the Key Terms on page EX 47 to make sure you have a clear understanding of the concepts covered. Be prepared to discuss any of these questions or terms in class and to answer questions related to them on the quiz.

　

 

　

　

　

p. 45, Step 7 _______
                          (formulas)

Tutorial 1 :
Case Problem 1

Altac.xlsx


(15 points)

Complete the Case Problem 1 Apply on pages EX　49　- EX　50. When you are done, save the file as directed, and attach the printed YI Altac Bicycles.xlsx　workbook to this assignment.

NOTES: Step 15—Do not print the worksheet on two pages; if you best fit the columns, it should fit easily on one landscaped page.



 

p. 50, Step 18 _______
                        (workbook)

Tutorial 1 :
Case Problem 2

Halley.xlsx


(15 points)

Complete the Case Problem 2 Apply on pages EX　51　- EX　52. When you are done, save the file as directed, and attach only the formulas print of the Balance Sheet worksheet of the YI Halley Foods.xlsx　workbook to this assignment.



p. 52,Step 15 _______
                          (formulas)

Tutorial 1 :
Case Problem 3

Global.xlsx

(20 points)

Complete the Case Problem 3 Challenge on pages EX　52　- EX　54. When you are done, save the file as directed, and attach the printed YI　Global Site.xlsx　workbook to this assignment.



p. 54, Step 16 _______
                        (workbook)

Tutorial 1:
Review Assignment


(20 points)

Complete the Review Assignment Practice on pages EX　48　- EX　49. When you are done, save the files as directed, and attach only the revised Customer Orders worksheet, YI Revised Report.xlsx,　to this assignment.




Step 22 _______
          (revised worksheet)

EXTRA CREDIT (up to 10 points)

Complete the Case Problem 4 Create on page EX　54. When you are done, save the files as directed, and attach only the data sheet (but printed as just page 2 of the workbook; this will be demonstrated in class) of the YI Green Lawns workbook.

　

Step 6 _____________
                        (worksheet)

 

Although you are not turning in all sheets of the above assignments, you are expected to
complete ALL steps (unless otherwise noted above) of each assignment.
Check the online Sample Keys to see a sample of what should be turned in, and
check the online full workbooks to check your work on those sheets that you are not turning in.