02 Jul computer science
Question Description
Open the Exam4TestData workbook and select the Music sheet. You want to determine what the payment might be based on different interest rates. Starting in cell F6, enter a range of rates from 6% – 9% for every ¼ percent. (1 pt)
Enter a formula in G5 that will allow you to create an input table for the rates created in the previous step. Hide the result of the formula from displaying on the screen. (2 pts)
Create an input table to calculate the payments for the rates entered in step 1. (2 pts)
Format the input table data results using the exact same format as cell C11. (1 pt)
UPLOAD a screenshot of the worksheet, then SAVE the file with a password to open the file. The password should be your first name2018. (for example: Marcus2018) UPLOAD the workbook to D2L. (1 pt)
Exchanging Data – 11pts
Import the file: EX M-17.txt (from your Extra Data Files) into an Excel file. Save the file as XXXSuppliers (replace XXX with your initials). Add the password Spreadsheets2018 to enable opening the workbook. UPLOAD XXXSuppliers to D2L. (3 pts)
Embed the file Nordic into the Word document Nordic Memo with the Excel file displayed as in icon. UPLOAD the saved Nordic Memo file to D2L. (2pts)
Open the PowerPoint presentation: Nordic Knits Quarterly Report. Insert the pie chart from the Sales Categories sheet of the Nordic Knits Forecast workbook. Keep the Source Formatting and link the Excel data into the PPT slide. Nudge the chart towards the center of the slide. UPLOAD a screenshot of this slide to D2L, and then change the projected sales of Vests to $200,000. Save and UPLOAD the PPT file to D2L. (there is no need to upload the Excel file) (3 pts)
Import the Sales sheet of the Computer Sales workbook into a new table in a blank Access database named 2018ComputerSales. The first row of the Excel data should contain the Access column headings. Do NOT import Fields 7, 8 ,9 , 10 or 11. Let Access add a Primary Key and accept all other defaults. Make sure to save the database to your desktop and UPLOAD the file to D2L. (3 pts)
Christmas Cakes – 15 pts
Open the data file, XmasCakes and select the CreditUnion worksheet.
Use Goal Seek to determine how much of a car loan can be had if the monthly payment is set to $350.00. (make sure the payment amount is correctly entered into the Goal Seek window) (2pts)
Create a scenario called Original Data that captures the defaulting data for the Savings Plan. (Hint: the only cells that can be changed are those without a formula in them.) (1pt)
Use Goal Seek to determine what interest rate is required for the savings plan to earn $7,000 in four years. (2pts)
Create a scenario called 7K Interest Rate that captures the defaulting data from the previous step for the Savings Plan. (1pt)
Show the Original Data scenario.
Use Goal Seek to determine how much of a deposit is required for the savings plan to earn $7,000 in four years. (2pts)
Create a scenario called 7K Deposit that captures the defaulting data from the previous step for the Savings Plan. (1pt)
Show the Original Data scenario.
Change cell D4 to 6 and then create a scenario called 6 Year FV that captures the defaulting data from the previous step for the Savings Plan. (1pt)
Create named ranges for cells D4:D7 based off the cells in column C. (1pt)
Create a Scenario Summary report of the scenarios you created. (1pt)
Open the DecoratingSchedule worksheet and study the formulas in column D & F. Select the range B9:F9 and click the AutoSum button.
Select cell D9 and use the Solver feature to determine how many hours each employee needs to work to produce 750 cakes in a week. Ensure that no employee works more than 40 hours per week. Keep the Solver solution. (3pts)
Save the workbook as Christmas Cakes and UPLOAD the file to D2L.
XML – 7pts
Create a new workbook named Contacts.
Add the XML schema N-17.xsd to the workbook. Map all of the elements starting in cell A1, but remove the DNUMBER element from the map and delete the field from the table. (3 pts)
Import the XML file N-18.xml into the workbook. Sort the table ZIP in Ascending order. SAVE the entire workbook as a single file web page named Members. (2 pts)
Filter the Excel worksheet for only Active members. SAVE the Contacts workbook. UPLOAD both files to D2L. (2 pts)
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.