Use CA10RAM to get 10%* Discount.
Order Now
No Marks 1 pts This criterion is linked to a Learning Outcome
INSTRUCTIONS TO CANDIDATESANSWER ALL QUESTIONS
Activity 1.1:
Workbook saves as ES1-WBWeeklySales.xlsx 1 pts Full Marks 0 pts
No Marks 1 pts This criterion is linked to a Learning Outcome
Cell H6: Value entered 3157 1 pts Full Marks 0 pts
No Marks 1 pts This criterion is linked to a Learning Outcome
Cell H10: Value entered 214 1 pts Full Marks 0 pts No Marks 1 pts
This criterion is linked to a Learning Outcome
Cell H14: Value entered 774 1 pts Full Marks 0 pts No Marks 1 pts
This criterion is linked to a Learning OutcomeCell B19: Value entered 32 1 pts Full Marks 0 pts No Marks 1 pts This criterion is linked to a Learning OutcomeActivity 1.2-1.9: Workbook saved as ES1-WBPayroll.xlsx 1 pts Full Marks 0 pts No Marks 1 pts T
his criterion is linked to a Learning OutcomeCell A1-AL: Payroll label, merge and center 2 pts Full Marks 0 pts No Marks 2 pts This criterion is linked to a Learning OutcomeCell A2-L2: Week Ended label, merge and center 2 pts Full Marks 0 pts No Marks 2 pts This criterion is linked to a Learning OutcomeLabels entered correctly in cells: Sun-Sat, Total Hours, Pay Rate, Gross Pay 1 pts Full Marks 0 pts No Marks 1 pts This criterion is linked to a Learning OutcomeCells: A5-B13:
Names entered correctly 1 pts Full Marks 0 pts No Marks 1 pts This criterion is linked to a Learning OutcomeCells C5-I13: Values entered correctly 2 pts Full Marks 0 pts
No Marks 2 pts This criterion is linked to a Learning OutcomeTotal Sum column: J5-J15 AutoSum formula (C5-I5) 2 pts Full Marks 0 pts No Marks 2 pts This criterion is linked to a Learning OutcomePay Rate K column: Values entered (8.25) 1 pts Full Marks 0 pts No Marks 1 pts This criterion is linked to a Learning OutcomeGross Pay column: L5-L15 formula entered (Total * PayRate) 2 pts Full Marks 0 pts No Marks 2 pts This criterion is linked to a Learning OutcomeTotal
Row 15: AutoSum formula correct all cells 2 pts Full Marks 0 pts No Marks 2 pts This criterion is linked to a Learning OutcomeHours Proof Cell B17:
formulas entered correctly 2 pts Full Marks 0 pts No Marks 2 pts This criterion is linked to a Learning OutcomeGross Pay Proof Cell B18: formulas entered correctly 2 pts Full Marks 0 pts No Marks 2 pts This criterion is linked to a Learning OutcomeAccounting Format applied per instructions. 1 pts Full Marks 0 pts No Marks 1 pts
This criterion is linked to a Learning OutcomeWorksheet in Landscape Orientation 2 pts Full Marks 0 pts No Marks 2 pts This criterion is linked to a Learning OutcomeData sorted by Last Name. 2 pts Full Marks 0 pts No Marks 2 pts Total Points: 30 Please make the excel document look exactly like this example I uploaded. Thank you
Attachments:
Related Questions
. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C
DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma
. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an
Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t
. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual
Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th
. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:
1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of
. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:
1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of
