SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 1 Day Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Science Posted 12 Oct 2017 My Price 10.00

In this assignment, you will format two worksheets and insert appropriate formulas

CIS 112 – Intro to ComputingMS Excel Assignment 1Due:MidnightSunday.In this assignment, you will format two worksheets and insert appropriate formulas. Please remember tosave your work as you go through the steps.The requirements for your assignment are:1.Open theUnit 5_Excel1.xlsxdocument;2.Savethe document asYour First Initial LastName_Unit 5_ Excel1.xlsx(For example:SBrown_Unit5_Excel1.xlsx);3.The “Employees” worksheet will contain the following data:4.On the “Employees” worksheet, do the following:aInsert 3 rows above row 1.bIn Cell A:1, enter the following text as the title of the worksheet:Employee’s NewSalariescMerge and Centerthe title across columns A through G.dChange the fontsize of the title to16pt5.In CellA:2,Enter your first and last name and complete the following:a.change the font size of your name to14ptb.make your nameBOLDandItalicizedc.Merge & Centeryour name between columns A & G.6.Select the text in cellsA4:G16, and complete the following:a.Change thesize of the textin cells A4:G16 to11pt
Background image of page 1
View the Answer
b.and changethe font typetoCalibri7.Select cellsA4:F4and complete the followinga.Center the text in cells A4:F4b.Make the text in cells A4:F4BOLDc.UNDERLINE the text in cells A4:F48.Select Column C and complete the following:a.Format the Hire Datesin Column C to theMM/DD/YYformat9.Select Column E and complete the following:a.Format the Salaryin Column E to theAccounting Number Format.Your worksheet should look like the following:10.Go to Cell G5 and complete the following:a.In Cell G5,create a formulato determine the employee’s new salary. (Hint:Youshould use the SUM function to add the Salary with the increase amount)b.Copy the formulayou created in G5 to cells G6:G16.c.Change thenumber formatof the values in cellsG5:G16to theCurrency format11.Select Column D of the worksheet and complete the following:a.For all the values in Column D, decrease the number of decimals for the years tozero decimals12.Save your work and submit the completed workbook in Blackboard.
Background image of page 2
View the Answer
Refer to the grading rubric below for the grading criteria.Students:Be sure to read the criteria, by which your paper/project will be evaluated,before you write, and again after you write.Evaluation Rubric forUnit 5AssignmentCriteriaBelow ExpectationsNeeds ImprovementMeets Expectations0-18 points19-26 points27-30 pointsTitle & SubtitleTitle and subtitle onEmployees worksheetwas not merged andcenteredTitle and subtitle onEmployees worksheetwere merged andcentered, but notformatted correctly.Title and subtitle onEmployees worksheetwere merged andcentered correctly andformatted asinstructed.0-18 points19-26 points27-30 pointsDate andAccountingNumberformattingDate and AccountingNumber formattingwas not completed.Date and AccountingNumber formattingwas attempted, onlyone type offormatting completedcorrectly.Both Date andAccounting Numberformatting werecompleted correctly.0-18 points19-26 points27-30 pointsNew SalaryCalculationDid not use the SUMfunction to determinethe New Salary.The New Salary wasattempted, using theSUM function, butresult is incorrect.The New Salary wascalculated correctlyusing the SUM function.0-5 points6-8 points9-10 pointsExcel documentnameFile name is incorrect. File name is correct,but saved in incorrectformat.File is named correctly.
Background image of page 3

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 12 Oct 2017 07:10 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)