1.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbTFpQbXJNanB0NUU
2. Consider the scenario of Hewitt Automobiles, a car manufacturing company in Texas. The manufacturing details of cars of the last financial year are stored in a Microsoft Excel worksheet. Samantha, the Plant Head, wants to analyze the manufacturing details of last year in order to take strategic decisions for the present year. Samantha wants to find the maximum and minimum number of cars that were manufactured for each model. In addition, she wants to know the total number of cars manufactured last year. Moreover, she wants to find the average production of cars in the previous year. You are required to help Samantha to perform the tasks.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbYWwzR3FScXY5OFE
3. Consider a scenario of Optimystic Inc. Kathy, the Delivery Manager of the company, handles the details of the all the projects assigned to different project managers. She maintains the details, such as the project name, the project id, the manger's name, the team members' names, the start date of project, and the end date of project in a Microsoft Excel worksheet. She wants to find the number of days spent to complete the project. You are required to help Kathy to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbZnJDYTNuczVCeTQ
4. Consider the scenario of JF KennedyAirport, which is one of the famous airports of the US. Karen, the Air TrafficController at the JF Kennedy airport, maintains a record of all the flights ona daily basis in a Microsoft Excel worksheet. Whenever a flight arrives ordeparts, she records down the time. Help Karen to record the current date in acell above the flight schedule details and record the arrival time, 11:30 PM for British Airways - flight number 65876.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbdEJVOVV2VnJIMEk
5. Consider the scenario of TetraGraph Steel Production Company. Due to competition in the market, the company is facing a financial crisis. Robert, the Finance Manager, consults a loan granting company, Quin Financial Services, to take a loan to sustain in the market. For this purpose, he meets Frank, the Loan Officer of Quin Financial Services, to inquire about the loan details. Quin Financial Services accepts to offer a loan of $ 3.2 million for a period of 12 year at the annual rate of interest of 7%. Robert wants to find the monthly installments he needs to pay. Help Robert to calculate the monthly installments.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbanBwMTV4SXFYa0U
6. Danny is planning to spend his summer vacation in Europe. For this purpose, he booked airline tickets, hotel rooms, and tourist guides. After spending his money on bookings, he finds that his digital camcorder is not working. He checks the price of the camcorder in an electronics store. Its price is $ 375. He cannot buy a new camcorder as he does not have any money left. So, he decides to buy it on an installment scheme. He is willing to pay $ 40 each month. The store offers the scheme at an annual interest of 6%. You are required to help Danny calculate the duration of time period he is required to pay the installments.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbNTNzNWhzMk14MTA
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbTFpQbXJNanB0NUU
2. Consider the scenario of Hewitt Automobiles, a car manufacturing company in Texas. The manufacturing details of cars of the last financial year are stored in a Microsoft Excel worksheet. Samantha, the Plant Head, wants to analyze the manufacturing details of last year in order to take strategic decisions for the present year. Samantha wants to find the maximum and minimum number of cars that were manufactured for each model. In addition, she wants to know the total number of cars manufactured last year. Moreover, she wants to find the average production of cars in the previous year. You are required to help Samantha to perform the tasks.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbYWwzR3FScXY5OFE
3. Consider a scenario of Optimystic Inc. Kathy, the Delivery Manager of the company, handles the details of the all the projects assigned to different project managers. She maintains the details, such as the project name, the project id, the manger's name, the team members' names, the start date of project, and the end date of project in a Microsoft Excel worksheet. She wants to find the number of days spent to complete the project. You are required to help Kathy to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbZnJDYTNuczVCeTQ
4. Consider the scenario of JF KennedyAirport, which is one of the famous airports of the US. Karen, the Air TrafficController at the JF Kennedy airport, maintains a record of all the flights ona daily basis in a Microsoft Excel worksheet. Whenever a flight arrives ordeparts, she records down the time. Help Karen to record the current date in acell above the flight schedule details and record the arrival time, 11:30 PM for British Airways - flight number 65876.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbdEJVOVV2VnJIMEk
5. Consider the scenario of TetraGraph Steel Production Company. Due to competition in the market, the company is facing a financial crisis. Robert, the Finance Manager, consults a loan granting company, Quin Financial Services, to take a loan to sustain in the market. For this purpose, he meets Frank, the Loan Officer of Quin Financial Services, to inquire about the loan details. Quin Financial Services accepts to offer a loan of $ 3.2 million for a period of 12 year at the annual rate of interest of 7%. Robert wants to find the monthly installments he needs to pay. Help Robert to calculate the monthly installments.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbanBwMTV4SXFYa0U
6. Danny is planning to spend his summer vacation in Europe. For this purpose, he booked airline tickets, hotel rooms, and tourist guides. After spending his money on bookings, he finds that his digital camcorder is not working. He checks the price of the camcorder in an electronics store. Its price is $ 375. He cannot buy a new camcorder as he does not have any money left. So, he decides to buy it on an installment scheme. He is willing to pay $ 40 each month. The store offers the scheme at an annual interest of 6%. You are required to help Danny calculate the duration of time period he is required to pay the installments.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbNTNzNWhzMk14MTA
No comments:
Post a Comment