When you are finished, submit your completed project file(s)…

When you are finished, submit your completed project file(s) and Excel – Capstone Plan.docx.  Please submit them in a compressed folder/zip file called .zip.  An example file name would be “John Doe.zip”.  You must submit at least one project file in Excel workbook format (.xlsx) that includes demonstrated skills.  Non-Excel project files are only acceptable to demonstrate saving an Excel workbook in (or importing data from) different file formats. You’re going to do great! File creation, structure and navigation – 10 points Formatting and layout – 20 points Formulas, tables and charts – 60 points Conclusion based on numerical data – 5 points Page setup and document finishing – 5 points

Consider the figure below. (Same figure as the previous ques…

Consider the figure below. (Same figure as the previous question.) Assume the IP and MAC addresses for R1, R2, H1, H2, and H5 are as follows (same addresses listed as the previous question): R1 IP address: (not given)R1 MAC address:  11:74:33:02:35:66 R2 IP address: (not given)R2 MAC address: 12:23:34:45:56:67 H1 IP address: 130.234.227.120H1 MAC address: 11:32:33:84:55:66 H2 IP address: 130.234.227.200H2 MAC address: 99:00:88:65:45:55 H5 IP address: 203.54.6.45H5 MAC address: 15:83:25:22:35:33 Consider the packet that is sent from H1 through Router 1 and Router 2 to H5. What IP addresses are placed in the source and destination fields of the original IP datagram being sent from H1? Answer format a) Source IP address in packet:  (IP address IPv4 format) In the next question explain why the chosen address is appropriate. b) Destination IP address in packet:  (IP address IPv4 format) In the next question explain why the chosen address is appropriate.      

Below are the instructions similar to what you will see on t…

Below are the instructions similar to what you will see on the real test.  This is Test 01 covering Units 01 – 05. This test will be timed, and you will have one hour and twenty minutes to take this test (with a five-minute grace period to finish up). Make sure to answer and save all the questions.  Please obey the honor code and do not seek help from, nor give help to, other students.  You may use a calculator and a blank sheet of “scratch paper”.  Do your best and good luck.  There are about ten questions from each unit. There are about 50 multiple choice questions in total. IMPORTANT: You will see one question at a time, click on the Next Page to see the next question.  You may go back to prior questions.  Only click on the submit button when you have finished.