Tutorelizabeth

#1 =AVERAGE('Past Events'!C4:C103) =AVERAGE('Past Events'!C4:C103) #2 =STDEV('Past Events'!C4:C103) =STDEV('Past Events'!C4:C103) #3 =CONFIDENCE(0.95,J7,I13) =CONFIDENCE(0.95,J7,I13) #4 =CORREL('Past Events'!D4:D103,'Past Events'!C4:C103) =CORREL('Past Events'!D4:D103,'Past Events'!C4:C103)

Question 1 Main Concept Payment How to find Interest Amount How to find Principal Amount How to find Balance Amount Total Amount Paid Total Interest Paid Sum Check Calculation How to find monthly interest amount? Previous balance X Monthly Interest Rate How to find monthly principal amount? Monthly payment - monthly interest amount How to find balance amount?

Match the way information can be displayed in a spreadsheet with the type of information to be displayed. In rows: 5,6 and 7 In columns: AA, BB, CA In clip art: Images What is a possible outcome using Boolean Logic? Only the numbers 0 and 1. What is possible in freeze panes? Freezing the row above where a person is working. Match the category with its type of funct

Calculate the payment amount for the loan in cell C15. Reference the cells containing the appropriate loan information as the arguments for the function you use. Cells C20-C67 in the "Payment" column are populated with the payment amount from cell C15. [34 Points] =PMT(C13/12,C12,C11) Calculate, in cell D20, the interest amount for period 1 by multiplying the balance in period 0 (cell F19) by the loan interest rate (cell C13) divided by 12. Dividing the interest rate by 12 results in the...

IN Columns AA, BB, CA In Rows 5, 6, 7 In clip art Images What is a possible outcome using Boolean logic Only the numbers 0 and 1 What is possible in freeze panes Freezing the row above where a person is working Auto sum Count, Number, Max Logical And, Not,

Adds the individual numbers or the numbers included in the range(s). SUM() Counts the number of cells in a range of cells that contain numbers. COUNT() Counts the number of cells in a range of cells that are not blank COUNTA() Calculates the simple average of a set of num

Agency A contract relationship between a principal and an agent whereby the principal authorizes the agent to work on his or her behalf and with power to bind the principal. Appropriation of Image of Likeness A type of tort in which an employer uses the name, image, or likeness of an employee for commercial purposes in a way that is not described in the job description. Assumption of Risk An employer defense that states an employee knows and accepts the risk of potential injury in a certai...

How would an HR professional determine whether an employment law is applicable to his/her employer? The first step is determining which federal employment statutes apply to the firm. Some federal laws apply to all employers regardless of size. The second would be to determine if the employer does contract work for a federal or state government. Third, after assessing which federal laws apply, the HR professional must look to state law. Finally, they need to understand which common law rules...

American with Disabilities Act (ADA) Employers with 15 or more employees are prohibited from discriminating against people with disabilities. In general, the employment provisions of the ADA require: - equal opportunity in selecting, testing, and hiring qualified applicants with disabilities - job accomodation for applicants and workers with disabilities when such accomodations would not impose "undue hardship" - equal opportunity in promotion and benefits Affirmative action Making an e...

Supremacy Clause Mandates that the constitution, federal laws, treaties and federal regulations are the highest laws above the land and are priority over state laws. Stare Decisis Doctrine of a court following the precedent of an earlier court. Judicial Review Power of the Supreme Court to consider whether a law comports with the consititution. Respondeat Superior Employer is only responsible for the employee action performed within the scope of employment.

WGU C233 Employment Law Study Guide Rated A+ Identify the role of the National Labor Relations Board (NLRB). The National Labor Relations Board is the federal agency given power to safeguard employees' rights to organize and to determine whether to have unions as a bargaining representative. the NLRB acts to prevent and remedy unfair labor practices committed by private sector employers and unions. The NLRB provides the legal framework and supervision for union elections and decertificati...

Under respondent superior doctrine, an employer is only responsible for the employee action performed within the: Reasonable person standard Duration of employment Realm of reasonable actions Scope of employment Scope of Employment Which of the following is not an element of a prima facie discrimination case for gender discrimination? The employee is qualified for the position The employee suffers some adverse employment action The employee is in the protected class A person of the sa...

Which constitutional provision mandates that federal regulations have priority over state law? Supremacy Clause Which doctrine is used by U.S. courts to align current cases with prior legal decisions? Stare decisis Two corporations have combined their management and operations into a single place with 30 total employees. Which type of business relationship is formed that now requires both companies to comply with federal employment law? Integrated enterprise Which test is used to disting...

Implied Contract Legally binding agreement which is created, not through formal contract negotiation and documentation, but by actions of employer and employee AKA-oral assurances Supremacy Clause mandates that the constitution, federal law, treaties and federal regulations are the highest laws of the land and have priority over state law. Frolic and Detour Employee's p

Employing fewer than 10 employees so the ADEA does not apply Which employer action is a possible employer defense to a claim asserted under the federal Age Discrimination in Employment Act (ADEA)? Two corporations have combined their management and operations into a single place with 30 total employees. Which type of business relationship is formed that now requires both companies to comply with federal employment law? Integrated enterprise Does the employee meet the eligibility requiremen...

Agency is a(n) __________ relationship (a legally binding agreement) between a principal and an agent whereby the principal, expressly or implicitly, authorizes the agent to work on his or her behalf and with the power to bind the principal. Undefined Informal Contract Formal Contract Before the final passage of the Civil Rights Act of 1964, Virginia Democrat, Senator Howard W. Smith, inserted into the language of the legislation defining the class of persons protected under the anti-di...

Identify the role of the National Labor Relations Board (NLRB). a federal agency given power to police against unfair labor practices and determine whether the union is sanctioned to represent the members. NLRB administers all provisions of the Wagner Act. Primary functions include: conducting union elections (make sure that they are ethically and legally conducted), investigating complaints by employers or unions through their investigations, issuing opinions on it findings and prosecuting...

According to the Principles and Standards for School Mathematics (2000), curriculum is more than a collection of activities, but rather is considered to be all of the following * focused on important mathematics. * well-articulated across the grades. * coherent in content NOT: formulated on standard methods. According to the Teaching Principle defined by NCTM, effective mathematics teaching requires: understanding what students know and need to learn The Technology Principle states that ...

An art teacher has redesigned a lesson plan that includes an assignment in which students work in groups to create and present original commercials. She plans to let the groups decide what the commercials will advertise and will encourage students to use their own experiences to make effective commercials. The students will create their own schedules for completing the assignment and she has developed a rubric for evaluating the results. How does this lesson plan align to current research f...

Drawing stages of development naturally grows in a child as a form of visual communication. The earliest stages of drawing include what 2 stages? d) Scribble and Pre-Schematic or Shape-Making Stage A Kindergarten teacher decides to integrate more music into her daily instruction. In consideration of the students' development level, the teacher should consider that primary age groups of children are able to b) See one point of view, or one aspect at a time. A natural development of drawing...