+
Excel Project Project 1 Revised CMPSC203 Penn State

Excel Project Project 1 Revised CMPSC203 Penn State

Rating:
Rating
(0)
Author: matthew stock
Description:

http://homework.plus/excel-project-project-1-revised-cmpsc203-penn-state/

Project 1 Revised CMPSC203 Penn State
 
Project Description:
his project will be graded partially manually. The score right after uploading to MyITLab is not the true value. It will be modified after we grade your file. You must upload your own file from MyITLab to get credit.
 
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step

Instructions

Points Possible

1

Change the file name into Project 1 CMPSC203 Last_First.

0.000

2

Enter your name in F2. Label F2 as “MyName”. Enter your birthday in F4, and label F4 as “MyBirthday”.

0.000

3

On the “Date Calc” worksheet, use the NOW function in F1 to show the current date and time.

4.000

4

Enter a formula to show the current hour in F3.

4.000

5

Enter in F5 an if-function to show either “am” or “pm”depending on the current hour in F3.

4.000

6

Enter in F7 an if-function to show the current hour with am/pm. For example, if the current time is 13:45, it must show“1pm” after entering the formula. Use “&” in the formula to concatenate “1” with “pm”. Label F7 as “CurrentHour”.

4.000

7

Enter in F9 a nested if-function to show “Morning”,“Afternoon” or “Evening” depending on the current hour in F3. It should show “Morning” before 12pm and “Afternoon”between 12pm and 6pm. See the hint in H9. Label F9 as“InGreeting”.

5.000

8

On 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.000

9

In I6, enter the formula ="Now it's after " & CurrentHour & ", " & MONTH(TODAY()) & "/" & DAY(TODAY()) & "/" & YEAR(TODAY()) &"."

0.000

10

In 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.000


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial