Expert answer:Create a excel follow the direction in attached files, the files are taken from the Go! with Microsoft Excel 2013 Comprehensive project 10E Er Department.
1_start_excel.docx
e10e_er_dept.xlsx
e10e_er_doctors.txt
Unformatted Attachment Preview
1 Start Excel. From your student files, open the Excel workbooke10E_ER_Dept. Save the file in your Excel
Chapter 10 folder as Lastname_Firstname_10E_ER_Dept On the Emergency Staff worksheet, insert a
DAVERAGE function in cell B22. As the Database, use the range a3:f20 As the Field, type Hourly Wage
and as the Criteria, use the range c22:c23 Apply Accounting Number Format to the result.
2 In cell B25, enter a DSUM function using the database range A3:F20, type “Wage per Shift” as the
field, and c25:d26 as the criteria. Apply Accounting Number Format to the result.
3 Display the ER Staff Information worksheet, click cell A2. From your student files, import the data
from the Access file e10E_ER_Staff as a table in the existing worksheet.
4 Display the ER Doctors worksheet; click cell A6. From your student files import the text file
e10E_ER_Doctors. Remove duplicate doctors from each unit, and separate the City, State, and Zip fields.
AutoFit columns A:J. Hide column F.
5 Display the Emergency Training worksheet. Display the Open dialog box, and then, from your student
files, open the HTML file e10E_Emergency_Training with your browser. Copy the address from the
browser address bar. Import the data from the Emergency Training table into cell A2 of your worksheet.
EnD | You have completed Project 10E
6 Display the Paramedic Services worksheet. In cell A2 import data from a Microsoft Query. As the data
source, select the MS Access Database e10E_Paramedic_Contacts.accdb.
7 Expand the table, and then add all the fields to the Columns in your query list on the right. Filter the
data to display only ZIP 32790 Sort by the Average Fee in Ascending order. Import the table into the
existing workbook. Convert the table to a range, and then apply Accounting Number Format to the fees.
8 Select all the sheets, insert a footer in the left section with the File Name, set the Orientation to
Landscape, set the Width to 1 page and the Height to 1 page. Center the worksheets horizontally.
Return to Normal view, and then make cell A1 the active cell. With the worksheets still grouped, display
the document properties and under Related People, if necessary, right-click the author name, click Edit
Property, and then type your name. In the Subject box, type your course name and section number, and
in the Tags box, type emergency department information Ungroup the worksheets and Save your
workbook. Print or submit your workbook electronically. If required, print or create an electronic version
of your worksheets with formulas displayed. Close the workbook and Close Excel.
Monday Shift
Emergency Staff
Employee Number
Shift Code
18
20
23
26
27
28
29
30
31
32
33
34
35
36
43
47
48
3
3
1
5
5
2
3
6
1
2
4
6
5
5
6
5
2
Average Hourly Wage for ER Nurses
Wage per Shift for EMTs
Status
ER Nurse
ER Supervisor
EMT
ER Nurse
EMT
ER Nurse
EMT
ER Supervisor
EMT
ER Nurse
EMT
EMT
ER Nurse
EMT
ER Nurse
ER Supervisor
EMT
Hours per Shift Hourly Wage
8
0
8
12
12
0
8
12
8
8
8
12
12
0
12
12
8
Status
ER Nurse
Status
Hours per Shift
EMT
>0
62.40
75.40
29.09
61.43
26.65
62.14
27.63
75.66
27.89
61.62
28.60
24.38
63.05
25.68
63.21
75.73
28.93
Wage per
Shift
499.20
232.72
737.16
319.80
221.04
907.92
223.12
492.96
228.80
292.56
756.60
758.52
908.76
231.44
ER Staff Information
ER Doctor Information
ER Doctor ID
2385
2252
2253
First Name
Helene
Lydia
Neil
Last Name
Ashker
Robles
Saxe
ER Unit
Unit 8
Unit 2
Unit 3
Address
6019 – 150th Ct NE
1 Lake Tapps Station
432 Meridian Way
City, State, Zip
Hialeah, FL 33010
Miami, FL 33145
Miami, FL 33174
Phone Number
(305) 555-0243
(305) 555-0299
(305) 555-0246
Training for ER Dept Personnel
Paramedic Services in Winter Park and Average Fee
2248 Allen Jaworski
Unit 4
1027 Heath Drive “Miami, FL 33143” (305)
555-0223
2385 Helene
Ashker
Unit 8
6019 – 150th Ct NE
“Hialeah, FL
33010”
(305) 555-0243
2257 Viktor
Semukhin
Unit2 1118 NE 43rd Place
“Coral Springs, FL
33075”
(305) 555-0235
2260 Maria Vasquez
Unit 5
101 Village Park West
“Hialeah, FL 33013”
(305) 555-0277
2265 Keith Webb Unit 3
2 Casa Blanca Road
“Winter Park, FL 32790”
(305) 555-0292
2342 Joe
Ziska Unit 7
299 Lake Hills Blvd
“Coral Springs, FL 33077”
(305) 555-0256
…
Purchase answer to see full
attachment