Tutorelizabeth
On this page, you find all documents, package deals, and flashcards offered by seller Tutorelizabeth.
- 358
- 0
- 0
Community
- Followers
- Following
358 items
WGU C268 Spreadsheets with Complete Solution
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?
- Exam (elaborations)
- • 5 pages •
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?
WGU C268 Spreadsheets with Complete Solution Rated A+
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
- Exam (elaborations)
- • 6 pages •
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
WGU C268 Spreadsheets Questions and Answers Already Graded A+
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...
- Exam (elaborations)
- • 11 pages •
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...
WGU C268 Spreadsheets Latest Graded A+
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,
- Exam (elaborations)
- • 12 pages •
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,
WGU C268 Spreadsheets Final OA Study Guide Questions and Answers Already Graded A+
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
- Exam (elaborations)
- • 9 pages •
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
WGU C233 Study Guide – Vocabulary 100% Correct
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...
- Exam (elaborations)
- • 8 pages •
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...
WGU C233 Study Guide - Strategies for the Workplace to Prevent Discrimination and Limit Employer Risk
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...
- Exam (elaborations)
- • 4 pages •
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...
WGU C233 Employment Law Vocabulary and Latest Graded A+
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...
- Exam (elaborations)
- • 14 pages •
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...
WGU C233 Employment Law Topics 1 & 2 Already Passed
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.
- Exam (elaborations)
- • 7 pages •
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+
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...
- Exam (elaborations)
- • 5 pages •
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...