This is an Excel homework and all the instructions are in the attachment. There are two pieces of attachments and work doc is instructions and they are to be finished in the Excel file. Thanks! 

Ofce 2013 – myitlab:grader – InstructionsExcel ProjectProject 1 Revised CMPSC203 Penn StateProject Description:his project will be graded partially manually. The score right after uploading to MyITLab is not thetrue value. It will be modiFed after we grade your Fle. You must upload your own Fle from MyITLabto get credit.Instructions:For the purpose o± grading the project you are required to per±orm the ±ollowing tasks:StepInstructionsPointsPossible1Change the file name into Project 1 CMPSC203 Last_First.0.0002Enter your name in F2. Label F2 as “MyName”. Enter your birthday in F4, and label F4 as“MyBirthday”.0.0003On the “Date Calc” worksheet, use the NOW function in F1 to show the current date and time.4.0004Enter a formula to show the current hour in F3.4.0005Enter in F5 an if-function to show either “am” or “pm” depending on the current hour in F3.4.0006Enter in F7 an if-function to show the current hour with am/pm. For example, if the current time is13:45, it must show “1pm” after entering the formula. Use “&” in the formula to concatenate “1” with“pm”. Label F7 as “CurrentHour”.4.0007Enter in F9 a nested if-function to show “Morning”, “Afternoon” or “Evening” depending on the currenthour in F3. It should show “Morning” before 12pm and “Afternoon” between 12pm and 6pm. See thehint in H9. Label F9 as “InGreeting”.5.0008On the “Front Page” worksheet, modify a formula to show greeting with your name in B6. For example,if your name is “Barbra” and the current time is 2:30pm, it should show “Good Afternoon Brabra!”4.0009In I6, enter the formula ="Now it's after " & CurrentHour & ", " & MONTH(TODAY()) & "/" &DAY(TODAY()) & "/" & YEAR(TODAY()) &"."0.00010In F11 on the “Date Calc” worksheet, calculate the difference between MyBirthday and Today().Change its format into number with no decimal places. Label it as “AgeInDays”.4.000Updated: 02/19/20161Current_Instruction.docx

Enter your name:Enter your birthday:Good EveningNow it's after 8pm, 1/1/1901.You have lived 0 Days.About 0 minutes.Which day of the week were you born?Were you born in a leap year?How many leap years have you come across?

• 1496725674-Project.xlsx
• 1496725674-Project_1Instructions.docx

ComputerScienceExpert

(11)

Status NEW Posted 06 Jun 2017 05:06 AM My Price 11.00

-----------

Attachments

file 1496725676-Solutions file 2.docx preview (51 words )

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 -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer