Reference no: EM132257217
Lab Assignment -
Count-If, Sum-If, Average-If and similar aggregate functions - Part 1
Open course_calculations.xlsx
Use COUNTIF to find the number of grades letters (A through E) in each course. Enter the count in column I, I2:I9 for course 001, and I14:I21 for course 002.
Calculate the percent of the course that received each letter, J2:J9 for course 001, and J14:J21 for course 002. Calculate total points contributed to GPA from each letter, L2:L9 for course 001, and L14:L21 for course 002. Enter totals in green shaded cells. Calculate course GPA in K11 and K23. Create column charts with course titles to show grade distribution.
Open chi_energy_sumifcountifavif.xlsx. Format the data in the first worksheet as a table and name it chi_energy2010.
Go to the SumIFAvgIfCountIF worksheet and complete the calculations directed using sumifs, averageifs, or countifs. Use structured table references.
OFFSET and INDIRECT Functions - Part 2
Open check_indirect.xlsx
Format the data (starting in row 3) as a table, and name it check_table. Use indirect in cell G2 to show the last balance in the table. The formula should always show the last balance, so it must adjust when additional data is added to the table.
Remember to combine all worksheets into 1 workbook.
Topics: The schedule has been revised to introduce these concepts and functions first.
Aggregate-If Functions: Show and experiment with COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, and AVERAGEIFS functions and manipulation.
Note that there is a different format for the ...IF aggregate functions than there are for the ...IFS aggregate function.
Complete and Submit the Exercises: Please refer to the attached Instructions and Example document. Combine all three exercises into one workbook.
Note - For detailed description of assignment see attached file.
Attachment:- Assignment Files.rar
|
Describe the importance of self-awareness
: Describe the importance of self-awareness, self-concept, and emotional intelligence and the role they play in enabling effective conscious leadership.
|
|
How bundled care will change the traditional billing cycle
: Discuss how primary payer, secondary payer, deductibles and co-pays affect what is billed.
|
|
Focus on the specific legal issue
: A brief restatement of the legal question posed--usually a sentence or two that focus on the specific legal issue in this case, without reference to extraneous
|
|
How has experience or lack of it shaped your view of death
: How often do you engage with or witness death in your work? How has this experience or the lack of it shaped your view of death? Has it gotten easier or harder.
|
|
Calculate the percent of course that received each letter
: CIS 2640 Lab Assignment - Calculate the percent of the course that received each letter, J2:J9 for course 001, and J14:J21 for course 002
|
|
Compute safety stock levels at each of four retail stores
: compute the safety stock levels at each of the four retail stores if the manufacturer wants to achieve a probability of no stock-out of 98%.
|
|
What will be the justifications for the decision
: Where does each requirement from six Ponsse requirements above belong to the organization, management, or technology dimension?
|
|
Investigate wound care nurses to write a paper
: Investigate Wound Care Nurses. Write a two-page paper (no longer, no shorter), plus title and reference pages, describing your topic.
|
|
Discuss your plan to properly close your project
: Discuss your plan to properly close your project when it is over. Provide a brief summary of your chosen project.
|