|
Excel Tutorial
6— Sessions 6.1,
6.2, & 6.3
NM.xlsx,
Colorado.xlsx,
Sales 2010.docx,
TravelTotals.xlsx,
and Utah.xlsx.
(40 points) |
Read and
complete
pages EX 281 – EX 325.
NOTES:
Page 293, Step 1 (at bottom of page)—Include the
Documentation sheet in this grouping and use the general
Page Setup instructions for all sheets (as noted above).
Page 312, after Step 5—Print the YI Totals 2010.xlsx
workbook
Page 316—After step 6, type your name as the manager in G7
and apply the general Page Setup instructions. If you
re-size the columns to being a bit narrower, you should be
able to print
centered horizontally on one portrait page.
Page 319, Step 4—Enter “Washington” instead of “New Mexico”
and “Fiscal Year – [current year].”
Page 320, Step 9—Save the file as Washington [current year].
Page 324, Step 5—Print the Web page viewed in a browser.
After answering the Quick Check questions on pages EX 295,
EX 310, and EX 325, check your answers at the end of the
chapter and review the Key Terms on page EX 325 to make sure
you have a clear understanding of the concepts covered.
|
p. 294, Step 8______
(Summary
sheet: as part of workbook + formulas view)
p. 312, Step 5b_____
(Workbook)
p. 316 ___________
(Time
Card)
p. 324, Step 5______
(Web page
in browser)
|
|
Tutorial 6:
Case Problem 1
Cafe.xlsx
(20 points) |
Complete the Apply Case Problem 1 Assignment on pages
EX 327 - EX 328. When you are done, save the file as
directed and print the
YI Java Cafe workbook after step 6.
NOTES: Step 6—Disregard these instructions and follow the normal
Page Setup instructions, as described above. |
Step 6_________
(Summary sheet) |
|
Tutorial 6:
Case Problem 2
Carson.xlsx,
Reno.xlsx,
Vegas.xlsx
(16 points) |
Complete the Create Case Problem 2 Assignment on pages
EX 328 - EX 329. When you are done, save the file as
directed and print the formulas view of
YI UTE Vegas Summary
sheet, the UTE_Web_Page (viewed in a browser), and the
Summary sheet of the YI Carson City 2011.
|
Formulas________
(Summary
sheet)
Step 11________
(Web Page
in browser)
Step 13________
(Summary sheet) |
|
Tutorial 6:
Case Problem 3
InBurger.xlsx
(24 points) |
Complete the Create Case Problem 3 on pages
EX 329 - EX 331. When you are done, save the file as
directed and print the Documentation, Annual Recap, Summary,
and May sheets of the
YI InBurger 2010 workbook.
|
Step 12 ________
(4 sheets/pages) |
|
EXTRA CREDIT
Europe.xlsx,
North America.xlsx,
South America.xlsx
(up to 10 points) |
Complete the Challenge Case Problem 4 on pages
EX 331 - EX 333, steps 1-10 only. When you are
done, save the files and workspace as directed. Show your
workspace and the four files associated with it in Exploring
(or My Computer); use PrintScreen and copy a “picture”
showing these files into the Documentation sheet of
the YI Pluto Summary workbook. Print the YI Pluto
Summary workbook and submit. |
Step 10__________
(Pluto Summary workbook) |
of
| Your Name.
