Populate the \"MonthAbbr\" column to be the first 3 characters of the \"MonthName\" using a formula

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

1. Populate the "MonthAbbr" column to be the first 3 characters of the "MonthName" using a formula

MonthID MonthName MonthAbbr

1a 1 January Jan

1b 2 February Feb

1c 3 March Mar

1d 4 April Apr

1e 5 May May

1f 6 June Jun

1g 7 July Jul

1h 8 August Aug

1i 9 September Sep

1j 10 October Oct

1k 11 November Nov

1l 12 December Dec

2. Given the date below, find the following answers using formulas and using the holidays below

Date 1/1/2019

Date Holiday

1/1/2019 New Year's

1/21/2019 MLK

2/18/2019 President's

4/19/2019 Good Friday

5/27/2019 Memorial

7/4/2019 Independence

9/2/2019 Labor

11/28/2019 Thanksgiving

11/29/2019 Day after Thanksgiving

12/25/2019 Christmas

2a Date 4 months from the "Date"?

2b 4th business day of that month?

2c Month (i.e. April, May)?

2d How many holidays are in November?

2e What holiday is on 4/19/2019? 4/19/2019 Good Friday

3. Given the data below, provide answers to the questions using formulas

Trade Date Direction Product Trader From Date To Date Volume Price

1/2/2019 Purchase Ethanol John Smith 2/1/2019 2/28/2019 10000 1.50

1/3/2019 Purchase Ethanol John Smith 2/1/2019 2/28/2019 2000 1.75

1/3/2019 Crude Oil John Smith 2/1/2019 2/28/2019 150 Nymex WTI + 2.00

1/4/2019 Natural Gas John Smith 2/1/2019 2/28/2019 5000 IFERC Chicago + .01

1/5/2019 Natural Gas John Smith 2/1/2019 2/28/2019 28000 4.00

1/6/2019 Ethanol John Smith 3/1/2019 3/31/2019 31000 1.23

2/1/2019 Purchase Crude Oil John Smith 3/1/2019 3/31/2019 15000 42.00

2/2/2019 Crude Oil John Smith 3/1/2019 3/31/2019 20000 45.25

2/2/2019 Crude Oil John Smith 4/1/2019 4/30/2019 30000 Nymex WTI + 4.00

2/2/2019 Purchase Natural Gas John Smith 4/1/2019 4/30/2019 300 3.50

3a How many Ethanol deals are there? 3

3b How much Ethanol was sold with a trade date in January?

3c How much Crude Oil is to be purchased and sold in April?

3d What is the volume weighted average price for the first 2 deals?

3e Who is the trader that did the Power deal? If there is an error, say "does not exist"

3f Create conditional formatting for all cells to be red where the Direction = "Sell"

3g Create a pivot table to show total volume by Product, Trader

 

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme