Chapter 2, Problem 8EYK

Open the start file EX2019-ChallengeYourself-6-3. The file will be renamed automatically to include your name.  If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook.  On the Sales Data worksheet, enter a formula in cell J4 to find the sales associate's region by extracting the first three characters of the sales associate's ID in cell C4. Use cell references where appropriate. Fill the formula down through cell J64. On the Sales Data worksheet, calculate the commission rate and commission paid for each sales associate.  Beginning in cell F4, enter a formula using the IFS function to calculate the commission rate based on the following table. Hint: Do not include comma separators in numerical values in formulas. Excel interprets commas as function argument separators.Table EX 6.1 displays calculations for commission rates based on annual sales. IF ANNUAL SALES ARE: THEN THE COMMISSION…

file / directory attribute contains the date of modification performed.

the "list.txt" contains information about materials stored in the warehouse. Every record (line) in the file contains code, name and description seperated by "#" write a php script that will open the file, read the content of the file and manupulate using associative array with code as a key. the array should be sorted by the code and displayed to the user.

The file london_weather.csv  contains weather data for the years 1979 to 2020. The first five lines of this file are: date,cloud_cover,sunshine,global_radiation,max_temp,mean_temp,min_temp,precipitation,pressure,snow_depth19790101,2,7,52,2.3,-4.1,-7.5,0.4,101900,919790102,6,1.7,27,1.6,-2.6,-7.5,0,102530,819790103,5,0,13,1.3,-2.8,-7.2,0,102050,419790104,8,0,13,-0.3,-2.6,-6.5,0,100840,2 Note, in particular, that the dates are given as eight-digit integers in the format YYYYMMDD. There appears to be some inconsistencies in this data, as there are rows for which the column max_temp contains an entry that is smaller than the corresponding entry in min_temp. Write a Python function wrong_temperature(year) that returns the number of days in a given year for which the column max_temp contains an entry that is smaller than the corresponding entry in the column min_temp.

What format model should you use to display the date 25-DEC-09 as Dec. 25?

Subject SubjectNO Student SUB_Name STD_Name Pre SUB Specialization STD NO Registration SubjectNO STD NO REG date Q1) Write procedure to print the registration dates for all subjects that are registered by student whose name "ALI". h 17

PYTHON CODE Using Artists.csv (link below), write a query that returns all lines that are female artists only, with begin date greater than 1950 but no greater than 2000 Write a query that will return all lines of British Male artists, who's first names starts with the letter ‘A’ and has an end date earlier than 1990 Write a query that will write to a file all lines that have Japanese Artists who’s difference of end date and begin date exceeds 100 years. I.e. if artist begins in 1900 and ends in 2005, then they would be included in the output (2005-1900 = 105 years) Write a query that will write and find to a file the artist who’s been at the Museum the longest (the widest gap between Begin Date and End Date) Artists.csv: https://media.githubusercontent.com/media/MuseumofModernArt/collection/master/Artists.csv

For the following data, identify what are the text qualifiers and delimiters. If a text qualifier or delimiter is not used, answer "none." Flat file, Header Row: DocumentNum;BankName BankAddress;DocumentDescriptionFlat File Data Row: 331-12;"First Bank" "429 Taylor St. Haines City, FL 33844";"Loan Agreement"

Please give me correct solution with explanation. The DATE option of the COLUMN command does not allow a specific format to be applied to date values. True False