Type symbol in cell b2, type last sale price in cell c2, and type rank in cell d2.

enter the following stock information beginning in cell b3: click cell b3 and type ctic. click cell c3 and type 1.92. click cell b4 and type aapl. click cell c4 and type 130.96. click cell b5 and type c. click cell c5 and type 59.19. click cell b6 and type bac. click cell c6 and type 18.12.

use the rank. avg function to calculate the rank of the first stock in cell d3 and copy the formula down to complete the column.

click cell b8, type average value, and in cell c8 type < 100 . in cell b9, use the averageif function to calculate the average value of stocks that sell for less than $100.00 using the criteria in cell c8.

set column b width to 13, column c to 22, and apply accounting number format to cell b9.

create a descriptive statistics summary report using the range c2: c6 as the input range and cell f2 as the output range. note that the first row of the input range contains labels.

rename the worksheet stock quotes and apply the following formatting:

• apply accent2 themed cell style format to the ranges b2: d2 and b8: c8.
• apply top and bottom borders to the ranges b8: c8 and b2: d2.
• apply thick bottom border to the range b6: d6.

create a footer with your name on the left side, the name of the worksheet in the middle, and the file name on the right side.

save and close the workbook. submit the file as directed.

Create a class hand in its own module. one object of class hand represents a hand of cards and so one object stores a number of card objects. for this assignment you will submit three separate modules, one with the definition of class card, one with the definition of class hand and one with the main application that thoroughly tests class hand.class hand must contain the following four methods: 1) , numcardsinhand) takes an integer as parameter and initializes a hand object with numcardsinhand card objects inside it. these card objects are generated randomly. for simplicity, assume an infinite number of decks of cards.2) bjvalue(self) returns the blackjack value for the whole hand of cards3) ) returns a string containing all the cards in the hand4) hitme(self) adds one randomly generated card to the handcreate a main program in its own module that thoroughly tests class hand. you will have three modules/files to upload to your etudes assignment submission: card.py, hand.py and the module that contains your main program.two alternatives for extra credit - you cannot get credit for both! (+1 point): after you have thoroughly tested the class hand and all of its methods, add code to your main program that stores one hand object as a pickle file and reads it back into a new hand object. you are only eligible for this extra credit if class hand has all four of the methods above working.or(+2 points): after you have thoroughly tested the class hand and all of its methods, add code to your main program that stores one hand object as a text file on the disk and reads it back into a new hand object. you are only eligible for this extra credit if class hand has all four of the methods above working.notes: -start by making any and all modifications suggested by my comments to your previous submission of class card from assignment #6 "a robust card object"-once your class card is tested and working well, you will not make any further modifications to it for the purposes of class hand.-you can keep the test code for class card intact. if it is indented inside an if __name__ == "__main__", then it will not be executed when your main program's module imports it.-to save time, write and test one method for class hand at a time.-under no circumstances are you to attempt the extra credit until you are completely finished with writing and testing all the methods in class hand.