SC_EX19_3b_FirstLastName

 SC_EX19_3b_FirstLastName 

  

1. Amir Nader is a sales analyst for Sales Dart Services, a sales and marketing services company in Chicago, Illinois, that works with businesses in the consumer goods industry. Amir has been creating a report that analyzes sales and commissions in an Excel workbook, and has asked you to help him complete the report.
 

Go to the Report worksheet. Rename the Report worksheet to as Sales Report, which is a more accurate name.

2. Unfreeze the panes to scroll the worksheet without keeping the top and left panes displayed.

3. Middle Align the contents of the merged cell A2 to improve the appearance of the “Sales Report” subtitle.

4. In cell K2, insert a formula that uses the NOW function to display today’s date.

5. Fill the range C5:G9 with the formatting from the range B5:B9 to use a consistent number format for the sales data.

Write a 5-6-page, APA-formatted report with details and clear answers.

Write a 5-6-page, APA-formatted report with details and clear answers. 

Q1. Why do you believe schedule issues often cause the most conflicts on projects? 

Q2. Why is it difficult to use project management software well? 

Q3. How do the “3 legs” of project management impact scheduling and What can be done to offset potential impacts?

Q4. Discuss three suggestions for improving IT project quality that were not made in Chapter 8 in your textbook.

with minimum of 6 APA references. 

mission statements

Question

 Find three mission statements of companies online and analyze if they provide direction, motivation and address stakeholders.

Compare each mission statement with the other and discuss their differences and why they may be different

 Submission Format: MS Word

Length: Minimum of 400 words per question

Citations Required: Cite any resources used

Chapter Summary

Due Sep 12, 11:59pm, PT…………20 hours left

Need to write about 2 pages (1.5 line spacing and 11 or 12 font size) of summary of chapter, so that it contains:

(part 1) important concepts of the chapter

(part 2) experience/application/opinions of the chapter.  

Information System Ethics

The topic to discuss is an important aspect of information technology: ethics.  Please describe the term information system ethics and note some of the principles a company can establish to ensure they are acting ethically within their information systems.

Your response should be 250-300 words with references in APA format.

Racket Code

 

(define curry
(lambda (lambda-exp)
‘fill-in-the-blank’))

Using Racket Code Write a structurally recursive function named (curry exp) that takes one argument, a Racket lambda expression with n ≥ 1 formal parameter. curry returns a curried function. For example:

    > (curry '(lambda (x) anything))
    '(lambda (x) anything)

Title SQL Queries

  

Title : SQL Queries

45. SELECT Prod_SKU, Prod_Descript, Prod_Type, Prod_Base, Prod_Category, Prod_Price

46. SELECT Emp_Fname, Emp_Lname, Emp_Email

47. SELECT Emp_Fname, Emp_Lname, Emp_Phone, Emp_Title, Dept_Num

48. SELECT e.Emp_Num, e.Emp_Lname, e.Emp_Fname, sh.Sal_From, sh.Sal_End, 

49. SELECT DISTINCT e.Cust_Fname, e.Cust_Lname, e.Cust_street, e.Cust_city, e.Cust_state, e.Cust_ZIP

50. SELECT e.Emp_Num, e.Emp_Lname, e.Email, e.Emp_Title, d.Dept_Name

51. SELECT b.Brand_Name, COUNT(p.Prod_SKU)

52. SELECT Prod_Category, COUNT(Prod_SKU)

53. SELECT prod_base, prod_type, COUNT(Prod_SKU)

54. SELECT Brand_ID, SUM(Prod_QOH)

55. SELECT b.Brand_ID, b.Brand_Name, ROUND(AVG(p.Prod_Price))

56. SELECT dept_num, MAX(Emp_Hiredate)

57. SELECT e.Emp_Num, e.Emp_Fname, e.Emp_Lname, MAX(sh.Sal_Amount)

58. SELECT c.Cust_Code, c.Cust_Fname, c.Cust_Lname, SUM(i.Inv_Total)

Take Home: Excel Chapter 2 Grader Project

StepInstructionsPoint Value1Start Excel. Download and open the file named Exp19_Excel_Ch02_Cap_InlandJewelers.xlsx. Grader has automatically added your last name to the beginning of the filename.02Insert a function in cell B2 to display the current date from your system.103With cell B2 selected, set the width of column B to AutoFit.04Insert a VLOOKUP function in cell C5 to display the ring cost for the first student. The cost of the ring-type should be an exact match. Use appropriate relative and absolute cell references.145Copy the formula from cell C5 to the range C6:C11.66Apply Accounting number format to the range C5:C11.47Insert an IF function in cell E5 to calculate the total due. If the student has chosen to personalize the ring, there is an additional charge of 5% located in cell B21 that must be added to the cost of the ring; if not, the student only pays the base price. Use appropriate relative and absolute cell references.148Copy the formula from cell E5 to the range E6:E11.69Apply Accounting number format to the range E5:E11.310Insert a function in cell G5 to calculate the first student’s monthly payment, using appropriate relative and absolute cell references. Ensure a result is a positive number.1411 Copy the formula from cell G5 to the range G6:G11.712Apply Accounting number format to the range G5:G11.413Calculate totals in cells C12, E12, and G12.
714Apply Accounting number format to the cells C12, E12, and G12.215Set 0.3″ left and right margins and ensure the page prints on only one page.516Insert a footer with your name on the left side, the sheet name in the center, and the file name on the right side.417Save and close Exp19_Excel_Ch02_Cap_InlandJewelers.xlsx. Exit Excel. Submit the file as directed0