Guide to Files in MOUS Essentials: Excel 2000

Guide to Files in MOUS Essentials: Excel 2000

At submission of student and solution files 2/15/00
P#-L# or
P#-ex type / Original Name of Student File / Student File Saved As / Related Solution File and Notes
P1-L1 thru L8 / none / revenues.xls / e1sol-proj.xls (end2, end5, end6)
P1-SD1 / none / states.xls / e1sol-sd.xls (sheet SD#1)
P1-SD2 / none / sales.xls / e1sol-sd.xls (sheet SD#2)
P1-SD3 / none / share.xls / e1sol-sd.xls (sheet SD#3)
P1-CH1 / none / rental.xls / e1sol-ch.xls (sheet CH#1)
P1-CH2 / none / raise.xls / e1sol-ch.xls (sheet CH#2)
P1-CH3 / none / print.xls / e1sol-ch.xls (sheet CH#3)
P2-L1 thru L8 / e-0201.xls / revenues.xls / e-0201sol-proj.xls
P2-SD / e-0202.xls / e2drill.xls / e-0202sol-sd.xls
P2-CH / e-0203.xls / e2challenge.xls / e-0203sol-ch.xls
P2-DZ / e-0204.xls / e2discovery.xls / e-0204sol-dz.xls
P3-L1 thru L8 / e-0301.xls / revenue3.xls / e-0301sol-proj.xls
P3-SD / e-0302.xls / e3drill.xls / e-0302sol-sd.xls
P3-CH / e-0303.xls / e3challenge.xls / e-0303sol-ch.xls
P3-DZ / e-0304.xls / e3discovery.xls / e-0304sol-dz.xls
P4-L1 thru L8 / e-0401.xls / frisbees.xls / e-0401sol-proj.xls
P4-SD / e-0402.xls / e4drill.xls / e-0402sol-sd.xls
P4-CH / e-0403.xls / e4challenge.xls / e-0403sol-ch.xls
P4-DZ / e-0404.xls / e4discovery.xls / e-0404sol-dz.xls
P5-L1 / e-0501.xls / functions1.xls / e-05sol-proj.xls (sheet end1)
P5-L2, L3, L4 / e-0502.xls / functions2.xls / e-05sol-proj.xls
(sheets end2-end4)
P5-L5 thru L8 / e-0503.xls / functions3.xls / e-05sol-proj.xls
(sheets end5-end8)
P5-SD / e-0504.xls / e5drill.xls / e-0504sol-sd.xls
P5-CH / e-0505.xls / e5challenge.xls / e-0505sol-ch.xls
P5-DZ / e-0506.xls / e5discovery.xls / e-0506sol-dz.xls
P6-L1 / e-0601.xls / sample charts.xls / no solution; view only
P6-L2 thru L8 / e-0602.xls / mycharts / e-0602sol-proj.xls
P6-SD / e-0603.xls / e6drill.xls / e-0603sol-sd.xls
P6-CH / e-0604.xls / e6challenge.xls / e-0604sol-ch.xls
P6-DZ / e-0605.xls / e6discovery.xls / e-0605sol-dz.xls
P7-L1 thru L4 / e-0701.doc
new workbook / no change
Marie90.xls / e-0701sol-proj.xls
P7-L5 thru L8 / e-0702.xls / Marie90budget.xls / e-0702sol-proj.xls
P7-SD / e-0703.xls / e7drill.xls / e-0703sol-sd.xls
P7-CH / e-0704.xls / e7challenge.xls / e-0704sol-ch.xls
P7-DZ / e-0705.xls
e-0706.doc / e7discovery.xls / e-0705sol-dz.xls
e-0706sol-dz.doc
P8-L1 thru L8 / e-0801.xls / MS165grades.xls / e-0801sol-proj.xls
P8-SD / e-0802.xls / e8drill.xls / e-0802sol-sd.xls
P8-CH / e-0803.xls / e8challenge.xls / e-0803sol-ch.xls
P8-DZ / e-0804.xls / e8discovery.xls / e-0804sol-dz.xls
P9-L1 thru L8 / e-0901.xls
e-0902.wav (L8) / LeaseOptions.xls
no change / e-0901sol-proj.xls
P9-SD / e-0903.xls / e9drill.xls / e-0903sol-sd.xls
P9-CH / e-0904.xls / e9challenge.xls / e-0904sol-ch.xls
P9-DZ / e-0905.xls / e9discovery.xls / e-0905sol-dz.xls
P10-L1 thru L8 / e-1001.xls / listings.xls / e-1001sol-proj.xls
P10-SD / e-1002.xls / e10drill.xls / e-1002sol-sd.xls
P10-CH / e-1003.xls / e10challenge.xls / e-1003sol-ch.xls
P10-DZ / e-1004.xls / e10discovery.xls / e-1004sol-dz.xls
P11-L1 thru L7 / e-1101.xls / protection.xls / e-1101sol-proj.xls
P11-L8 / e-1102.xls / password.xls / e-1102sol-proj.xls
P11-SD / e-1103.xls / e11drill.xls / e-1103sol-sd.xls
P11-CH / e-1104.xls / e11challenge.xls / e-1104sol-ch.xls
P11-DZ / e-1105.xls / e11discovery.xls / e-1105sol-dz.xls
P12-L1 thru L8 / e-1201.xls / Indy500validation.xls / e-1201sol-proj.xls
P12-SD / e-1202.xls / e12drill.xls / e-1202sol-sd.xls
P12-CH / e-1203.xls / e12challenge.xls / e-1203sol-ch.xls
P12-DZ / e-1204.xls / e12discovery.xls / e-1204sol-dz.xls
P13-L2 thru L8 / e-1301.xls / pivotsalary.xls / e-1301sol-proj.xls
P13-SD / e-1302.xls / e13drill.xls / e-1302sol-sd.xls
P13-CH / e-1303.xls / e13challenge.xls / e-1303sol-ch.xls
P13-DZ / e-1304.xls / e13discovery.xls / e-1304sol-dz.xls
P14-L1 / e-1401.xls / AnnualSales.xls / e-1401sol-L1.xls
P14-L2 / Region1.xls
Region2.xls / no change
no change
new workbook named TotalSales.xls / Region1.xls
Region2.xls
e-14sol-L2.xls
P14-L3 / e-1402.xls / SpecialtySports.xls / e-1402sol-L3.xls
P14-L4 / e-1403.xls / OutlineSurvey.xls / e-1403sol-L4.xls
P14-L5 / e-1404.xls / NewViews.xls / e-1404sol-L5.xls
P14-L6 / e-1405.xls / NewReport.xls / e-1405sol-L6.xls
P14-L7 / e-1406.xls / EditReport.xls / e-1406sol-L7.xls
P14-L8 / Region1.xls
Region2.xls / no change
no change
new workspace named eastwest.xlw / Region1.xls
Region2.xls
e-14sol-L8.xlw
P14-SD / e-1407.xls
SalesPerson1.xls
SalesPerson2.xls
SalesPerson3.xls / e14drill.xls
no change
no change
no change / e-1407sol-sd.xls
SalesPerson1.xls
SalesPerson2.xls
SalesPerson3.xls
P14-CH / e-1408.xls
Standard.xls
Deluxe.xls / e14challenge.xls
no change
no change / e-1408sol-ch.xls
Standard.xls
Deluxe.xls
P14-DZ / e-1409.xls / e14discovery.xls / e-1409sol-dz.xls
P15-L1 thru L7 / e-1501.xls / Project List.xls / e-1501sol-L2.xls
e-1501sol-L5.xls
e-1501sol-L7.xls
P15-SD / e-1502.xls / e15drill.xls / e-1502sol-sd.xls
P15-CH / e-1503.xls / e15challenge.xls / e-1503sol-ch.xls
P15-DZ / e-1504.xls / e15discovery.xls / e-1504sol-dz.xls
P16-L1 thru L7 / e-1601.xls / Analyze-This.xls / e-1601sol-proj.xls
P16-SD / e-1602.xls / e16drill / e-1602sol-sd.xls
P16-CH / e-1603.xls / e16challenge / e-1603sol-ch.xls
P16-DZ / e-1604.xls / e16discovery / e-1604sol-dz.xls
P17-L1 thru L4 / e-1701.xls / Tools.xls / e-1701sol-proj.xls
P17-L5 / e-1702.xls / AnnualReport.xls / e-1702sol-proj.xls
P17-L6 / e-1703.doc
e-1704.xls / DataLink.doc
no change / e-1703sol-proj.doc
(also e-1704.xls in same folder)
P17-L7 / e-1705.ppt
e-1704.xls / PPlink.ppt
no change / e-1705sol-proj.ppt
(also e-1704.xls in same folder)
P17-SD / e-1706.xls
e-1707.doc / e17drill.xls
no change / e-1706sol-sd.xls
(also e-1707.doc in same folder)
P17-CH / e-1708.xls / e17challenge.xls / e-1708sol-ch.xls
P17-DZ / e-1709.xls / e17discovery.xls / e-1709sol-dz.xls
P18-L1 / e-1801.xls
e-1802.doc / SalesData01.xls
SalesReport01.doc / e-1801sol-projL1.xls
e-1802sol-projL1.doc
P18-L2 / e-1803.xls
e-1804.doc / SalesData02.xls
SalesReport02.doc / e-1803sol-projL2.xls
e-1804sol-projL2.doc
P18-L3 and L4 / e-1805.xls
e-1806.ppt / SalesData03.xls
SalesReport03.ppt / e-1805sol-projL3.xls
e-1806sol-projL3.ppt
P18-L5 / e-1807.xls / From Export.xls to Export.mdb / Excel data exported to an Access database; Client Assignments table created within export.mdb
P18-L6 / e-1808.txt / SaveManatee.xls / Text file converted to Excel file
e-1808sol-projL6.xls
P18-L7 / e-1809.htm / Manatee.htm / "Roundtrip" editing: in as .htm, edited in Excel, out as .htm, viewed in Explorer, edited again in Excel
e-1809sol-projL7.htm
P18-L8 / e-1810.xls
e-1811.mdb / Clients.xls
no change / Get external data from Access into Excel; e-1810sol-projL8.xls
P18-SD1 / e-1812.xls
e-1813.doc / e18drill.xls
Glenn Lakes.doc / no change
e-1813sol-sd1.doc
P18-SD2 / e-1812.xls
e-1814.txt / e18drill.xls
no change / e-1812sol-sd2.xls
P18-SD3 / e-1812.xls
e-1815.ppt / e18drill.xls
mileage.ppt / no change
e-1815sol-sd3.ppt
P18-CH1 / e-1816.xls
e-1817.doc / e18challenge.xls
review.doc / no change
e-1817sol-ch1.doc
P18-CH2 / e-1816.xls / e18challenge.xls / Excel data exported to an Access database; Expense List table created within e18challenge.mdb
P18-CH3 / e-1816.xls
e-1818.mdb / e18challenge.xls
no change / Get external data from Access into Excel; e-1816sol-ch3.xls

xl-fileguide2-15.docFox/MetzelaarPage 1